Third-party Quote and Exchange Rate Program from hleofxquotes.

derekkent23's Avatar

derekkent23

01 Jan, 2018 11:16 AM

I am not support staff, just a user.

I am a UK investor and have found that Alpha Vantage provide very poor support for UK/Irish/Luxenberg etc, domiciled funds.
I am currently testing a stand-alone program that was originally developed to help out users of MS Money when Microsoft stopped supporting that product. The developer is in the beta stages of adapting it to work with Moneydance. When I say beta, this build as far as I can see is very stable and the quotes very consistent. No strange prices or for UK funds switching back and forward between Pence and Pounds. It has a lot of useful features. These include, obtaining prices from many stocks and fund quoted on different exchanges. The ability to convert quotes from one currency to another. Convert prices in Pence to Pounds, if required, for UK stocks and funds. Provide a means for importing all this data into Moneydance. Importing exchange rates.

Anyway, download the attached PDF, use the links to download the programs and follow the instructions on how to use.

Please keep this thread to this subject on how to use the program, hleofxquotes in association Mike Brays Security Price Loader and how to import the data into Moneydance.

Please provide feedback on how well UK, Mainland Europe, USA and Canadian stocks and funds are covered.

Hope this helps.

ALWAYS CHECK TO SEE IF THERE IS A NEW PDF IN A LATER POST!

Showing page 7 out of 7. View the first page

  1. 181 Posted by derekkent23 on 12 May, 2018 05:14 PM

    derekkent23's Avatar

    HI hleofxquotes

    That works great!

    On your example “If we have BCH-EUR, EURUSD=X, USDGPB=X and base rate is GBP, we will generate BCDGPB=X” shouldn’t GBPEUR=X be included. Also maybe a typo BCDGBP=X be BCHGBP=X?

  2. 182 Posted by Neil B on 12 May, 2018 10:30 PM

    Neil B's Avatar

    Hi again,

    I have been using hleofxquotes very successfully for several months now. It has worked very well, until recently. I usually update weekly, and my latest .qif file was not successful in updating my MD file. None of my stocks uploaded, but my unit trusts did! I'm totally confused, since I have done nothing different. Any thoughts would be gratefully received!

    Thanks in advance,

    Neil

  3. 183 Posted by derekkent23 on 13 May, 2018 07:37 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi Neil

    Can you confirm your computers operating system?
    Which build of Moneydance are you running, see under HELP – ABOUT MONEYDANCE e.g. 2017.7.1(1671).
    Have updated Moneydance since your last successful QIF import?
    Which build of hleofxquotes you are using?
    Can you post your QIF file?
    Can you indicate which symbols loaded prices or didn’t load prices which ever is the shortest list?
    Can you confirm this is the first time this has happened?
    On the day you tried to load the QIF file or the day before did you open the affected security price history window.
    Did you import a QIF within three days of your import attempt?
    Did any of the prices in the QIF file have the same date at a price in its associated security price history window?

    Let’s see if any of your answers throw up any pointers to the problem.

  4. 184 Posted by Neil B on 13 May, 2018 10:45 PM

    Neil B's Avatar

    Hi Derek,

    Thanks for responding so quickly. My OS is Widows 7, MD version = 2017.6.(1656), Hleofxquotes 0180103_172. The only securities to update were the funds - starting "GB". All the other shares did not update, and this was the first problem I have run into since January . I made the qif file, and imported almost immediately. However, I did open quite a few of the security price history windows, since I have been away and wanted to check if they were up to date. Perhaps this could be the cause of the problem?

    I have just tried loading this same QIF file into a copy of my MD file I made back in January. It seemed to work perfectly, so I guess the qif file is fine.

    Thanks again,

    Neil

    PS my qif file was blocked from sending, so I have pasted a section of it below:

    "CTY.L",4.3350,"5/11'2018",,,
    "EMG.L",1.9160,"5/11'2018",,,
    "EPO.L",0.0912,"5/11'2018",,,
    "ESUR.L",2.2500,"5/11'2018",,,
    "FJV.L",1.5675,"5/11'2018",,,
    "GB0004521620",2.4278,"5/11'2018",,,
    "GB0030881550",2.2900,"5/11'2018",,,
    "GB00BLRZQ737",1.2350,"5/11'2018",,,
    "GB00BLRZQC88",1.2401,"5/11'2018",,,
    "GOCO.L",1.2600,"5/11'2018",,,
    "IEM",2.6400,"5/11'2018",,,
    "LAND.L",9.7770,"5/11'2018",,,
    "LLOY.L",0.6708,"5/11'2018",,,
    "LWI.L",15.6500,"5/11'2018",,,
    "MKS.L",2.9330,"5/11'2018",,,
    "MRCH.L",5.2300,"5/11'2018",,,

  5. 185 Posted by derekkent23 on 14 May, 2018 08:49 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Make a FILE – EXPORT BACKUP.

    First, I would update Moneydance to the latest release build 2017.7.1(1671) from https://infinitekind.com/download-moneydance-personal-finance-software

    Also update Hleofxquotes Program to build 206. Download the latest PDF from http://help.infinitekind.com/discussions/investments/3036-third-par...

    And use the link in the PDF to download Hleofxquotes Program.

    It’s a got idea to keep your software up to date.

    It could be the fact that you opened the Security Price History window of the subject securities. There are some Moneydance rules that prevent QIF imports if the software thinks a security has been updated on the same day as the date in the QIF file.

    By the way you should be able to post your QIF file on the forum. I presume you tried to attach it to an email.

    Anyway, I have taken your list of data and turned it into a CSV file. Hope the list you posted was the full list. If not post your QIF file on the forum in this thread http://help.infinitekind.com/discussions/investments/3036-third-par...

    Used Mike Brays Security History Loader to import the CSV file into Moneydance and your price history should be back as it should be. Link to Mikes Download site is in the PDF as is how to use his extension. I prefer this method over using a QIF file.

    I set up the first 4 of your securities in Moneydance just using the Symbol as the security name and tested using Mikes extension. See screen shot. Imported with no problems.

    If you have any problems please post and, in any event, let me know how you get on.

    Hope this helps.

  6. 186 Posted by Neil on 14 May, 2018 09:28 AM

    Neil's Avatar

    Hi Derek,
    Many thanks for your thoughts and comments. I'm just about to go away on a business trip, but will update the software as you suggest, and will also give Mike Bray's uploader a go when I have a little time.
    In the meantime, I have just generated a new .qif file. Nothing is uploaded into my MD file, although all securities are imported successfully into my January copy! I fear my MD file could be corrupted?
    Thanks again,
    I'll be in touch when I have a little more time to carry out some of your suggestions.
    Best regards,
    Neil

  7. 187 Posted by derekkent23 on 14 May, 2018 09:52 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi Neil

    Hopefully you followed the instructions in the PDF to make a EXPORT – BACKUP before importing a QIF file or have a more resent set of backups. If you have auto backup set under FILE – PREFERENCES -BACKUPS put a large number in the “keep no more than” box so as not to lose older auto backups.

    Hear from you when you get back

  8. 188 Posted by derekkent23 on 16 May, 2018 08:53 AM

    derekkent23's Avatar

    Post text deleted due to error as outlined in Mikes post 189.
    Disregard the attachments in this post.
    See new post 190

  9. 189 Posted by Mike Bray (a us... on 16 May, 2018 09:00 AM

    Mike Bray (a user not support)'s Avatar

    Hi Derek

    This note is very helpful and as are the PDFs. One slight error in the
    first PDF. On page 4 the image of the price screen has 'Security
    History Loader Only' pointing at the ticker, it is the date that is
    extra. The ticker appears on both extensions.

    Regards
    Mike

  10. 190 Posted by derekkent23 on 16 May, 2018 09:18 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    NEW BUILD RELEASE “Build_20180512_207”

    To receive Email updates on this thread, ensure the box at top right of page has been set to SUBSCRIBE.

    This free stand-alone program was originally developed to help out users of MS Money when Microsoft stopped supporting that product. The developer has adapted it to work with Moneydance and is actively supporting the program. This build, is very stable and the quotes very consistent with the option of two sources, not Alpha Vantage. No strange prices. The program delivers the last traded price, not a price history, thus it does not overwrite your existing history. It provides quote for stocks & funds, from many stock exchanges US, Canada, UK, Europe and Australia to name but a few. Provide a means for importing all this data into Moneydance. You can also import exchange rates along with your security prices. The program is in java, like Moneydance and thus runs on Windows, Mac and Linux computers.

    UPDATES
    1. In the program a selection has been added under EDIT – EXPORT – SET MD CSV INCLUDE QUITE SOURCE NAME. TRUE results in the exported name of the CSV file containing the quote source. Two different files are exported. FALSE results in only one file name being used that does not include quite source name. Be careful export from one source will overwrite an export from the other source if the same save location is used.
    2. The Program has been updated to handle Cryptocurrencies in a new way expanding the range of cryptocurrencies that can be downloaded and imported into Moneydance.

    Download the attached updated PDF, use the links to download the programs and follow the instructions on how to use.

    If you are using Mike Brays extensions you must also run the latest build of the Security Price Loader and/or Security History Loader extensions, see PDF for link.

    You must also update to at least the latest released build of Moneydance 2017 at https://infinitekind.com/download-moneydance-personal-finance-software to ensure compatibility.

    Also attached is a second PDF that covers the creation and importing of Cryptocurrencies and Market Indices such as the Dow Jones Industrial Average, FTSE 100 and Canadian S&P/TSX into Moneydance.
    NOTE PDF “Hleofxquotes Program used with Moneydance Cryptocurrencies and Market Indices V2” has been updated in post 191.

    Please keep this thread to this subject on how to use the program, hleofxquotes in association Mike Brays Security Price Loader and how to import the data into Moneydance.

    Please try this program and if you find it useful please take the time to post comments and outline any problems you may find.

    Please provide feedback on how well UK, Mainland Europe, USA, Canadian, Australian and other stocks and funds are covered.

    Hope this helps.

    Note: the link in the PDF takes you to the programmer, hleofxquotes, development site. This site lists the current released build for download, along with a number of other folders. The folder “old” contains old released builds. The folder “test” contains builds under development that are not ready for release and may contain bugs.

    ALWAYS CHECK TO SEE IF THERE IS A NEW PDF IN A LATER POST!

  11. 191 Posted by derekkent23 on 18 May, 2018 09:27 AM

    derekkent23's Avatar

    UPDATE to V2 of the following PDF

    “Hleofxquotes Program used with Moneydance Cryptocurrencies and Market Indices V2”

    Attached is a PDF that covers the creation and importing of Cryptocurrencies and Market Indices such as the Dow Jones Industrial Average, FTSE 100 and Canadian S&P/TSX into Moneydance.

    Update: corrects the way Market Indices are created so that other summary page values such as Net Worth are not impacted.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Hleofxquotes_Beta_Program_used_with_Moneydance_V2.pdf 565 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac