Getting Security Prices
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.
- Set up Quote Loader with a source of FT against each security
- Click on Save Changes
- Click on Get Prices
- 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.
- Use your browser to got to ft.com (https://markets.ft.com/data)
- 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).
- 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'
- Once you have updated all failing securities click on Save Changes
- 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.
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
1 Posted by aforkosh on 16 Apr, 2024 09:15 AM
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 Posted by derekkent23 on 16 Apr, 2024 11:59 AM
I am not support staff, just a user.
Hi aforkosh
Well done for working it out.
Have Fun, Stay safe.
3 Posted by Puche on 17 Apr, 2024 12:40 AM
This worked very well. Only symbol I couldn't pick up was ethereum crypto. Thanks so much for the valuable information.
4 Posted by tlist809 on 17 Apr, 2024 01:41 AM
could not find fdknx Franklin Dynatech Class A
5 Posted by roy on 17 Apr, 2024 02:35 AM
Thank you for the great instructions, got things working again!
6 Posted by derekkent23 on 17 Apr, 2024 07:30 AM
I am not support staff, just a user.
Hi Puche
Sorry, FT does not support cryptocurrency exchange rates.
Have fun, Stay Safe.
7 Posted by derekkent23 on 17 Apr, 2024 07:34 AM
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.
System closed this discussion on 17 Jul, 2024 07:40 AM.