How to automate the tracking of ratios and other values for a set of stocks or ETFs?
I'm interested in monitoring a set of financial products (say ETFs WLOG) continually (but not continuously).
My current plan is the following. Say I want to survey the top ten Large Cap Growth Equities ETFs at etfdb.com/etfdb-category/large-cap-growth-equities/. Moreover, I want to supervise their Price-Earning ratio, Price-Book Ratio, Beta and other variables delineated at www.forbes.com/sites/johndobosz/2013/09/25/10-ratios-to-make-you-money-in-stocks/.
I'd then create an Excel spreadsheet with the ticker symbols and a column for each variable. Afterwards, whenever I want to update information, I'd research each stock individually and then edit my spreadsheet, research the next stock and edit my spreadsheet for that stock, ...
How could I do this much more productively and with less time? Xtf.com's premium version may tender this, but its gratis version doesn't and I'd be grateful for free assistance:
(1)1 Comments
Sorted by latest first Latest Oldest Best
Spreadsheets need not be static, they can pull data from the web.
This article describes the method you seek.
Terms of Use Privacy policy Contact About Cancellation policy © freshhoot.com2025 All Rights reserved.