or Create a profile

Home → Investments →

Alphavantage Mutual Fund quotes

This discussion is public.

JL's Avatar

JL

07 Dec, 2017 01:35 AM

Is anyone else seeing that when downloading Mutual Fund quotes they are from the previous day?
Seems that in order to get todays quotes you have to wait till tomorrow.

As of 12/6/2017 7:30 PM Central it says prices as of 12/5/2017.

Edit

Well it is now approx 4:25 AM Central time 12/7/2017 and downloaded quotes for yesterday.
There were a few funds that are not updating. They show prices as of 12/5/2017

Not good. Disappointing.

Showing page 2 out of 4. View the first page

  1. 31 nelis_orb's Avatar nelis_orb on 17 Dec, 2017 11:17 PM

    I just updated to the v1012 version. There must still be a bug in parsing the data. The URL it's using works and is spitting back a CSV file but the extension is still reporting no data. Console log from testing 1 stock:

    getting history using url: https://www.alphavantage.co/query?function=TIME_SERIES_DAILY&symbol=TSLA&apikey=<apikey>&datatype=csv
    TRUSTMGR: checking cert chain: CN=www.alphavantage.co
    Saving certificate: 0
        subject: CN=www.alphavantage.co
         issuer: CN=Let's Encrypt Authority X3, O=Let's Encrypt, C=US
      not after: Tue Jan 16 18:12:01 EST 2018
     not before: Wed Oct 18 19:12:01 EDT 2017
       filename: unknown_cert_0.der
    Saving file to C:\Program Files\Moneydance\unknown_cert_0.der
    Saving certificate: 1
        subject: CN=Let's Encrypt Authority X3, O=Let's Encrypt, C=US
         issuer: CN=DST Root CA X3, O=Digital Signature Trust Co.
      not after: Wed Mar 17 12:40:46 EDT 2021
     not before: Thu Mar 17 12:40:46 EDT 2016
       filename: unknown_cert_1.der
    Saving file to C:\Program Files\Moneydance\unknown_cert_1.der
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    !! Warning: encountered untrusted cert (saving) !!
    !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
    No current price found for TESLA INCORPORATED

    The CSV file it downloads has all the prices in it though. from 12/15. Maybe since it's an off day. I'll try again tomorrow (monday) and see what happens.

  2. 32 dwg's Avatar dwg on 17 Dec, 2017 11:22 PM

    What version of Moneydance are you using? You will need to have 2017.6 for AlphaVantage to work

  3. 33 nelis_orb's Avatar nelis_orb on 18 Dec, 2017 03:02 AM

    @dwg ahh that was it. Odd the MD check for updates said there wasn't any updates. Just downloaded and manually upgrade. Thank you sir, quotes seem to be updating now.

  4. 34 ekbrenner82's Avatar ekbrenner82 on 19 Dec, 2017 11:39 AM

    Tom
    Share prices for stock/mutual funds update for that day late in the day, I can live with the late update.  I don't understand why the prices refer to two days prior the next morning.  Example 12/18 prices updated last night (12/18), this morning they reverted to 12/15 (Friday) prices.   I upgraded to the latest version of MD a couple of weeks ago, am I missing an update?
    ThanksEric B

        On ‎Friday‎, ‎December‎ ‎15‎, ‎2017‎ ‎10‎:‎47‎:‎51‎ ‎AM‎ ‎EST, Tom Freeman <[email blocked]> wrote:
     
       
    |

  5. 35 Bill Waldron's Avatar Bill Waldron on 19 Dec, 2017 11:53 AM

    Have to agree. Late updates are OK with me; however, the extension with AlphaVantage is useless -- I also see my mutual fund prices reverting to older ones, and end up having to manually update to fix.

  6. 36 ekbrenner82's Avatar ekbrenner82 on 15 Jan, 2018 01:58 PM

    Good morning Tom
    I had thought the issue with mutual fund/security price updates had been solved, but recently I am experiencing the same problem...the price updates in the evening but immediately reverts to prices two days prior when I open MD the following morning.  Any suggestions?
    Thanks Eric

        On ‎Friday‎, ‎December‎ ‎15‎, ‎2017‎ ‎10‎:‎47‎:‎51‎ ‎AM‎ ‎EST, Tom Freeman <[email blocked]> wrote:
     
       
    |

  7. 37 Bob Englert's Avatar Bob Englert on 17 Jan, 2018 02:11 PM

    I am having the same problem with mutual fund prices being several days old using the new AlphaVantage app. I am using Moneydance (1661) and the updated extension. Individual stock prices seem to be working OK.

  8. 38 Bob Englert's Avatar Bob Englert on 17 Jan, 2018 02:19 PM

    I just updated to build 1663 and now price quotes are not working at all for me on my MacBook. Received response code 503 and message "Service Unavailable..."

  9. 39 Tom Freeman's Avatar Tom Freeman on 19 Jan, 2018 09:59 PM

    When posting it would help if with a screen shot of your extension window or a list of tickers not updating.

    I do notice that some of my ticker symbols, Canadian funds, are not updating and giving me a last update 12/18/17. I will check in with the lead developer if their is anyway to check with alpha vantage about this.

    Tom Freeman
    Infinite Kind Support

  10. 40 Bob Englert's Avatar Bob Englert on 19 Jan, 2018 10:15 PM

    None of my Vanguard funds are updating correctly.

    Bob

  11. 41 Sam Dollenmeier's Avatar Sam Dollenmeier on 20 Jan, 2018 12:37 PM

    I emailed alpha vantage about security prices like Boeing, BBT and other very common stocks not updating. They never even responded :-(

  12. 42 derekkent23's Avatar derekkent23 on 20 Jan, 2018 01:55 PM

    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 using a free stand-alone program that was originally developed to help out users of MS Money when Microsoft stopped supporting that product.

    I find the quotes accurate, up to date and consistent.

    I would be interested to know if the same is true for US and Canadian stocks/Funds.
    Take a look at the thread below and the PDF in post 3 on how to use the program including how to import the data into Moneydance and let me know how well it works for your securities.
    See http://help.infinitekind.com/discussions/investments/3036-third-par...

    Hope this helps

  13. 43 JL's Avatar JL on 20 Jan, 2018 04:49 PM

    I have been using that third party application and it works for me until or if MD ever gets thier quote download problem fixed.

  14. 44 Sam Dollenmeier's Avatar Sam Dollenmeier on 20 Jan, 2018 04:51 PM

    Thanks, Derek. I’ll have to try - does it work if you have same securities in different accounts? It all sounds a bit intimidating - I’m not a techie.

  15. 45 derekkent23's Avatar derekkent23 on 20 Jan, 2018 05:51 PM

    I am not support staff, just a user.

    Hi JL, glad to hear the program works for you. Can you tell us which type of securities you are using the program for and which stock exchange they are traded on? Is the program easy to use and which method are you using to import the data into Moneydance? Can you post your comments in the thread indicated in post 42 so other user can learn from your experience? Thanks

    Hi Sam, the program is really easy to use, try it. There are two methods for importing the data into Moneydance as described in the PDF. Importing a QIF file into any investment account will update all security prices even if a security does not exist in the investment account you import into. The same is true when you use the Security Price Loaded, it connects directly to securities not via an investment account. If you have further question as you try the program just post. Post any symbols with the security name if you can’t get a returned price quote.

  16. 46 JL's Avatar JL on 20 Jan, 2018 07:17 PM

    @ derekkent23

    After I downloaded the program and unzip it.
    I renamed to a shorter name and took the folder and put on my C: drive.
    I then made a shortcut of the .exe and put it on my Desktop for easy access.
    Make you set your currency via Tools.

    My securities are US Mutual Funds.

    All I had to do is make a list of of stock ticker, which was already in a excel and did a batch copy and paste into the blank window of the program.
    After I download the prices, which is either late that night or early the next morning I highlight (ctrl a) and the a right click to Save as a QIF on my Desktop.

    See the instructions after this. It is pretty much straight forward.
     
    From About
    Version: hleOfxQuotes-gui-Build_20180103_172
    Home page: http://code.google.com/p/hle-ofx-quotes/
    Wiki (documentation): http://code.google.com/p/hle-ofx-quotes/wiki

    Directory: C:\MD Quote Java Importer\.
    Currency: USD
    OFX Account Id: 0123456789
    Yahoo server: download.finance.yahoo.com
    Log file: C:\MD Quote Java Importer\hleOfxQuotes-log.txt

    dateOffset=0
    forceGeneratingINVTRANLIST=false
    incrementallyIncreasedShareCount=false
    randomizeShareCount=false
    suspiciousPrice=10000

    I hope this helps.

    Edit:
    Alphavantage never responded to any emails from me.

  17. 47 Sam Dollenmeier's Avatar Sam Dollenmeier on 21 Jan, 2018 02:52 PM

    I’ve gotten so far as to have updated prices on the lower screen. How do I proceed from there? There is ‘Import to MSMoney’ and ‘Save OFX’? And how do I import into MD?

  18. 48 derekkent23's Avatar derekkent23 on 21 Jan, 2018 03:05 PM

    I am not support staff, just a user.

    Hi Sam.

    For a QIF file hover over a quote in the “Quote Source Prices” tab right click and select QIF -Save.
    For a CSV file hover over a quote in the “Quote Source Prices” tab right click and select MD – Save CSV

    If this is ambiguous in the PDF let me know.

    Then follow the PDF instructions to import into Moneydance.

    Hope this helps

  19. 49 Sam Dollenmeier's Avatar Sam Dollenmeier on 21 Jan, 2018 04:03 PM

    After doing the price update and right-clicking on ‘Quote Source Prices’ all I get is ‘import *.csv file’ but no option of exporting as QIF or CSV file. Where am I going wrong?
    Thanks.

  20. 50 derekkent23's Avatar derekkent23 on 21 Jan, 2018 04:16 PM

    I am not support staff, just a user.

    Right click on a quote line itself not on the Quote Source Prices tab heading

    Hope this helps

  21. 51 Sam Dollenmeier's Avatar Sam Dollenmeier on 21 Jan, 2018 04:45 PM

    Thanks again for your patience, Derek. I’ve gotten the security price loader to import my prices. When saving values how do I get the new price to replace the current price in MD?

    Much obliged, thanks.

  22. 52 derekkent23's Avatar derekkent23 on 21 Jan, 2018 05:10 PM

    I am not support staff, just a user.

    For some reason the developer of Moneydance has written the program such that imports will only update a given current price once a day. Even if you just open up the subject price history window to look at it before an import it blocks updates for that security for the rest of the day. Import on the following day without looking at the price history window first and the current price will update. Crazy but there you are. In these cases, you have to update the current price manually.

    Now you have got used to the process how easy is it to use?

    Hope this helps

  23. 53 Sam Dollenmeier's Avatar Sam Dollenmeier on 21 Jan, 2018 05:19 PM

    Thanks, Derek - I’ll try again tomorrow and keep you posted. All but the bond holdings and about half dozen securities seem to get updated. Once installed it looks like easy to handle. So I get to enjoy the NFL semifinals this afternoon with no worries . Greetings and enjoy the rest of Sunday.

    Sam

  24. 54 derekkent23's Avatar derekkent23 on 21 Jan, 2018 05:52 PM

    I am not support staff, just a user.

    Post a list of the symbols and their security names that don't work and I will check.

  25. 55 Sam Dollenmeier's Avatar Sam Dollenmeier on 22 Jan, 2018 11:34 AM

    Hello again, Derek. I did try to do the update this morning - it still did not take it. I’m going to extension, click on security price loader, the open the file MDQuotes, it has the saved parameters for ticker and price, then click on load. I then get all the securities displayed, click on the window at the bottom for all, and then click on update. When I got out, nothing changed, still the old prices. Could it have anything to do with using the file from yesterday? Thanks, Sam

    The securities without prices are FPP

  26. 56 derekkent23's Avatar derekkent23 on 22 Jan, 2018 12:04 PM

    I am not support staff just a user

    Hi Sam
    Can you post a screen shot of the window you get just before you click on “Save Selected Values? Expand all columns so I can read them. Also, the history price window for one of the securities listed.

  27. 57 derekkent23's Avatar derekkent23 on 22 Jan, 2018 12:09 PM

    I am not support staff just a user

    Hi Sam
    When you talk about FPP is it “Fragrant Prosperity Holdings Ltd”
    If so try FPP:LSE
    or is it FieldPoint Petroleum Corporation

    I assume FPP is the symbol what the securities name?

  28. 58 Sam Dollenmeier's Avatar Sam Dollenmeier on 22 Jan, 2018 01:38 PM

    Here they are:

  29. 59 Sam Dollenmeier's Avatar Sam Dollenmeier on 22 Jan, 2018 02:10 PM

    This seems to be another mystery issue. Yesterday, I uploaded pricing four or five times. With the exception of one upload the only symbols not found was RDSA and RDSB (Shell) which Yahoo never found either. On one upload though I had a whole bunch of other securities not found. Today, when I uploaded anew aside from RDSA and RDSB it did not found AEY which it found yesterday (see screen shot).

    On the other hand after having ‘Saved Selected Values’ aside from RDSA and RDSB I had three more securities with no prices with symbols FPP, LUX and VE. Going into the MDQuotes file I noticed that the prices for these stocks were there, listed as FPPP, LUXTY and VEOEY which are the correct symbols. For some reason the Uploader must have changed the symbols.

    Does this all make any sense? BTW FPPP is Field Point Petroleum.

    Thanks, Sam

  30. 60 derekkent23's Avatar derekkent23 on 22 Jan, 2018 03:11 PM

    I am not support staff, just a user.

    Ok Sam
    If all the data is in the Security Price Loader the issue is not in the stand-alone program but most likely in Moneydance, perhaps the Symbols.
    The example security ARENA PHARM.... in your screen shot can you click on EDIT in its history price window. This should display the Edit Security window so we can see the Ticker Symbol. It should be ARNA, no other charters or leading or traying blanks. Can you post a screen shot of this window?

    Whilst you doing that I will think about your next post.

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