Getting Security Prices

Mike Bray (Quote Loader Author)'s Avatar

Mike Bray (Quote Loader Author)

16 Apr, 2024 07:17 AM

As you may know the format of Yahoo web pages has changed. This has broken Quote Loader and Quote and Exchange Rates Updater for the Yahoo source. This is not a simple fix.

Quote Loader has been recommended as an alternative using the FT source. Often the ticker used on FT is different than that used on Yahoo so just changing the source may not work. To help you overcome this these steps might help.

  1. Set up Quote Loader with a source of FT against each security
  2. Click on Save Changes
  3. Click on Get Prices
  4. Once all prices have been returned (green) or shown in error (red). Check the successful prices to see if the new price makes sense. What can happen is that the ticker used on Yahoo could be used for a different security on FT, thus the price will be quite a bit different. Identify those securities which are wrong and add them to the list of failed securities.
  5. Use your browser to got to ft.com (https://markets.ft.com/data)
  6. For each security use the Search securities box (top right) to find the page for your security (eq. Apple Inc). Once you have found it ft.com will display the name of your security with the ticker used by ft.com (eg. aapl:nsq).
  7. Copy this ticker and paste it into Alt Ticker box against your security, make sure the Exch Mod box is empty by double clicking on the box and choosing the first entry 'Do not use an exchange'
  8. Once you have updated all failing securities click on Save Changes
  9. Click on Get Prices

That should solve your issues, if you still have issues make sure there are not any spaces or wrong characters in the Alt Ticker box.

  1. 1 Posted by aforkosh on 16 Apr, 2024 09:15 AM

    aforkosh's Avatar

    Regarding step 4: I load about 300 securities denominated in US Dollars. All my errors were from securities denominated in other currencies. I found the efficient method for finding them was to sort the Quote Loader table using the Trade Currency column and do the lookups for the Alt Ticker for those securities not using US Dollars. Once I made those modifications, the run proceeded cleanly.

  2. 2 Posted by derekkent23 on 16 Apr, 2024 11:59 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi aforkosh

    Well done for working it out.

    Have Fun, Stay safe.

  3. 3 Posted by Puche on 17 Apr, 2024 12:40 AM

    Puche's Avatar

    This worked very well. Only symbol I couldn't pick up was ethereum crypto. Thanks so much for the valuable information.

  4. 4 Posted by tlist809 on 17 Apr, 2024 01:41 AM

    tlist809's Avatar

    could not find fdknx Franklin Dynatech Class A

  5. 5 Posted by roy on 17 Apr, 2024 02:35 AM

    roy's Avatar

    Thank you for the great instructions, got things working again!

  6. 6 Posted by derekkent23 on 17 Apr, 2024 07:30 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi Puche

    Sorry, FT does not support cryptocurrency exchange rates.

    Have fun, Stay Safe.

  7. 7 Posted by derekkent23 on 17 Apr, 2024 07:34 AM

    derekkent23's Avatar

    I am not support staff, just a user.
    Hi tlist809

    Sorry, FT does not seem to support Franklin Dynatech Class A
    But I think there is a type error in the Ticker. Should it be FKDNX not FDKNX

    Have fun, Stay Safe.

Reply to this discussion

Internal reply

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

Attaching KB article:

»

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