Mike, Derrik, HLE,
Any chance that the next revision of Quote Loader will handle High/Low/Volume data for equities as well? I keep dreaming that Sean (or someone) will add some plotting analysis features to MD and having that data for candle plots etc. would be great. This is one feature that the Quote and Exchange Rate Loader does that the new Quote Loader does not.
Quote Loader is a third-party extension that has been reviewed and signed by Infinite Kind (Moneydance).
For Moneydance 2019/2020 latest Quote Loader build is 3026.
• Add new feature to retrieve historical data for Exchange Rates and Cryptocurrency Exchange Rates.
• Update PDF “Quote Loader Extension by Mike Bray Moneydance 2019-2020” to V9.1
• Update PDF “Quote Loader Extension, Moneydance 2019-2020 Handling Cryptocurrencies and Market Indices” to V4.1
EXISTING USERS using Quote Loader with a build number lower than 3021 should REMOVE (uninstall) all Extensions under EXTENSIONS – MB EXTENSION INSTALLER, lastly removing (uninstalling) MB EXTENSION INSTALLER itself by using the REMOVE buttons.
The background folder “.rhumba” is redundant, expert user can if they so wish delete the “.rhumba” folder with Moneydance closed. On installing the latest Quote Loader a new replacement folder “.qlmeta” is created. MB Extension Installer is no longer required to install Quote Loader.
As a signed extension Quote Loader can be found under EXTENSIONS – MANAGE EXTENSIONS.
Simply click EXTENSIONS – MANAGE EXTENSIONS – AVAILABLE tab, find Quote Loader and click install or update.
Once installed re-start Moneydance - installation complete.
Quote Loader was developed and is supported by Mike Bray.
PDF’s and Video by Derek Kent.
The system provides an end to end solution, obtaining quotes from a choice of sources and entering them into the relevant Currency/Security History window, all from a single window within Moneydance. The system can obtain Security Prices, Exchange Rates, Market Indices, Cryptocurrency Rates and prices for Cryptocurrency Investments. The system provides quotes from many stock exchanges, US, Canada, UK, Europe and Australia to name but a few. The process of obtaining quotes from the selected source is fast and error free.
Download the attached PDF, follow the instructions on how to use Quote Loader.
The PDF also contains links to a Quick Start Video Guide, a Short Tutorial Video and a Full Tutorial Video, all on YouTube.
The second PDF covers the creation and importing of Cryptocurrencies and Market Indices into Moneydance.
Acknowledgement to Kevin N and dwg for their support during development.
Please keep this thread to this subject on how to use Quote Loader.
Please try this approach and if you find it useful please take the time to post comments and outline any problems you may find.
To receive email notification to updates on this thread, click the SUBSCRIBE button in the box at the top right of the forum page.
Hope this helps.
ALWAYS CHECK TO SEE IF THERE IS A NEW PDF IN A LATER POST!
Mike, that would be great. I assume that there isn't a High/Low values until the end of the day. And they only exist for equities and ETFs and not Mutal Funds that transact at the end of the day. Those limitations are built into the financial system.
I still use the Alphavantage built in quote loader that doesn't load anything for the day until the end of day values are posted.
are you guys trying to make MD an equity trading analysis tool?
Can we just stick to MD keeping track of what we monies we have where? Why would one need to track days high/low and volume in an accounting software app?
@Fred, well if it was just a checkbook tracker you might be right. But MD is a "Personal Financial Manager". This includes tracking and evaluating investments as well as keeping your checkbook balanced. If you have more limited needs, that is fine. But I don't think that sticking to that simple task is what MD is designed and marketed for.
Maybe you don't realize that MD already does track the daily high and low and one can (and I do) import qif files with that data. This is already a supported feature of MD and asking if a 3rd party extension can also support that feature is not really a misdirection of resources from your checkbook balancing needs.
You should look for developers (or become one yourself) that are interested in those keeping track of monies features that you wish to add through extensions. That is certainly not the extension that this thread is concerned with.
You are right, it is a Personal Financial Manager, which I have been using for over 10 years for that purpose. More bells & whistles is great - for Financial Management.
I for one expressed the wish, and communicated in this thread with Mike - our champion - that Quote Loader, or MD for that matter, expands to load prices for Fixed Income/Bond holdings, which in my humble opinion is a needed Financial Managment tool expansion, higher up in the list of things of "nice to have" than tracking high/lows & volumes.
We are all so lucky to have Mike kin particular when IK seems to be in hibernation.
Best regards, in any event :-)
Fred, I wouldn't be that hard on Sean, there are continual incremental upgrades to MD and note that for both Mike and Sean this is not their day job.
The problem with expanding QL is the data source. This is something HLE started for use on MS Money. My guess is that data source is not particularly encouraged since Yahoo and Google stopped providing quotes. Expansion of downloads may show up on the radar of the owning organization and cause loss of that source. Or maybe not.
The problem with prices is having a reasonable source for them. There is a small group of users working with Mike that do things like documentation (Derek) testing the software, offering ideas, suggestions, proof reading etc.
You can see Quote Loader has provision for 2 sources today, in group discussions others have been suggested, but investigations have proven that they are not suitable for use for a variety of technical reasons. So far I do not believe any source for bond pricing has been put forward that has wide enough coverage for it to be viable, it has been a conscious decision to avoid country specific sources - after all Moneydance is sold around the world, or where it is technically feasible to be able to reasonably extract the prices from the source.
QL can only capture what is available on the web page. It basically
sends a request to the source for the web page for a security and then
extracts the price/trade date/currency from the web page. High/Low
figures are available on the Yahoo and FT Historical pages but not on
the current price pages. The web page on each source is constructed
differently so I have to analyse the page source, find the data I want
and then construct an algorithm to extract the data. So adding sources
is not a trival job and I will need a compelling reason to do it, eg.
several users requesting it. I can only capture what is on the page.
As sth has said the author of hleofxquotes did the original work on this
which I have continued.
There is an issue with Yahoo, it updates its pages constantly. If my
request hits the Yahoo server as it is updating the page I want then the
quote fails. Not much I can do other than try to rerun the request
which could get into a loop if the user puts the wrong ticker into MD.
Last point, QL operates as if it is a user, ie. Yahoo and FT receive my
requests as if I had typed it in a browser and replies accordingly.
With the success of QL there is a danger that Yahoo and/or FT notice the
high demand and do something to curtail it as AlphaAdvantage has
throttled its service. If Yahoo or FT change their web page
construction QL will stop working.
I will continue to support this as long as I am able.
Thank you Mike for chiming in. We love your work!
There could be, maybe, an other way to get the security quotes: fetch it from the actual financial institution where the user is holding his securities.
As we mentioned in an earlier input in this thread, MD is a Personal Financial Management software. I use it, like probably the majority of users for doing my personal accounting and for tracking my net worth - the fundamental function and promise of MD.
Like most people, I am holding all my stock & bonds at one (1) financial institution, Fidelity Investments in my case. So, instead of going to Yahoo or FT (for as long as we can), could QL be configured to fetch the prices from ones’ financial institution, similar to what we can do with Mike’s Security Price Loader? No more threat of loosing access to Yahoo/FT, and the process would fetch prices of stocks AND bonds.
Of course and most likely, downloading prices from ones’ financial institution may not provide additional data like high/low and volume. But why would I need these additional data to track my Net Worth in my Personal Financial Managment software?
I strongly feel that Moneydance should stick to its fundamental premise as stated above. I just don’t see how watching (& storing) the days' high & low and volume tells me anything about my net worth - for me, a useless look into the rear view mirror.
Making investment decisions typically would/should require much more than analyzing the days' high/low and volume, and such data is easily available on the web or from one’s broker.
Now then, if it makes some users happy, sure track that data. But for prioritizing the software developers’ attention and work, I would rate this at the bottom of the list. Near the top of that list, I would put a facility track not only stocks and funds, but also bonds.
THANKS to everyone who contribute to the continued development of MD and its extensions.
P.S. I had no idea that Sean’s work on MD is not his day job. Has Sean become the only ‘official’ developer for MD? What triggered my words is that we just passed the middle of the year 2020 and the formal MD release is still 2019.3 (1880), while Previews shows build 1915…
It seems to me you are arguing for something you already have, Mikes Security Price Loader.
As you have your investments in one place and you infer they provide data in a format that Security Price Loader can help import into Moneydance you already have the tool you need. You have no need to install Quote Loader or use it.
The purpose of Quote Loader is to provide a solution to users like myself who depend on obtaining security prices from publicly available sources on the internet. Quote Loader in conjunction with Moneydance allows me to do my personal accounting and track my net worth. Before Quote Loader and its forerunner, I spent hours on different web sites entering security prices into a spread sheet before transferring the data to Moneydance.
Different users have different needs, it seems we both have the tools we need thanks to Mike.
QL is a nice piece of work and shows a lot of work by Mike and HLE to pull the data correctly from the web pages. As long as the usage does not raise alarms and drive the data provider into a cat and mouse game of tweaking the web page to prevent this QL will continue to work. That software has really filled a need quite well.
Setting up to work with a bunch of different financial institutions with login issues etc. seems to be a whole 'nother project.
It’s one Sean tried to do with the Moneydance embedded java browser back at the end of 2018. To log into banks etc and download statements and enter transactions directly into registers. I surmise due to the difficulties, as you say with different financial institutions with login issues etc its only ever worked with a small number of institutions and then for me not constantly. As its never been developed as planned I suspect the difficulties were too great to warrant further effort.
As stated by forum members Mike Bray & sth respectively...
With the success of QL there is a danger that Yahoo and/or FT notice the high demand and do something to curtail it as AlphaAdvantage has throttled its service.
As long as the usage does not raise alarms and drive the data provider into a cat and mouse game of tweaking the web page to prevent this QL will continue to work.
Perhaps it should be suggested (maybe in the QL instructional PDF file) that those who are intending to make use of QL should sign up for a Yahoo account and / or a Financial Times account so as to, let's say, throw them off the scent.
Hi derek and sth,
I understand the possible issues and variability of pulling data from a number of financial institutions and we can also say that here are a few, can i say dominant houses, maybe less than the large number of banks MD caters to. In my case (with Fidelity Investments, one of the very big global houses),
I can download without problems the transactions for my 5 accounts there through the MD Online/Download All Accounts menu action - which tells me that MD has a way to get data from my institution.
My holdings are currently 41 stocks/mutual funds and 12 bonds and I update my portfolio once per week and reconcile monthly. Hence, also weekly, I use the Security Price Loader (THANKS Mike) to update the prices of ALL my holdings, which I can easily get by logging into Fidelity to download a csv files of Last Price (and more data). So yes, I have a way to get my data, albeit in a simple but multi-step process.
It is a very common wisdom that the average investor should have a portion of his investments in stocks and another portion in bonds, with the ratio between the two depending on the investor’s age. I would therefore venture to say, that the average MD user who has an investment portfolio most likely owns stocks and bonds. Maybe some readers of this thread could share their types of holdings, or am I the only MD user who holds some bonds?
Moneydance does not necessarily have a yearly release, for example there was no Moneydance 2016 or 2018. Build 1915 is being called a MD 2020 release, but I believe that is largely due to Moneydance using a different source for its Java build now as well as the reintroduction of a Windows 32-bit version (largely I think for the Surface PRO X) that the different Java build facilitates, rather than offering a new range of features.
The last couple of months AlphaVantage has been intermittent in its ability to get prices for my security. It finally stopped on 22nd June and trying to lookup the Ticker Symbol shows that they don't list it anymore.
Anyway, that spurred me on to having another go with Quote Loader.
It all worked a treat and so I would like to pass on my thanks to Mike, derrekkent23 and dwg and everyone else involved. Excellent work!