@VeeraBrahmam 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 @VeeraBrahmam.
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.
You are doing automation using any programming language or something else.
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
We are using python to automate the momentum pf
Still under development , we need to do enhancements.
Still not sure how to share for all members in ValuePickr
Hi @VeeraBrahmam
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
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.
@araman Answering on behalf of @VeeraBrahmam
If you can do within Google Sheets itself; excellent!
Update for entry on 26th August 2024 (look back dates: 25/08/2023 and 23/02/2024)
50EMA (23618) > 200EMA (20593); hence, we can continue without any change.
Based on ranking:
Based on A → Z for easy tracking:
Exits:
DHANUKA, GRWRHITECH and KPIGREEN make an exit.
NETWEB, RTNPOWER and SUDARSCHEM stay within the top 30 and hence remain.
Entries:
JYOTICNC, LTFOODS and UFLEX make an entry.
IIFLSEC, KESORAMIND and TIDEWATER cannot enter as there is no vacancy.
Hi @araman, I have quite good experience and expertise in Google sheets. We can connect and work on this together if you are willing.
@VeeraBrahmam 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:
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.
NSE data comes in multiple categories, EQ, BE etc. It is quite possible for the dates that you are referring to, the stock has gone to BE category.
When you want to check the data on NSE, click to show all categories and then it should be fine.
Very happy to see people willing to collaborate on developing this further. Power of community sharing.
@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.
@visuarchie i am not focusing on correcting yahoo finance data. right now when ever i am getting time i am trying work on below points.
Note @ my code o/p mostly matching with u r publishing list.
@araman JYOTICNC is in top-15 list
OPTIEMUS is in top-27 position in my list
JYOTICNC shared were listed on 16-Jan-2024 and hence a 12 month lookup isn’t possible. Jyoti CNC Automation Limited (JYOTICNC.NS) Stock Historical Prices & Data - Yahoo Finance
Just FYI - I am explicitly discarding shares that don’t have a 12 months history
