Yahoo finance new format is useless.

[Sandy & Shirley]

In the past I was able to use a link like:
https://finance.yahoo.com/quotes/IJH...YVLX,DNP,HSFNX
to get a list of the closing prices of the symbols I was following. I could copy and paste the web page to an excel spreadsheet and extract the data. All I had to do is to make sure that all of the closing prices had been updated for today.

With their new format this is no longer possible. Their market time is now only the time and does not include the date. If you look at the list at 6:12 PM EDT and see a closing time of 6:10, was that the close for today, or was that the time it closed yesterday?

Also, the new format has check boxes next to the symbol and the actual symbol is no longer available with a copy and paste.

Since yahoo finance is now useless, can I ask the group where they go to look at closing prices for the day?

[ownyourfuture]

I can't recommend a new site for you, only agree that over the years yahoo has totally destroyed the finance section & the stock message boards.

[googily]

If you want to sell your soul to Google and the cloud, you can use a Google spreadsheet and its built-in Google Finance formulas that update all manner of stock information:

GOOGLEFINANCE(ticker, [attribute], [start_date], [num_days|end_date], [interval])

https://support.google.com/docs/answer/3093281?hl=en

[mpeirce]

You can still fetch a comma separated list of prices (.csv) from Yahoo using a URL of the form:

http://download.finance.yahoo.com/d/...wilx+amzn&f=l1

This opens into any spreadsheet app for easy access.

Until recently, I would fetch prices after dinner and open the resulting .csv file into Numbers. Then cut and paste them into my master spreadsheet. It also had the previous day's price (or the last price from when I last fetched prices). Took just a sec and it was easy to see if one of the funds maybe hadn't been updated yet since the price wouldn't have changed.

Last week I switched to using Numbers' new STOCK() function. Now I have all this automated and it's even faster ;-)

FWIW, the STOCK() function in Numbers uses Yahoo Finance stock price info.

[Tadpole]

Export button on that page works fine for me. It opens a csv file and I just copy the price data. But I started using a function called StockQuote (described here:
https://www.mrexcel.com/forum/excel-...nance-udf.html
)

I copy pasted the function and recently had to change the yahoo.com url from http to https. If you copy the function into a module, make the https change and call it with the current date it returns the quote. I just use the today function in cell next to it to get today's date and a third cell has the =StockQuote(ticker, date) in it. It becomes automatic for the current date.

[brewer12345]

Quote:

Originally Posted by ownyourfuture I can't recommend a new site for you, only agree that over the years yahoo has totally destroyed the finance section & the stock message boards.

Yahoo has systematically destroyed its entire product, including the finance section. They could not have done a more thorough job even if they had set out to do exactly that. Amazing, really.

[cathy63]

In addition to the solutions already given, you could create an Excel sheet that uses the Yahoo webservice directly and avoid the entire copy/paste or save/open process. Instructions are here: https://www.thespreadsheetguru.com/b...el-spreadsheet

[braumeister]

In the Apple world, I have a Numbers spreadsheet (Excel equivalent) that updates my stock prices on practically a real time basis. Once I tell it which symbols I'm interested in, no further action required on my part.

This is a fairly recent new feature in Numbers, and works great.

[joeea]

Try something like for each stock ticker you want to track:

=NUMBERVALUE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s=IJH&f=l1" ))

[Hexanova]

Quote:

Originally Posted by joeea Try something like for each stock ticker you want to track: =NUMBERVALUE(WEBSERVICE("http://finance.yahoo.com/d/quotes.csv?s=IJH&f=l1" ))

Learn something new every day. Thank you!

[Blue Collar Guy]

Quote:

Originally Posted by Sandy & Shirley In the past I was able to use a link like: https://finance.yahoo.com/quotes/IJH...YVLX,DNP,HSFNX to get a list of the closing prices of the symbols I was following. I could copy and paste the web page to an excel spreadsheet and extract the data. All I had to do is to make sure that all of the closing prices had been updated for today. With their new format this is no longer possible. Their market time is now only the time and does not include the date. If you look at the list at 6:12 PM EDT and see a closing time of 6:10, was that the close for today, or was that the time it closed yesterday? Also, the new format has check boxes next to the symbol and the actual symbol is no longer available with a copy and paste. Since yahoo finance is now useless, can I ask the group where they go to look at closing prices for the day?

They ruined the entire site. The adjusted closing price no longer reflects dividends and splits.

[samclem]

Quote:

Originally Posted by brewer12345 Yahoo has systematically destroyed its entire product, including the finance section. They could not have done a more thorough job even if they had set out to do exactly that. Amazing, really.

Exactly. They had a thriving set of specialized online discussion groups, too. They refused to make common sense upgrades (it's far less functional than this site--no good way to include attachments, the threads are virtually impossible to follow), and then they "improved" them to bring in more ad revenue and they got worse still. Dial-up CompuServe in 1995 was better. I can't imagine how a company could be so screwed up.

I do not understand why Verizon thought spending money for Yahoo was a good idea.

[audreyh1]

Quote:

Originally Posted by brewer12345 Yahoo has systematically destroyed its entire product, including the finance section. They could not have done a more thorough job even if they had set out to do exactly that. Amazing, really.

Yep - I had three views I used all the time. The market overview was nice, but that went to heck about a year ago. Now my stock list summary view and the economic calendar have been clobbered! Aargh!

Is it because someone bought them they decided to destroy it?

[joeea]

Quote:

Originally Posted by Hexanova Learn something new every day. Thank you!

My pleasure.

I use it on the Stocks tab of my Net Worth spreadsheet to track the few individual stocks I own.

[audreyh1]

Quote:

Originally Posted by braumeister In the Apple world, I have a Numbers spreadsheet (Excel equivalent) that updates my stock prices on practically a real time basis. Once I tell it which symbols I'm interested in, no further action required on my part. This is a fairly recent new feature in Numbers, and works great.

I'll be pursuing this when Quicken stops working for me.

[Animorph]

I put up with the lack of a date from Yahoo, but then it wouldn't load into my Excel spreadsheet.

I ended up using this Fidelity link:

Fidelity

You can get basic info on as many symbols as you can fit within 100 characters. The symbols are all in the URL, so you can use it as a direct link any time. It is on Fidelity's public pages, so no login required. And the result is simple text that can be loaded into Excel.

[Mo Money]

Not to drift, but if you think Yahoo Finance has gone to pot, you ought to subscribe to Flickr, Yahoo's formerly fantastic photo-storage site. They told me to change my password because of the (SECOND!) major hack. When I did so, Flickr locked me out. I sought out its customer service, which is strictly email, not phone or even chat. They contacted me only after a couple of days and wanted me to remember the exact names of five file folders in my Flicker account, as well as the payment info for my last subscription. I gave them the payment info right down to the 20-digit paypal transaction number. But I could only remember file names generally like "Pug Pictures." That was not satisfactory; I was close, but the titles were not EXACT. I was locked out for weeks until a password-reset link mysteriously appeared in an email from customer service that actually finally worked. Yahoo is going south. Fast. Moving my photos to Google.

[Sandy & Shirley]

Thanks for all of the feedback, just looks like Yahoo is dead. RIP

[audreyh1]

Quote:

Originally Posted by mpeirce You can still fetch a comma separated list of prices (.csv) from Yahoo using a URL of the form: http://download.finance.yahoo.com/d/...wilx+amzn&f=l1 This opens into any spreadsheet app for easy access. Until recently, I would fetch prices after dinner and open the resulting .csv file into Numbers. Then cut and paste them into my master spreadsheet. It also had the previous day's price (or the last price from when I last fetched prices). Took just a sec and it was easy to see if one of the funds maybe hadn't been updated yet since the price wouldn't have changed. Last week I switched to using Numbers' new STOCK() function. Now I have all this automated and it's even faster ;-) FWIW, the STOCK() function in Numbers uses Yahoo Finance stock price info.

Yay for this stock function! I might be able to automatically update my spreadsheets. Right now I cut and paste a column of numbers from Quicken. Easy enough to modify the code to directly pull the numbers.

[UnrealizedPotential]

I gave up on Yahoo finance a long time ago. Nowadays I use market watch. It seems to be pretty close to real time quotes. YMMV.