Need to autoupdate securities prices

Help
1

I have two kinds of securities

  1. Mutual Funds
    I am able to visit finance yahoo and query based on ISIN.

  2. Equities
    I am able to visit finance.yahoo.com and query based on ticker.

My setup for online quotes for Yahoo is as:

URL: https://query1.finance.yahoo.com/v6/finance/quote?fields=regularMarketPrice&symbols=%1
CSV URL: Blank
Identifier: %1
Identify by: Indentification Number
Price: “regularMarketPrice”:((\d+|\d{1,3}(?:[,]\d{3})).\d+)
Date: “regularMarketTime”:([\d]+)
Date Format: Blank
Skip HTML stripping: Checked

Help is greatly appreciated.

2

Similarly all the mutual funds prices are available in URL https://www.amfiindia.com/spages/NAVAll.txt

Please share steps to configure to extract prices for mutual funds based on ISIN

3

Yahoo changed their API a while ago. So v6 does not work anymore. See this post how data can be retrieved currently. No guarantee on how long this will work. You may have to use their website to see which identification they use for the data you are looking for (might not be ISIN).

4

What works for my quotes on yahoo is the same as yours except:
Identify by: Symbol
URL: https://query1.finance.yahoo.com/v8/finance/chart/%1
Don’t hesitate to write back if you have questions. Happy Mardi Gras! A

5

Security price is updating fantastically, you can have either as Identifier, Symbol or Name as a match critieria.

Thank you for your help.

1 Like
6

Security price is updating fantastically, you can have either as Identifier, Symbol or Name as a match critieria.

Thank you for your help.

1 Like