If you want real-time prices and more comprehensive data, consider using financial APIs like Alpha Vantage, IEX Cloud, or Yahoo Finance. These services often provide more detailed and up-to-date information, though they might require some technical setup and, in some cases, a subscription.
@Sujata there is no need to diversify as in momentum strategy we get the stocks that are in momentum irrespective of the sectors as we are finding amongst smallcap 250.
It is quite possible that some sectors are not doing great but some stocks are doing fine with momentum strategy.
If some sector is in tailwind, we could get maximum stocks of that sector, then it cannot be called as diversified pf, I am finding solution for that. Any takes.
@Sujata Very well said by @Anand_Jain. This is the advantage of momentum investing. If a sector or a stock is in favour, it will come in our radar immediately. As we are looking to rebalance every week, we are alert all the time and change our pf depending on what is moving. There can be nothing better than this.
@Sujata You can choose 10 from each. However, please remember that each one is different and hence it is not a basket of 30 momentum stocks, but 3 x 10 momentum stocks.
If your system can process 650 stocks (Midcap150, Smallcap 250 and Microcap250), then you can take Nifty 750 and remove Nifty 100 from that. Then take top 30 from that. This will be a proper 30 stock momentum pf.
@Anand_Jain It will not be the same. Nifty 500 includes top 500 stocks whereas @Sujata’s universe excludes top 100. She is looking at bottom 650 out of Nifty 750.
That is really fantastic, but in your absence, the pf of honored contributors of this thread were not matching, reason being data disturbance, please provide us alternate resources plan to execute the stuff.
You are like a mentor use to guide us through, many thanks for that.
I continue to see the values extracted by Google Finance changing.
I had to download bhav copies.
Last 2 days bhav copies available on NSE site.
From 10th to 12th June, I had to download the bhav copies from samco.in
I then integrated values from bhav copy into our sheet.
Therefore, I am confident of data from 10th to 14th. The previous week make still have some errors; I will try and fix it the same way over the next few days. I don’t think it will materially change the list very much.
Will check again coming weekend to see if the problem still persists.
Once we learn how to do this, the entire process is not too difficult. If people are interested, I can do a quick video to capture this process.
Hi @visuarchie Sir,
I have checked every date value with Google Finance and Yahoo Finance for each day.
I can confirm all the data is correct from my side and there is 1 issue I found that is causing this changing data from Google Finance.
googleFinance function returns 2 rows but sometimes it returns 3 rows and our index function is picking 2,2, causing the same data to be picked for different dates.
Please find an updated formula which I tried in my sheet.
=INDEX(GOOGLEFINANCE(“NSE:”&C$4,“price”,$B7-1), ROWS(GOOGLEFINANCE(“NSE:”&C$4,“price”,$B7-1)), 2)
I got the same list as yours, but the order is different for some stocks.
Doubt: You have not made price changes for last week, which can cause the order to be different as we are considering 1-year and 6-month data in the standard deviation formula.
I downloaded the data from Bhav copies and verified them for the 3rd and 14th of June.
No difference I found in the price for these 2 dates.