@9916673623 is working on automating this process. He has made significant progress in that. While validating his programme, we found an error in the listing that I had.
I have corrected and posted it again, thanks to @9916673623.
Once his programme is completed, it can be applied to any index and for any look back periods. Wonderful work that he is doing.
@visuarchie you shared your great thoughts and strategies in this ValuePickr forum. Just adding few more enhancement points for your strategy sir. Anyway thanks for your appreciation sir. We will keep improve the automation process together sir.
Good morning sir you and @visuarchie sir both are doing fabulous job. If possible do share details of automation product, so people like me and others who are not technology expert can also invest in this strategy without making mistakes.
Thank you both of you
Hi @9916673623
If you don’t mind let me know what are you trying to do in Python. As in, are you planning to do everything inside Python
Automate the entire process of downloading the Bhav copy
Identifying which stocks to enter and which to exit
If yes, I believe the whole automation can be done inside Google sheet itself. I am trying to see if that’s possible. I am at a very early stage of development. Started today only and am facing a few issues so dont want to stop your progress.
Working with Yahoo Finance. There are differences in the numbers between Yahoo Finance and Google Finance. Numbers with Google Finance are correct and match with NSE data.
Yes, will provide a table with the top 20 or 25 stocks that meet the criteria.
If you can do within Google Sheets itself; excellent!
Hi @araman, I have quite good experience and expertise in Google sheets. We can connect and work on this together if you are willing.
@9916673623 I use kite historical API. And have developed few algorithms too. Let me know if I can also join you and help in whatever way possible.
In case the Google sheet method works then we can try and create historical investments and weekly and CAGR for everyone’s benefit. If Google sheet can’t be used we can perfect the entire process in python along with historical investments and returns.
I’ve automated the process using two Python scripts—one for fetching data and the other for ranking stocks. I tested it on the smallcap momentum portfolio, and it produced the same list of stocks as shared today, except for HSCL.
Challenges encountered:
The Jugaad Data library doesn’t automatically account for stock splits, so the base file needs to be updated manually.
NSE data is missing for some date ranges. For example, HSCL’s data from January 9, 2024, to February 28, 2024, is unavailable on the NSE website. As a result, the library couldn’t download the data, and HSCL didn’t appear in the top 20 list. There could be similar cases.
Absolutely!!! Lets collaborate.
If we script generically enough, we might be able to get the same sheet to work for both large. mid, small and micro caps, though we could initially limit our focus to small and micro caps as that’s in focus here.
We can message privately and then post back here once we have something meaningful to share
These problems will keep occurring if we rely on non api data I guess. Google finance data can be used if we connect the script to a Google sheet. Also I don’t mind using my own kite historical API once a month for this purpose.
@visuarchie Except one, I was able to match all other names in your list with the sheet I was working on. Can you please check if JYOTICNC should be really ranked so high.
In the sheet I was working on, it was ranked 47 while looking at a lag of 12 months and 153 while looking at a lag of 6 months.
My sheet asked me to go with OPTIEMUS
Not suggesting that your list is incorrect. You have been at it much longer and its quite possible I am making some silly mistake
@araman i am trying to use yahoo finance library . Data is not accurate. other than that most of things are OK. if you are able to do using Google sheet , that excellent.