I am following the methodology popularized by William O’Neil, Mark Minervini , David Ryan which is CANSLIM(or some extension of it). The core of strategy is to look for price action template coupled with 3 fundamental ratios’ growth (Revenue, Earnings and Margins which are collectively called 3Ds) to invest in best possible growth companies.For Price action + Chart template I have created scanners in screener.in which I check daily for interesting chart patterns. Now for fundamental side, I need valuable input from members. To get a view of shortlisted/watchlist/already bought candidates, currently I am using google sheets with googlefinance api+custom scripts to list their 3D ratios, but it is an ineffective way for following reasons:
-
Google sheets are very slow in their execution as my scripts contain many importXML calls which slows the results…
-
Any small changes in cells trigger execution for whole sections, hence not optimized/desired solution.
-
I want to see and compare competitor financial ratios in single view to better analyze the picks rather than only single stock.
-
It will be additional benefits, but need to include other price parameters/insights like relative strength, industry strength, promoter holding trend etc. in single view
.For above use case I want to build a dashboard which will be an open project and I will love to keep the source code open and the tool available to our members. I need the technology suggestions on how shall I proceed to build this Dashboard, from where can I source free of cost financial data/API and anything more we can add into it. looking forward for insightful suggestions. Thank you.