Windows 10: EXCEL automate download stock prices at end of day

Hi folks.

anybody got suggestions on how to download end of day data for around 30 - 40 stocks (or more) using EXCEL and its Internet services.

Basic data is OPEN/CLOSE/HIGH/LOW/VOLUME

This can be downloaded from GOOGLE or YAHOO finance but it's a bit of a manual process and has to be done individually for each share / stock.

There used to be an API from YAHOO which one could use to automate this process -- I don't think that works any more or is so changed that any old app would need a total re-write.

Anybody got an easy system to do this -- I've no problem say in loading up an input file which contains the list of stocks for which I want to get the data.

There are stock data services around but usually they require payments and registration which exposes you to a never ending stream of "Get Rich Quick" and "Try these trading schemes" type of spam and other junk email.

Cheers
jimbo

:)

 

EXCEL 2019 Stock and Geograpghy Data types missing

Hi there
@ignatzatsonic

Basically just the basics for EOD (End of Day) Historical data prices -- OPEN, CLOSE, HIGH, LOW, VOLUME

Indices -- E.G FTSE 100 (London), US NASDAQ, S&P 500, S&P30, Sectors e,g Gas/Oil. utilities etc etc.

The Stock Connector addin is still available but I remember the stock and geographic data types from EXCEL 2016 -- maybe that was only a trial --I think now it's only available in Office/365 now.

Fortunately get data from web still works but the old nice api's that Yahoo used to have are finished and I'm not signing up to anything "Googley" to use the api in Google docs !!!!

For Day trading I already use a "Level 1" real time service -- the excel stuff is really for "Homework" / later analysis e.g "Technical Analysis" in "Trader speak".

Cheers
jimbo

 

Nokia 5800, Stock Prices

Hello,



Do you know any software to get stock prices on Nokia 5800?



Thank you!

 

EXCEL 2019 Stock and Geograpghy Data types missing

I don't day trade, but I need closing prices for several dozen items every day and have for decades.

I've always tried to track and record this stuff through Excel--dating back at least as far as Excel 2007.

My experience has been that none of the so-called sources work more than a year or two. Then something will go haywire---a change in Excel, a change in behind-the-scenes coding at a website, an unexplained failure of a previously good ticker symbol, etc, etc.

Maybe 3 years ago, I just quit fighting trying to get this done in any semi-automated way......out of frustration.

Here's what I do instead:

I set up a portfolio of my 30 or 40 desired tickers at bigcharts.marketwatch.com. The default columns are for last, change, percentage change, high, low, volume, and time. All I really care about is the closing price, but I look at it during market hours off and on.

It takes about 2 hours after the close for the prices of mutual funds to arrive. Stocks and indexes are at most 15 minutes delayed.

Two hours or so after the close, I use my mouse to swipe over all the tickers and columns and do a copy/paste into cell A1 of the "Pricing" tab in my Portfolio Tracking Excel file. Tuesday's copy/paste will overwrite Monday prices, etc.

The other tabs in my Excel file contain formulas that correspond to certain cells in this Pricing tab. For instance, cell B3 of the Pricing tab is ALWAYS the SP 500 close.........so I have a formula "=prices!b3" for anywhere else in the other tabs that needs the closing value for that day's SP 500.

If I want to track some new ticker, I add it to my portfolio at Bigcharts and make the appropriate change in my formulas.

The only drawback is that it takes 30 seconds a day.

On the plus side, it has been foolproof---Bigcharts is consistent, reliable, always up, and the tickers don't fail.

I'd be interested in anything you know of that's better for my purposes. I've been down a lot of rabbit holes----but they've all eventually failed. Thus I'm willing to spend the 30 seconds.