I am working on an updated version of the Morningstar fundamentals downloader to work with global stocks. I hope to upload it if and when it is finished. It makes sense to be able to access the price data of the tickers from the each of the three scripts (url script, pre-script and post-script).
What can we do with access to price data and other database data?
We can reduce the number of downloads each week from 30k+ to a 5k-. We can also skip adding database bars when there is no new data. This would reduce the database size by over 95%.
How?
By eliminating downloads of fundamentals when ...
a. There is no recent price data or the price data shows that the stock is illiquid.
or
b. When it is too soon after the most recent financials to look for updated information.
... and by ignoring new data if the fundamentals remain unchanged.
As it stands now it looks like we would need to create a Script in the Script Editor if we would want to do all this. Is this something that would be difficult to add to the API for the downloader script?
It seems that for fundamental data which gets updated every few months or so on a somewhat predictable schedule, by having access to the databases we can eliminate 90%+ of downloads.
How would this data eliminate downloads? By adding a field to the Morningstar database called "next update date". This "next update date" would be set to the date of the most recent financial period + 3 months. Then, the downloader would check if today's date is past the "next update date" before downloading data.
I see what you need but this is only possible using the script editor now. You could check for the last date entry for each symbol, take symbols that should be updated and then call the downloader using these symbols.
But I agree that this is a nice feature to add. We can add a field where you can enter the "date" field to check (quotes or any custom db) and add a specific interval.
Trading financial instruments, including foreign exchange on margin, carries a high level of risk and is not suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to invest in financial instruments or foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with trading and seek advice from an independent financial advisor if you have any doubts.
0
