Stock Market data

@TraderGary particularly - and any others who do stock trading.

With EXCEL and co-pilot there's probably easy ways now of doing decent market data analysis etc. From an Excel spreadsheet / MySQL or MariaDB database it's easy enough to create links to interesting topics such as capitalisation, ex dividend dates, options, and other market data etc - the problem is getting the initial data in the first place !!!!!.

Is there any decent quick way to get at Market close the base EOD (End of day) data - namely all I want is the OPEN,HIGH, LOW, CLOSE and VOLUME of a stock. I don't need option data or level 1 / level 2 real time feeds.

Interested in mainly US Market, London (FTSE 100/250) and Frankfurt (GER).

I've got a list of about 100 stocks in total that I'm watching - if I could get these automated rather than having to download manually a page at a time then that would be great. Free feeds only please. !!! Yahoo used to have all sorts of access to this sort of stuff but that's long gone. !!!

Added -- missed OPEN as well in initial post !!!!-- also important part for EOD data !!!!.

Cheers
jimbo

jimbo45 said:

@TraderGary particularly - and any others who do stock trading.

With EXCEL and co-pilot there's probably easy ways now of doing decent market data analysis etc. From an Excel spreadsheet / MySQL or MariaDB database it's easy enough to create links to interesting topics such as capitalisation, ex dividend dates, options, and other market data etc - the problem is getting the initial data in the first place !!!!!.

Is there any decent quick way to get at Market close the base EOD (End of day) data - namely all I want is the HIGH, LOW, CLOSE and VOLUME of a stock. I don't need option data or level 1 / level 2 real time feeds.

Interested in mainly US Market, London (FTSE 100/250) and Frankfurt (GER).

I've got a list of about 100 stocks in total that I'm watching - if I could get these automated rather than having to download manually a page at a time then that would be great. Free feeds only please. !!! Yahoo used to have all sorts of access to this sort of stuff but that's long gone. !!!

Cheers
jimbo

Click to expand...

I trade with Interactive Brokers using Trader Workstation. IBTWS gives me that and much more.
I also like using an elite subscription to finviz.com.

TraderGary said:

I trade with Interactive Brokers using Trader Workstation. IBTWS gives me that and much more.
I also like using an elite subscription to finviz.com.

Click to expand...

IB look good

Thanks for quick response. BTW I changed initial post as I left out OPEN in the EOD data I wanted !!!! OPEN is of course important !!!!!

Cheers
jimbo

Hi folks
For those still wanting to build up data base of this sort of stuff the "Instant scraper" addition to Firefox works a treat

E.g for FTSE 100




little bit of edit then to clear out extra text so now have EPIC, Text name of company and its base data.

Relatively easy now to get an EXCEL procedure to go down the column - get the stock EOD data for that share and update a MariaDB database I've created.

With decent Internet it doesn't take too long but this is just a 1st pass - It basically works - I don't need any specialized API's etc.

Quite fun doing too -- but takes longer than you think so allow loads of time. Keeps me out of mischief !!!

Cheers
jimbo

You can make a free account at Seeking Alpha, and make a portfolio of the stocks you track. Shortly after markets close (US), you'd have the criteria you choose in summary. There are other tabs for holding and dividends as well


There is a download button upper right in each portfolio that will download an .xlsx file

A Guy

I just spent a couple of hours interacting with Google's AI gizmo to help me manage closing values of about 30 tickers. I'm not a trader, but a meticulous pack-rat record keeper. Daily, weekly, monthly, quarterly, you get the idea.

It worked pretty well. 30 or 40 exchanges. On point answers and direction. Lots of macro code I'd never do otherwise. I'd never used Google sheets at all and had never spent any extended time interacting with an AI agent.

I've got tens of thousands of hours on Excel, but only in a limited fashion, so I'd never have been able to get this done on my own.

It kept apologizing for supplying me with erroneous code and then revising it.

I'm now configured to retrieve prices on command for those 30 tickers, and have them pasted into an Excel tab via macro at the click of a button. I'm interested only in closing prices, but could as easily request volume, daily range, 52 week, etc.

Years ago, I had this similarly automated, but certain web sites eventually made it problematic, so I was reduced to a manual copy/paste from an online portfolio with a bunch of columns and rows. That works, but its fidgety and time consuming.

So, put me down in favor of the cabal taking over the world and beyond. Your RAM prices and electricity bill be damned. Sarcasm?

Sigh...so far over my head. Doesn't do an old women any good to track the markets when what little she has is pinned inside her underwear.

glasskuter said:

Sigh...so far over my head. Doesn't do an old women any good to track the markets when what little she has is pinned inside her underwear.

Click to expand...

So I can claim I was just after your money?

A Guy