Yahoo finance new format is useless.

S

Sandy & Shirley

Recycles dryer sheets
Joined
Jul 9, 2016
Messages
238
Location
North East
In the past I was able to use a link like:
https://finance.yahoo.com/quotes/IJH,IJT,PYVLX,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?
 
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.
 
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
 
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/quotes.csv?s=aapl+vfsux+vtsax+vwilx+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.
 
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...-applications-function-yahoo-finance-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.
 
Last edited:
ownyourfuture said:
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.
Click to expand...

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.
 
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.
 
Try something like for each stock ticker you want to track:

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

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

:facepalm: Learn something new every day. Thank you!
 
notice the adjusted closing price?

Sandy & Shirley said:
In the past I was able to use a link like:
https://finance.yahoo.com/quotes/IJH,IJT,PYVLX,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?
Click to expand...
They ruined the entire site. The adjusted closing price no longer reflects dividends and splits.:mad:
 
brewer12345 said:
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.
Click to expand...
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.
 
Last edited:
brewer12345 said:
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.
Click to expand...

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?
 
braumeister said:
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.
Click to expand...

I'll be pursuing this when Quicken stops working for me.
 
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.
 
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.
 
mpeirce said:
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/quotes.csv?s=aapl+vfsux+vtsax+vwilx+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.
Click to expand...

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.
 
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.
 
Mo Money said:
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.
Click to expand...

Flickr OMG, what I nightmare!
I moved to a premium account @ PhotoBucket after that & it was almost as bad. I'm not trying to dissuade you from going with Google, but I found a site called SmugMug about 2.5 years ago & it's everything I've ever hoped for in a photo hosting site & more.

https://www.smugmug.com

It's not cheap, about $60.00 per year, but worth every single penny.
*They don't allow nude pictures*
 
And to add to this discussion... it was recently changed to this...

I hate the change where I used to be able to say which view was my main view... which I created for what I want to see... now, when you click on it the default is 'summary'... OK, so I click on performance and see what I want.... but when I look at the next portfolio, back to 'summary'!!!


BUT.... the view I see on my tablet is still the old one... so it has not be 'improved' yet....


As an FYI, they screwed up the fantasy sports a while back but enough peopled complained so they brought back the old view... still, they were able to screw other things up.... I just live with it hoping it gets better when Meyers is gone... I do not think she will win the worst CEO award, but I would bet she would be nominated...
 
brewer12345 said:
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.
Click to expand...

Agreed. No wonder the CEO is only getting a measly 23 million dollars severance after the sale to Verizon is over. :rolleyes:
 
Seems like I've used Yahoo finance for 15 years or more. Hate it now!
Maybe I'll just pay Morningstar 😳
 
You must log in or register to reply here.

Similar threads

M
New Car Dealer REQUIRES Financing
2 3
Replies
62
Views
4K
Aramis
Aramis
Tranquility Base
Borrowing Against Investment Portfolio For Home Purchase
Replies
16
Views
593
jazz4cash
J
Janet H
Forum Downtime - software update scheduled April 23/24
2
Replies
36
Views
1K
Out of Steam
Out of Steam
M
Well Pump Replacement
2
Replies
38
Views
1K
Northforker
N
MichaelB
HVAC replacement advice
2
Replies
31
Views
2K
braumeister
braumeister

Latest posts

Back
Top Bottom