Live stock quotes(?)

calc

asked 2020-05-17 19:24:57 +0100

Bodrey
1 ●1 ●1 ●1

I just created a spreadsheet in Calc to keep track of the stocks I've purchased. I'd like to create a column that allows me to monitor a stock's price in real time. Is it possible to link to a live stock quote web site? I'm pretty sure there's a way to do it but I can't figure it out. I found a video using Google and the person said to use the Insert > Link to External Data function but it's not there. Perhaps it was an older version of Calc in the video from what I have(?). Could someone please explain the procedure (if it's possible) and also what web site link would I enter to pull a stock's live quote price? For example, what link would give me a live stock quote for Amazon? TIA

edit retag flag offensive close merge delete

add a comment

0

answered 2021-01-25 02:58:03 +0100

Jampod
1

I was able to get it to work with a googlesheet using the GOOGLEFINANCE function. Then to get it in calc, I chose my sheet to <publish to="" the="" web="">. I then copied that web link in the following menu path: insert>link to external data.

And it worked!

image description

edit flag offensive delete link

add a comment

0

answered 2021-01-05 15:20:46 +0100

jldavid47
1

I have found a way. First, create an account on https://iexcloud.io. There are various levels of membership, one of which is free which allows 50,000 API calls per month. If you want a lot of data you can pay for an individual membership which gives you 1,000,000 API calls per month for $9 per month. Once you have an account they give you an API token which is needed to use the API. Use the secret token, not the publishable one. In LibreOffice, you then put this into the cell (for Amazon) to get the latest price (substituting your API token).

=NUMBERVALUE(WEBSERVICE("https://cloud.iexapis.com/stable/stock/amzn/quote/latestPrice?token=YOUR_TOKEN_HERE"),".")

More complete documentation for the API can be found at:

https://iexcloud.io/docs/api