Here some links to posts in another forum on this subject.
This one explains how to download stock quoted into MS Access from Yahoo and has a sample database to show how its done. If you want it to keep checking for quotes, you could create code for a timer to keep downloading it; however, these won't be realtime quotes from Yahoo. For that you could get a subscription from Yahoo for realtime quotes. For that matter there's code somewhere to download quotes from Google too. Google also has a subscription for realtime quotes. These realtime quote subscriptions are about $12 USD per month.MS Access Stock Quotes
This one explains how to connect your trading platform to your ThinkOrSwim (TOS) funded account where you can use both TOS and your other trading platform. MS Excel can be linked this way also. If someone can figure out how to use this same FREE DDE.dll
to connect MS Access to TOS, I would be interested. I'm trying to develop a database for my trades and I would prefer realtime data from TOS over delayed data from Yahoo. If someone figures how to use this dll in MS Access, please let me know.
Actually you can get a FREE paperMoney
account from either TOS or TD Ameritrade and although the practice trades are delayed 20 minutes, the data is realtime.Real Time Dynamic Data ExchangeAbout Dynamic Data Exchange
Both methods explain how to connect MS Excel to their data source. There seems to be a lot of sample MS Excel spreadsheets that get stock quotes, but not much is mentioned about doing this with MS Access except the first link above.