How can I get real time (or updatable) stock quotes in calc? I saw a sample spreadsheet on this (stock.ods), however, it doesn’t do anything!
Thank you in advance,
Randy Katz
It appears that this question does not currently have a solution, and yet, this would be a very useful thing to have in calc. So I have re-opened it in hopes that one or more people can someday post an answer here to solve this issue.
Both E-Trade and TDAmeritrade when asked how to download just the day’s closing quotes told me that in order to automate such I had to write an ap that would query their website but required my logging in first.
The best I’ve come up with is to setup a watchlist in Yahoo but I’ve not gotten to the point of clicking the ‘Export’ button via a script yet.
Best of luck, Mike
jStock sourced here can get info and history for currently 8,486 different stocks in Linux, Android, and Windows.
So perhaps that offers a clue as to where to get this from. I didn’t see anything in the options to set this up, but perhaps I missed it.
Although Help|About|License shows a GNU license, the source at github says this, “JStock is NOT a fully open source project. Some of the code components are closed source. You will NOT able to compile JStock even after downloading source code from here.”
Might be able to use wire-shark or some form of http packet sniffer to reverse engineer what is going on and where the data is coming from.
Or perhaps from one of these APIs.
So perhaps that offers a clue as to where to get this from. I didn’t see anything in the options to set this up, but perhaps I missed it.
Although Help|About|License shows a GNU license, the source at github says this, “JStock is NOT a fully open source project. Some of the code components are closed source. You will NOT able to compile JStock even after downloading source code from here.”
Might be able to use wire-shark or some form of http packet sniffer to reverse engineer what is going on and where the data is coming from.
Or perhaps from one of these APIs.
This isn’t real-time, but does update frequently
1 Like