Thank you, Chaitanya, I use google sheet, screener utility is not there in my model. I use the condition
-
Nifty spot 50 EMA> 200 EMA condition for momo pf active, when it breaks then
2/3 will be in Gold, 1/3 will be in liquid bees.
Creating a momentum portfolio using Google Sheets involves using the GOOGLEFINANCE function to pull in live and historical stock data. Here’s a basic outline to get you started: -
Set Up Your Sheet: Create columns for stock ticker symbols, current prices, historical prices, and relative strength calculations.
-
Import Live Data:
- Use the formula
=GOOGLEFINANCE("ticker", "price")
to get the current price. - For historical prices, use
=GOOGLEFINANCE("ticker", "price", DATE(year, month, day))
.
- Use the formula
-
Calculate Relative Strength:
- Determine the recent and medium-term performance. For example, if you want to compare the price from 30 days ago to today, use the formulas
=GOOGLEFINANCE("ticker", "price", TODAY()-30)
and=GOOGLEFINANCE("ticker", "price", TODAY()-90)
. - Calculate the percentage change:
=(current price - historical price) / historical price
.
- Determine the recent and medium-term performance. For example, if you want to compare the price from 30 days ago to today, use the formulas
-
Rank Stocks:
- Use the
=RANK
function to rank stocks based on their relative strength. - Sort the stocks from strongest to weakest.
- Use the
-
Update Automatically:
- Google Sheets can update the data automatically, ensuring your momentum portfolio reflects the latest market information.
For detailed guidance and examples, you can check out resources from Tradinformed, Trade Brains, and Invest Some Money, which provide step-by-step instructions and use cases [❞] [❞] [❞].
@ChaitanyaC as I am occupied with some important stuff, may not be replying for some time, please if you could manage the queries, I will try to be back soon.
Subscribe To Our Free Newsletter |