Python Forum
Stock market data in LibreOffice Calc
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Stock market data in LibreOffice Calc
#1
Question 
Hi everyone,

I am new to the world of Python. I have seen that Python is also widely used in finance, so I would like to ask you if with this language it is possible to do what I am looking for.
For my initial project, I would like to automatically import stock market data from the year 2000 into a LibreOffice spreadsheet.
Once acquired, I would like for each financial instrument (stocks, commodities, ETF, FX, etc.) to be presented a row with the following columns:
  • Ticker
  • Company name
  • Country
  • Sector
  • Minimum value reached from 2000-01-01 to date
  • Maximum value reached from2000-01-01 to date
  • Maximum loss from 2000-01-01 to date

I would therefore like to ask you:
  • Is it possible to import data with Python and "transfer" it into a LibreOffice Calc sheet?
  • Also, is it possible to capture data with Python that goes so far back in time?
Thanks in advance to anyone who has read this far!
Reply
#2
(Jan-07-2021, 11:24 AM)Pitone Wrote: [*]Is it possible to import data with Python and "transfer" it into a LibreOffice Calc sheet?

[*]Also, is it possible to capture data with Python that goes so far back in time?

You can write to a spreadsheet (Excel/LibreOffice,etc.). More over as far as I know LibreOffice provide API to use python as scripting language.


How far back in time goes your [raw] data depends on your source. It's not something that would be limited by python itself.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

Reply
#3
(Jan-07-2021, 01:27 PM)buran Wrote: You can write to a spreadsheet (Excel/LibreOffice,etc.). More over as far as I know LibreOffice provide API to use python as scripting language.


How far back in time goes your [raw] data depends on your source. It's not something that would be limited by python itself.
Thank you for your reply!
At this point a question arises spontaneously: is there a universally recognized stock market data source to interface better with Python and to be very valid when speaking of the amount of data available in it?
Secondly, then, to do what I am looking for, what should my path be? Learning Python, learning to use the API... Is there anything else?
Reply
#4
(Jan-07-2021, 03:05 PM)Pitone Wrote:
(Jan-07-2021, 01:27 PM)buran Wrote: You can write to a spreadsheet (Excel/LibreOffice,etc.). More over as far as I know LibreOffice provide API to use python as scripting language.


How far back in time goes your [raw] data depends on your source. It's not something that would be limited by python itself.
Thank you for your reply!
At this point a question arises spontaneously: is there a universally recognized stock market data source to interface better with Python and to be very valid when speaking of the amount of data available in it?
Secondly, then, to do what I am looking for, what should my path be? Learning Python, learning to use the API... Is there anything else?

Whats up Piton, I am in the Financial Industry and learning Python for finance also. I am going to be taking it a step further than all of the other people trying to do the same thing.

I have been testing out yahoo-finance and yfinance, which both can be pip installed. But IexCloud is probably what your looking for(although iex is a paid service) especially if you want more of the in-depth data. I built an app using it, but at this time with the early stage of my development I am not ready to pay for it.

You can try using beautifulsou4 to webscrape if you want to try getting live data free.

hope this helps. I am attempting to pull multiple sources to data using my financial knowledge with neuro networking to build an extremely accurate application.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Problem with calculation of market data MrQuant1 0 560 Jan-12-2024, 12:38 AM
Last Post: MrQuant1
  Market Basket Analysis: Finding Association Rules kylenater 1 2,060 Jun-21-2019, 03:53 AM
Last Post: scidam
  "Use proper inputs to download stock data" Alberto 15 9,130 Jan-29-2018, 02:03 PM
Last Post: Alberto

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020