Ask Your Question
0

Live stock quotes(?)

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

Bodrey gravatar image

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

4 Answers

Sort by » oldest newest most voted
0

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

Jampod gravatar image

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

image description

edit flag offensive delete link more
0

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

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

edit flag offensive delete link more

Comments

Note: this does not give you continuous live quotes but it will refresh when you recalculate the spreadsheet.

jldavid47 gravatar imagejldavid47 ( 2021-01-05 15:57:09 +0100 )edit
0

answered 2020-05-19 02:36:55 +0100

erAck gravatar image

You'll find Link to External Data under the Sheet menu, not Insert (that was some versions ago). See also the help.

edit flag offensive delete link more
0

answered 2020-05-17 19:36:02 +0100

Pansmanser gravatar image

I think you want insert-hyperlink, but you'll need to be sure that the external data is in, or can be manipulated into a form you want.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

3 followers

Stats

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

Seen: 4,646 times

Last updated: Jan 25