Stock quote

[Leo57792]

I am new, looking for stock quote download excel formulation, Vb or anything else to replace mine, I used NUMBERVALUe and webquery in the until yahoo finance changed and not supporting my script , please chk thespreadsheetguru.com for that method not working now because changed yahoo finance.
You can also send your suggestion to Leo at hjtezduyar.com directly,

Thank you

Leo

 

[ranman256]

i got the stock quote download from them and it works fine.
(not on this PC tho)

 

[Leo57792]

Great, what PC you are using,
Here is my script, please compare with yours,
=NUMBERVALUE(WEBSERVICE("https://download.finance.yahoo.com/d/quotes.csv?s="&F3&"&f=l1")), and it used to fetch stock that in F3 cell, its symbol for instance msft placed in f3. and l1 is closing price. Please check with your excel statement, are they similar. or same.

If you have other means like vb to do similar in functionality, that will be great.

Leo