Hello ,
I would like to retrieve 1 min and 1 hour live data from IB TWS into Openoffice calculate.
As an example, the 1 hour data would look like this
Time Open High Low Close
22:00:00 3194.25 3196.25 3191.75 3192.75
23:00:00 3192.75 3194.75 3190.75 3192.25
00:00:00 3192.50 3194.25 3191.25 3192.00
Is anyone doing this already - can it be done? Need some help please to get this up and running. Already looked at IBs site for help but they work with excel and I could not find my way with their documentation.
Thx!
User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
OpenOffice Calculate with IB TWS
6 posts
• Page 1 of 1
Re: Openoffice Calculate with IB TWS
by Zizi64 » Thu Jul 16, 2020 5:46 am
Try the "Link to external data" feature.
It works with some web pages, and not works with others depending on the technology what the webpage was created with.
Please give us a link, and point it, which table of the web page you want to link to your spreadsheet file. Then we will able try and check it.
It works with some web pages, and not works with others depending on the technology what the webpage was created with.
Please give us a link, and point it, which table of the web page you want to link to your spreadsheet file. Then we will able try and check it.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
Zizi64 - Volunteer
- Posts: 9724
- Joined: Wed May 26, 2010 7:55 am
- Location: Budapest, Hungary
Re: OpenOffice Calculate with IB TWS
by statiyo » Fri Jul 17, 2020 12:48 am
Hello!
This is the software I would like to use with openoffice: https://www.interactivebrokers.com/en/i ... s-software
However am not obliged to work with IB TWS... simply put, looking for a way to obtain in openoffice, live 1 minute data for USA stocks in the following format:
Open, High, Low, Close
Thx!
This is the software I would like to use with openoffice: https://www.interactivebrokers.com/en/i ... s-software
However am not obliged to work with IB TWS... simply put, looking for a way to obtain in openoffice, live 1 minute data for USA stocks in the following format:
Open, High, Low, Close
Thx!
OpenOffice 4.1 on Windows XP
- statiyo
- Posts: 7
- Joined: Mon Jul 15, 2019 3:56 am
Re: OpenOffice Calculate with IB TWS
by Zizi64 » Fri Jul 17, 2020 6:55 am
It is not a link pointing a webpage that contains some online data (or data tables).
I suppose it: the linked software - what you using now - creates some files, what you want to open in the AOO Calc. Am I right?
I suppose it: the linked software - what you using now - creates some files, what you want to open in the AOO Calc. Am I right?
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
Zizi64 - Volunteer
- Posts: 9724
- Joined: Wed May 26, 2010 7:55 am
- Location: Budapest, Hungary
Re: OpenOffice Calculate with IB TWS
by statiyo » Sat Jul 18, 2020 8:29 pm
Hi,
I actually found an excel sample file provided by Interactive brokers.
File can be obtained here: https://www.interactivebrokers.com/php/ ... eIntro.htm
However doesn't seem to work with openoffice.
For example, when I I click request historical data I get error message A SCRIPTING FRAMEWORK ERROR OCCURED WHILE RUNNING THE UNKNOWN SCRPIT UNKNOWN
notes for use of file available here: https://www.interactivebrokers.com/en/index.php?f=1062
Can this file work in openoffice?
I actually found an excel sample file provided by Interactive brokers.
File can be obtained here: https://www.interactivebrokers.com/php/ ... eIntro.htm
However doesn't seem to work with openoffice.
For example, when I I click request historical data I get error message A SCRIPTING FRAMEWORK ERROR OCCURED WHILE RUNNING THE UNKNOWN SCRPIT UNKNOWN
notes for use of file available here: https://www.interactivebrokers.com/en/index.php?f=1062
Can this file work in openoffice?
OpenOffice 4.1 on Windows XP
- statiyo
- Posts: 7
- Joined: Mon Jul 15, 2019 3:56 am
Re: OpenOffice Calculate with IB TWS
by Villeroy » Sat Jul 18, 2020 8:51 pm
They built some application around MS Excel. Of course this can not work with any spreadsheet program other than MS Excel.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4
-
Villeroy - Volunteer
- Posts: 29279
- Joined: Mon Oct 08, 2007 1:35 am
- Location: Germany
6 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 11 guests
|
Forum powered by phpBB © phpBB Group
By any use of this Website, you agree to be bound by these Policies and Terms of Use |
Get OpenOffice
|