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 8. 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 on 16 May, 2018 09:00 AM

    Mike Bray '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 V3” has been updated in post 194.

    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.

    NOTE PDF “Hleofxquotes Program used with Moneydance Cryptocurrencies and Market Indices V3” has been updated in post 194.

  12. 192 Posted by mikemink1 on 24 May, 2018 11:03 AM

    mikemink1's Avatar

    Works for me! I used Mike Bray's Security Uploader extension on my Mac, and the Yahoo source for the hleofxquotes to create the MD CSV file (the FT gave me one incorrect security). Initially, the instructions looked overwhelming, but I found them to be just overly detailed for my purposes. Using this method has proven to be faster than waiting for the Quotes and Exchange Rates extension to plow through my 45 holdings.

  13. 193 Posted by derekkent23 on 24 May, 2018 11:49 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi Mike

    Just for the record the correct symbol when using FT for VanEck Vectors Fallen Angel High Yield Bond ETF is ANGL:PCQ:USD
    Strange but true, finding the correct symbol can be the hardest part. Using the two links to the source web sites in the PDF can help.

    Anyway glade it works for you.

    Thanks for the feedback, appreciated.

    HAVE FUN

  14. 194 Posted by derekkent23 on 03 Jun, 2018 07:50 AM

    derekkent23's Avatar

    UPDATE to V3 of the following PDF

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

    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: Change the process for creating Market Indices along with adding a note related to certain types of reports to ensure market indices values are not included in these reports.

    Hope this helps.

  15. 195 Posted by Neil B on 04 Jun, 2018 10:30 PM

    Neil B's Avatar

    Hi Derek,

    Please let me apologise for the delay in getting back to you. May evaporated due to a combination of holidays, a business trip and family issues. I'm hoping that my problems are now solved, but would like to explain what I think went wrong with almost none of my securities updating, but funds/oeics presenting no problem.
    I updated all the software as you suggested, then downloaded Mike Bray's Security Price Loader as recommended. All the quotes were successfully exported from the HleOfxquotes software as a .csv. However when I tried to import them into MD, the problem became apparent. The ".L" had been lost from the tickers in MD! Since the funds do not have this suffix, they presented no problem. Once I had edited all the tickers back to where they were, import occurred perfectly. I cannot think why this should have happened, but I suppose the reasons are totally academic now. The important thing is that I am now using the recommended extension and not the QIF method, and have carried out 5 updates on separate days after the markets have closed - no problems whatsoever.
    Just one thought, and I'm not certain if this is the correct thread or not. Going back to the days late last year/early this year I had used Alphavantage. That made a real mess of some of my share price histories, with all sorts of odd data being inserted. Do you know the best place to get historical price data? I have used Yahoo, but often the data is incomplete or even inaccurate. Any thoughts would be most welcome!
    Thanks again for all your help - greatly appreciated.
    Best regards
    Neil

  16. 196 Posted by sprimost on 04 Jun, 2018 11:01 PM

    sprimost's Avatar

    Hi Neil

    There are a number of sites that still provide this information for
    free. Yahoo finance will provide a limited range (3 months is the max,
    if I remember. NASDAQ is always helpful, and of course, lphavantage, (if
    you can read their documentation!).

    The tricky part will be the importing into Moneydance. Each security is
    downloaded as a separate file and each must be imported separately. The
    headers for the csv must be exactly (including case) like it is in the
    documentation or else it will not import.

    You will need to got to each securty, click on Security Details, and
    then History. A button on the right is "import". Select the import from
    file. The screen will also provide the key words used for the headers.
    And when you are ready, select "Import".

    Just a word of caution...while this has never failed me as part of
    process, having to do this multiple times, sometimes gets confusing as
    to which file belongs to which security, so taking consistent set of
    backup is highly recommended!

    Steve (just a user, and not support)

  17. 197 Posted by derekkent23 on 05 Jun, 2018 09:15 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    Hi Neil.

    I was wondering how you were getting on, so thanks for the feedback.

    I have not heard of symbols in Moneydance losing their exchange suffix, in your case “.L”. Very strange. I wonder if using QIF import coursed the change or was just the first effect to be noticed. If the “.L’s” had gone missing before you did a QIF import, as you have found out before, if the symbols do not match the symbols in Moneydance you don’t get a warning, the price simply does not update.

    Anyway, I am glade you were able to troubleshoot the problem and get back to normal.

    As for obtaining historical data it’s not something I have looked at. Sprimost has posted some good pointers. If you can find a source that provides data in a CSV format then if they are one file per security I would be tempted to use a spread sheet to merge them into one CSV file, under one set of headings and then import the whole lot in one go using Mike Brays Security History Loader. Always take a backup first in case something goes wrong.

    Let us know how you get on.

  18. 198 Posted by Mike Bray on 05 Jun, 2018 12:28 PM

    Mike Bray 's Avatar

    Hi Derek, Neil

    My extension will remove the .L if you have 'Remove Exchange' clicked.
    Also if you have added Exchange Multipliers it will see the .L as an
    Exchange and apply the appropriate Multiplier.
    Regards
    Mike

  19. 199 Posted by Neil B on 05 Jun, 2018 10:07 PM

    Neil B's Avatar

    Hi Mike, Derek and Steve,

    Many thanks for your thoughts and suggestions re historic share prices etc. Although academic now, my initial problem occurred when I was using the QIF import method. I knew that updates were not happening, but it was only when I used Mike's importer that I realised the reason why! I'm really pleased with how things are working now.

    Thanks again

    Best regards,

    Neil

  20. 200 Posted by Tony Blunt on 06 Jun, 2018 03:23 PM

    Tony Blunt's Avatar

    Moneydance Mac build 1672
    Security Price loader 2027

    CSV file contains stock prices and currency rates (CAD, GBP, EUR both ways, suffixed with =X)
    Security Price Loader only shows the stock quotes.
    Exchange rates are not updated in Moneydance. (Exchange rates are displayed on Summary Page in Moneydance)
    If the "Process Currencies" box is ticked in Security Price Loader than "Load Data" does nothing, untick the box and the security results are displayed ready to updated into Moneydance..

    Help...

  21. 201 Posted by Mike Bray on 06 Jun, 2018 04:48 PM

    Mike Bray 's Avatar

    Hi Tony please post the errlog.txt file after the load data does nothing.
    Thanks
    Mike

    Sent from my iPad

  22. 202 Posted by Tony Blunt on 06 Jun, 2018 05:03 PM

    Tony Blunt's Avatar

    Moneydance console log (Process Currencies ticked):-

    in syncer loop
    Found 2313 files in folder: /.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08/v3
    in pushOutgoingTxns()
    Exception in thread "AWT-EventQueue-0" java.lang.StringIndexOutOfBoundsException: String index out of range: -1
    at java.lang.String.substring(String.java:1927) at com.moneydance.modules.features.securitypriceload.loadPricesWindow.loadFile(loadPricesWindow.java:382) at com.moneydance.modules.features.securitypriceload.loadPricesWindow.(loadPricesWindow.java:124) at com.moneydance.modules.features.securitypriceload.FileSelectWindow.loadData(FileSelectWindow.java:686) at com.moneydance.modules.features.securitypriceload.FileSelectWindow.access$300(FileSelectWindow.java:40) at com.moneydance.modules.features.securitypriceload.FileSelectWindow$16.actionPerformed(FileSelectWindow.java:447) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252) at java.awt.Component.processMouseEvent(Component.java:6533) at javax.swing.JComponent.processMouseEvent(JComponent.java:3324) at java.awt.Component.processEvent(Component.java:6298) at java.awt.Container.processEvent(Container.java:2237) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2295) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4889) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4526) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4467) at java.awt.Container.dispatchEventImpl(Container.java:2281) at java.awt.Window.dispatchEventImpl(Window.java:2746) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90) at java.awt.EventQueue$4.run(EventQueue.java:733) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) at java.awt.EventQueue.dispatchEvent(EventQueue.java:730) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) Found 2313 files in folder: /.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08/v3
    SYNC: applied 2313 txn files in 0 ms
    MDSYNC syncing to encryptedFS(DropboxAPI:/.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08); local-changes=false
    checking for txn logs... Found 0 txn files in folder: /.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08
    MDSYNC retrieved and applied 0 updates from mobile sync
    syncing finished
    MDSYNC syncing to encryptedFS(DropboxAPI:/.moneydancesync/eb4a5a0c-6b2a-4a1c-b422-3c5c7004ac57); local-changes=false
    checking for txn logs... Found 0 txn files in folder: /.moneydancesync/eb4a5a0c-6b2a-4a1c-b422-3c5c7004ac57
    MDSYNC retrieved and applied 0 updates from mobile sync
    syncing finished
    in syncer loop

  23. 203 Posted by Mike Bray on 06 Jun, 2018 05:34 PM

    Mike Bray 's Avatar

    Thanks Tony, was this after you had clicked Load Data? It is not showing any errors.

    If you could do the following:

    1. Start MD
    2. Select the Security Price Loader
    3. Either load file or choose a file to select your file
    4. Select the fields where your data is
    5. Select Process Currencies
    6. Click on Load Data

    If nothing happens then there us normally a Java exception which is shown in the Console log.

    Thanks
    Mike

    Sent from my iPad

  24. 204 Posted by Tony Blunt on 06 Jun, 2018 05:42 PM

    Tony Blunt's Avatar

    After clicking on "Load Data' nothing happens. If I uncheck "Process Currencies" it works as normal with just the stocks.

    Starting Moneydance 2017.7.2 (1672) at Wed Jun 06 10:35:39 MST 2018
    Settings Folder: /Users/tonyblunt/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Library/Application Support/Moneydance
    OS: Mac OS X 10.13.5 x86_64
    Java: 1.8.0_162 (Oracle Corporation)
    Is in sandbox: true; restricted file access: false
    Initializing Moneydance SSL
    Created new custom trust manager
    INITPRINT: spawning background printer scanner thread...
    INITPRINT: async lookup of default print service
    MDPRINTER2: looking up print service...
    MDPRINTER2: no default print service found. Creating a PrinterJob to get one from there. 0.0 seconds
    printer job class property: sun.lwawt.macosx.CPrinterJob
    outdated extension: detailedBudget MDPRINTER2: PrinterJob: sun.lwawt.macosx.CPrinterJob@330cf9f5 0.011 seconds
    outdated extension: myposition initialized extension priceui in 0.009 seconds
    initialized extension securitypriceload in 0.0 seconds
    MDPRINTER2: PrintService from PrinterJob: Unix Printer : Brother_MFC_7360N_Shirleyb_9s_iMac 0.478 seconds
    MDPRINTER2: default print service: 'Unix Printer : Brother_MFC_7360N
    _Shirleyb_9s_iMac' found after 0.478 seconds
    multires images available: true
    Cannot load field 'TRANSPARENT' for theme. Reason: TRANSPARENT
    initialized extension yahooqt in 2.147 seconds
    opening last file: Moneydance data
    loading dataset: /Users/tonyblunt/Library/Containers/com.infinitekind.MoneydanceOSX/Data/Documents/Moneydance data.moneydance
    loading with 128 bit encryption key
    reading trunk data tiksync/trunk
    trunk data loaded (1.622 seconds), checking for incremental updates
    loading un-synced txn files...
    loading synced txn files...
    reading txn file 69f744ac-7984-447d-a12e-27af6a6543fc.mdtxn replacing root: null () with new root: Account (992ccffd-9048-4875-b6f6-aa173c37a015
    dropbox folder should be at /Users/tonyblunt/Dropbox and exists=false
    MDSYNC syncing to encryptedFS(DropboxAPI:/.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08); local-changes=true
    Saving state file to syncFolder
    Writing file to dropbox API with debug mode=false
    Writing file to dropbox API with debug mode=false
    MDSYNC syncing to encryptedFS(DropboxAPI:/.moneydancesync/eb4a5a0c-6b2a-4a1c-b422-3c5c7004ac57); local-changes=false
    Exception in thread "AWT-EventQueue-0" java.lang.StringIndexOutOfBoundsException: String index out of range: -1
    at java.lang.String.substring(String.java:1927) at com.moneydance.modules.features.securitypriceload.loadPricesWindow.loadFile(loadPricesWindow.java:382) at com.moneydance.modules.features.securitypriceload.loadPricesWindow.(loadPricesWindow.java:124) at com.moneydance.modules.features.securitypriceload.FileSelectWindow.loadData(FileSelectWindow.java:686) at com.moneydance.modules.features.securitypriceload.FileSelectWindow.access$300(FileSelectWindow.java:40) at com.moneydance.modules.features.securitypriceload.FileSelectWindow$16.actionPerformed(FileSelectWindow.java:447) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252) at java.awt.Component.processMouseEvent(Component.java:6533) at javax.swing.JComponent.processMouseEvent(JComponent.java:3324) at java.awt.Component.processEvent(Component.java:6298) at java.awt.Container.processEvent(Container.java:2237) at java.awt.Component.dispatchEventImpl(Component.java:4889) at java.awt.Container.dispatchEventImpl(Container.java:2295) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4889) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4526) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4467) at java.awt.Container.dispatchEventImpl(Container.java:2281) at java.awt.Window.dispatchEventImpl(Window.java:2746) at java.awt.Component.dispatchEvent(Component.java:4711) at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760) at java.awt.EventQueue.access$500(EventQueue.java:97) at java.awt.EventQueue$3.run(EventQueue.java:709) at java.awt.EventQueue$3.run(EventQueue.java:703) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90) at java.awt.EventQueue$4.run(EventQueue.java:733) at java.awt.EventQueue$4.run(EventQueue.java:731) at java.security.AccessController.doPrivileged(Native Method) at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80) at java.awt.EventQueue.dispatchEvent(EventQueue.java:730) at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:205) at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93) at java.awt.EventDispatchThread.run(EventDispatchThread.java:82) MDSYNC syncing to encryptedFS(DropboxAPI:/.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08); local-changes=false
    checking for txn logs... Found 0 txn files in folder: /.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08
    MDSYNC retrieved and applied 0 updates from mobile sync
    syncing finished
    MDSYNC syncing to encryptedFS(DropboxAPI:/.moneydancesync/eb4a5a0c-6b2a-4a1c-b422-3c5c7004ac57); local-changes=false
    checking for txn logs... Found 0 txn files in folder: /.moneydancesync/eb4a5a0c-6b2a-4a1c-b422-3c5c7004ac57
    MDSYNC retrieved and applied 0 updates from mobile sync
    syncing finished
    in syncer loop
    Found 2314 files in folder: /.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08/v3
    in pushOutgoingTxns()
    Found 2314 files in folder: /.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08/v3
    SYNC: applied 2314 txn files in 0 ms
    MDSYNC syncing to encryptedFS(DropboxAPI:/.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08); local-changes=false
    checking for txn logs... Found 0 txn files in folder: /.moneydancesync/d63766b9-ff24-41c8-b7dd-7427efaf7e08
    MDSYNC retrieved and applied 0 updates from mobile sync
    syncing finished
    MDSYNC syncing to encryptedFS(DropboxAPI:/.moneydancesync/eb4a5a0c-6b2a-4a1c-b422-3c5c7004ac57); local-changes=false
    checking for txn logs... Found 0 txn files in folder: /.moneydancesync/eb4a5a0c-6b2a-4a1c-b422-3c5c7004ac57
    MDSYNC retrieved and applied 0 updates from mobile sync
    syncing finished

  25. 205 Posted by Tony Blunt on 06 Jun, 2018 06:08 PM

    Tony Blunt's Avatar

    I have a screen recording of what happens, if I can upload it...

  26. 206 Posted by Mike Bray on 06 Jun, 2018 06:51 PM

    Mike Bray 's Avatar

    Very useful, please can you post the .csv file and I will run it against my system.
    Thanks
    Mike

    Sent from my iPad

  27. 207 Posted by Tony Blunt on 06 Jun, 2018 06:58 PM

    Tony Blunt's Avatar

    I cut out most of the stock quotes - same result

  28. 208 Posted by Mike Bray on 06 Jun, 2018 07:01 PM

    Mike Bray 's Avatar

    One last question, what is your base currency?

    I will look at this tomorrow (GMT).
    Mike

    Sent from my iPad

  29. 209 Posted by Tony Blunt on 06 Jun, 2018 07:05 PM

    Tony Blunt's Avatar

    Base currency is US$

    Many thanks for your help. My first impression is that this process will be more dependable than the Q&E extension using Alphavantage.

  30. 210 Posted by derekkent23 on 06 Jun, 2018 07:10 PM

    derekkent23's Avatar

    I am not support staff just a user.

    Hi Tony.

    Mike as the developer of the Security Price Loader Extension is the expert on this one, but I would be interesting to know if you get the same problem with Mikes Security History Loader. As always do a FILE – EXPORT BACKUP first.

    In your MOV post, with process currency box unticked, the second window opens but the area which should show the imported data is just a blank white screen or it is when I play it back. What do you actually see and can you confirm you can import the data.

    Thanks

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