Live data from stock market


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!

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.


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.

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

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:
Level Insights · Glide 2021-04-05 at 6.15.18 PM
Level Insights · AMZN 2021-04-05 at 6.16.11 PM
Level Insights · Edit stocks 2021-04-05 at 6.16.42 PM


Thanks! found it

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.