Giter VIP home page Giter VIP logo

python-stock-data-analysis-postgresql's Introduction

Python-Stock-Data-Analysis-PostgreSQL

This repository contains a Python project that imports, processes, and stores comprehensive stock market data from Yahoo Finance using Pandas, NumPy, yfinance, and PostgreSQL, enabling in-depth analysis and insights for better investment decisions.

Project Overview

The project involves:

  • Extracting stock market data from Yahoo Finance using the yfinance library.
  • Processing and cleaning the data using Pandas and NumPy.
  • Storing the processed data in a PostgreSQL database for efficient management and advanced financial analysis.

The stock market data includes information such as historical stock prices, options chain data, company information, institutional ownership, balance sheets, cash flow, income statements, analyst recommendations, earnings expectations, and ESG metrics.

Prerequisites

To run this project, you'll need to have the following installed:

  • Python 3.7 or higher
  • PostgreSQL

python-stock-data-analysis-postgresql's People

Contributors

danbishop14 avatar

Stargazers

avatar avatar avatar

Watchers

avatar

Forkers

cjbd

python-stock-data-analysis-postgresql's Issues

Cannot write to database

Hi. Came across this repo. I was looking for a smart way to create an DB for options data. When I ran the script, the writing of option chain data into option_chains breaks with error:

ProgrammingError; can't adapt type 'record'

In fact, the data frame is of type numpy.recarray and not pandas dataframe
Second: Why is iscall of type float? Shouldn't it be typ BOOL?

Third: where does the dt.date originate (the dt?)

4th: There are multiple warnings from pandas when running the get_options_chain_df: .append() is deprecated, use concat() instead... did someone converted the code using concat()?

best

Extremely useful stuff with a ?

Hi and thanks for your code,
it looks like a real gem in a totally desolate land, since the whole framework stands on a library (yfinance) that is 90% unusable due to strict limitations from Yahoo on non-price data. Anyway thanks for your effort!

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.