Yahoo Finance

asd · June 5th, 2006, 7:06 pm

I created an excel program for reading option quotes from yahoo finance. Unfortunately after running and testing the excel program, the web page is now showing values of "N/A" for all option symbols / all maturities. This happens even when I look at the page using internet explorer on my PC. While on other PCs the option values show fine for the URL.Can someone please suggest tips if this can be fixed?

untwigged · June 6th, 2006, 11:05 am

Hit File->Open in Excel and paste the url in there. Sometimes IE keeps an old excel workbook in the temporary internet files, and serves you that up instead of what's live.

kevien · June 11th, 2006, 1:33 am

Hi, can you explain through an example?untwigged.Many Thanks

asd · June 12th, 2006, 6:08 pm

Untwigged and Kevein, Thanks a lot for your help! I was actually checking the other PC in morning , and had checked my PC in the night. It seems that option quotes in Yahoo Finance become "N/A" entries in the night , and this was causing the problem. It works fine when I run the program during the day.Regards