Updating Market Prices

rennis13's Avatar

rennis13

02 Dec, 2017 07:13 PM

I am having problems with updating my portfolio, keep getting the 403 error message. Does anyone else have this problem?
Date: 2 Dec 2017

  1. 1 Posted by Randy Mackie on 02 Dec, 2017 11:19 PM

    Randy Mackie's Avatar

    Suggest you search the forums with search term 403....there are many many posts/threads on this topic since November. Yahoo shut down their service and IK has been working on a replacement. You can update prices with a csv file downloaded from, for example, finance.yahoo.com, or try the beta software mentioned in many of the other threads.

  2. 2 Posted by derekkent23 on 03 Dec, 2017 11:51 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    There is a beta version of the Q & ER extension out from Sean the lead software developer which uses Alpha Vantage instead of Yahoo. See https://infinitekind.com/tmp/yahooqt.mxt Remove the old extension and install the new one. Make sure it ends in “.mxt” not “.zip after you download it. Edit zip if required. You must also be running the latest preview build of 2017 downloaded from https://infinitekind.com/preview
    You will be asked to get and enter an Alpha Vantage Key when you first open the extension.

    Hope this helps

  3. 3 Posted by Tom Freeman on 04 Dec, 2017 12:37 AM

    Tom Freeman's Avatar

    Unfortunately Yahoo has turned off their price/rate downloading to third party apps. Our lead developer is working on a solution now and we hope to have an update available for the extension very soon. Sorry for the inconvenience this has caused. I have flagged this discussion so we can notify you as soon as this has been resolved and the update is available.

    As Derek states there is a beta version of the extension with a new quote provider. If you are uncomfortable using the beta, we are hoping to go live with a stable version soon.

    Tom Freeman
    Infinite Kind Support

  4. 4 Posted by Noname on 04 Dec, 2017 12:47 AM

    Noname's Avatar

    Tom, will the new extension work with MD 2014?

  5. 5 Posted by Tom Freeman on 04 Dec, 2017 12:53 AM

    Tom Freeman's Avatar

    I believe the intention is to have it work on older versions. It shouldn't be much work to update the extension for older versions. The developers are just trying to get all the bugs resolved with the current extension version.

    Tom Freeman
    Infinite Kind Support

  6. 6 Posted by Noname on 04 Dec, 2017 12:57 AM

    Noname's Avatar

    That's great news. And thanks for the quick reply.

  7. 7 Posted by rennis13 on 04 Dec, 2017 02:58 AM

    rennis13's Avatar

    Tom,
    Thank you for your response. I upgraded to a newer version and was not pleased initially. After working with it, I have found it to be a bit of an improvement. All the visuals, bells, and whistles of some well known software only cause more computer work. Moneydance's simplicity was why I purchased it initially. Thanks again,
    Jean

    ----- Original Message -----

  8. 8 Posted by dwg on 04 Dec, 2017 03:27 AM

    dwg's Avatar

    As I see it, while it is probably not too difficult or time consuming to update the older extension once all the kinks are ironed out, if the use of AlphaVantage requires a new certificate to be added to Moneydance itself that could be real problem with older releases as I would suspect TIK would not be too keen on doing that.

    On a related theme I've noticed a couple of python scripts for bringing down and loading prices from AlphaVantage, does using scripting also require the security certificates?

  9. 9 Posted by ed delet on 05 Dec, 2017 11:10 AM

    ed delet's Avatar

    Unfortunately the process indicated:
    1-download: https://infinitekind.com/tmp/yahooqt.mxt
    2-running the latest preview build of 2017 downloaded from https://infinitekind.com/preview
    3 I got an alpha vantage key and

    I have Alpha Vantage in quotes and exchange rates

    but no downloading

    In the console I read: "Import error: skipping invalid line:" Error Message ":" Please make sure your API key is valid. Alternatively, claim your free API key on (https://www.alphavantage.co/support/#api-key). It should take less than 20 seconds, and is free permanently. "And this in several lines

    -How to remove the clae API and give another one?

    On the other hand the quotes are US ? or too all other contry like PARIS

    Thank you

  10. 10 Posted by derekkent23 on 05 Dec, 2017 01:19 PM

    derekkent23's Avatar

    I am not support staff just a user.

    At the moment I don't think there is a way to change a entered key. I think it is stored within your data set. I have posted on Sean's Slack channels suggesting he adds a reset button so a new key can be entered. Until he does, I think you are stuck. Unless you have a backup you can restore, a backup before you added the key.
    If you post the name and symbol and exchange of say three sectaries I can test them for you.

    Hope this helps.

  11. 11 Posted by runewh on 05 Dec, 2017 01:24 PM

    runewh's Avatar

    Thank you Derek. Since I am new to MD, I only had a file with very little
    data entered, soooo I created a new file and was able to enter the key
    correctly. Was surprised to find out that the key was case sensitive.

    Thank you for your help!

  12. 12 Posted by ed delet on 05 Dec, 2017 02:46 PM

    ed delet's Avatar

    Thank you Derek
    If you can test symbol market : EURONEXT-PARIS like RNO, ALO, RMS, LVMH
    And I can not find in: Extensions Management list he name of the extension "STOCK QUOTE SYNCHRONIZER" contained in "yahooqt.mxt" ..
    thank you

  13. 13 Posted by derekkent23 on 05 Dec, 2017 03:22 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Under EXTENSIONS _EXTENSION MANAGER the version of Q & ER should be v007.
    When I run Q & ER I get the following results
    RNO returned €85.31, ALO €34.34, RMS €435.7 however it did not return any data for LVMH all set for Exchange Euronext – Paris.

    There is a third party standalone tool into which you can enter a list of symbols and it returns the current Quote Prices. Once entered they are remembered for the next time. This tool works on UK funds stocks and other European Securities. See screen shot for the results of your securities.
    This is great for me as I hold mainly UK funds that are in the main not supported by Alpha Vantage. This tool is still at the beta stage of development, but works. You can then export as a CSV file containing all the prices. The only thing is you to need to have java loaded on your computer, as it is a java program. But that was not a problem download from java.com Official Site.
    You can then use the Security Price Loader extension from Mike Bray to import the data into Moneydance.

    If you won’t more information on this tool just post.

    Sorry I don’t understand your question “And I can not find in: Extensions Management list he name of the extension "STOCK QUOTE SYNCHRONIZER" contained in "yahooqt.mxt"”?

    Hope this helps

  14. 14 Posted by francis.inman on 05 Dec, 2017 04:40 PM

    francis.inman's Avatar

    Great got mine working now I had input my api code wrong, was able to use a 4 day old backup of my data file, it then asked my to reinput api code. Backup files for moneydance are held in user account, moneydace, backups.

  15. 15 Posted by ed delet on 05 Dec, 2017 05:13 PM

    ed delet's Avatar

    @derek
    you:"Sorry I don’t understand your question “And I can not find in: Extensions Management list he name of the extension "STOCK QUOTE SYNCHRONIZER" contained in "yahooqt.mxt"”?" t
    My ; look derek2.png above:
    ---> the extensions named "STOCK QUOTE SYNCHRONIZER" download in yahooqt.mxt is not
    ---> in list extensions screenshot derek1

    And where find tool you are talking about (make >CSV file)

    Thank you for your help!

  16. 16 Posted by derekkent23 on 05 Dec, 2017 05:59 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    Yes, install the item in your screen shot. It has just been updated to include a way to retrieve an entered Alpha Vantage key. Now v008

    There is a third party standalone tool into which you can enter a list of symbols and it returns the current Quote Prices. Once entered they are remembered for the next time. This tool works on UK funds and two of the three test securities you provided. This is great for me as I hold mainly UK funds that are in the main not supported by Alpha Vantage. This tool is still at the beta stage of development, but works. You can then export as a CSV file containing all the prices. The only thing is you to need to have java loaded on your computer, as it is a java program. But that was not a problem download from java.com Official Site.
    Download the hleofxqoutes program from
    https://github.com/hleofxquotes/hleofxquotes/blob/master/dist/test/...

    Right clicking on the Price window allows you to save a CSV file. You can then use the Security Price Loader extension from Mike Bray to import the data into Moneydance. See https://bitbucket.org/mikerb/moneydance-2015/wiki/Home

    If you won’t more information on how to use this tool just post

    Hope this helps

  17. 17 Posted by ed delet on 05 Dec, 2017 06:55 PM

    ed delet's Avatar

    Thank derek
    but
    the file hleOfxQuotes-gui-Build_20171201_160…
    I don’t save to CSV file only OFX
    / Where is my mistake
    I am grateful for all your help
    ed

  18. 18 Posted by derekkent23 on 05 Dec, 2017 07:05 PM

    derekkent23's Avatar

    I am not support staff, just a user.

    In the price window right click on one of the results to give a menu MD – Save CSV

    Hope this helps

  19. 19 Posted by cwieczorek on 05 Dec, 2017 07:14 PM

    cwieczorek's Avatar

    Thanks for the beta version of the stock quote updater. It looks like it's working fine for me.

    -Chris

  20. 20 Posted by ed delet on 05 Dec, 2017 07:27 PM

    ed delet's Avatar

    @derek
    It works
    good
    thank for your help
    and in download the update Good with set API Key i change my serial and EUREKA
    It download quotes
    Good job for the team

  21. 21 Posted by ed delet on 05 Dec, 2017 07:30 PM

    ed delet's Avatar

    Thanks for the stock quote updater.
    The button SET API KEY was a good thing
    It looks like it's working fine for me
    Well done!
    team of hell

  22. 22 Posted by sprimost on 06 Dec, 2017 12:01 AM

    sprimost's Avatar

    I am not a support staff, just a user.

    The best and tried/true way of doing this is to File-> Export Backup to
    a common directory  on the first computer (one that you can move to the
    new computer or share*). Once you move the file to the new computer,
    important that you rename it to what you want the data to be (and not
    the archive name). Locate the file on the drive that you feel most
    comfortable with.

    Note. It has a habit of building the directory of files for MD as a
    subdirectory. This way you could have multiple versions of your data
    depending on when you did the export/import. Typically, I build my
    directory structure as --
    1st level (off of root (or C: drive) as Finances
    2nd level as Finances+Finance Data (+ indicates the slash is different
    for Linux vs. Windows vs. Mac) for your data
                  Finances+MoneyDance-20xx for all of the software including
    any special extensions
                  Finances+Backup for the back copy of the export. The
    backup copies of the data always goes on a separate drive from C or
    root, like a thumb drive....you never know!
    3rd level as Finances+Finance Data+name and version is the directory
    that will be created when you import the backup.

    On the 2nd computer, do a File->Import from Backup (it might take a
    couple of minutes depending on the amount of data. You will need to
    re-enter your product key. The IK license terms are very friendly, but
    you should read them.

    *If you put it on a share, you should delete it (really erase it) since
    the file is not password protected.

    Hope this helps. (I have been doing this for years across any number of
    computers and OS's)

    Steve Primost

  23. 23 Posted by derekkent23 on 01 Jan, 2018 11:43 AM

    derekkent23's Avatar

    I am not support staff, just a user.

    For anyone who is interested take a look at this thread on a third-party Quote and Exchange Rate Program from hleofxquotes.
    http://help.infinitekind.com/discussions/investments/3036-third-par...

    Hope this helps.

  24. 24 Posted by edeleted on 01 Jan, 2018 11:44 AM

    edeleted's Avatar

    Désolé, Vacances

  25. System closed this discussion on 02 Apr, 2018 11:50 AM.

Comments are currently closed for this discussion. You can start a new one.

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