Live data from stock market

[timothy_A]

Hi,

I was wondering if it’s possible to track live date from the stock market.

For example i want to show Apple shares and the live price of the day.

Thanks in advance!

[Darren_Murphy]

Yes, it’s possible. All you need is a data source. A quick and dirty way would be to use the GOOGLEFINANCE Google sheets function.

[spencersRus]

This is something I was playing around with last year. Have not looked at it in while, But you can copy it and look at the underlying google sheet.

Hot stock app

I have been playing around with a “Stock Market Game” simulator. Take a look at it here Two Main Screens Portfolio: Assets listed with current holdings and balances Trading Floor: All available stocks listed with current stock prices Students buy and sell stocks with google finance supplied stock prices. The thing I REALLY like: HOT STOCK If you have at least $2500 in the bank you will randomly get a HOT STOCK ALERT that will ask you if you want to invest right away. Sometimes, it is a…

(and I think the google finance may be delayed up to 20 minutes in google sheets)

Using Google Spreadsheet to Track a Stock Portfolio

[eltintero]

yes, we’re building an app just like that, actually, and integrating a 3rd party API to bring in a lot of information per stock:

[timothy_A]

Thanks! found it

[makoken]

It looks like you used QuoteMedia API? I attempted to use StockDio but received an error when using =Apipheny(). Any tips here?

I am in the early stages of this and am assuming QuoteMedia will cost a bit upfront so I wanted to give Stockdio a shot.