Pedro Viana pedrovgp

Recently created

Least recently created

Recently updated

Least recently updated

pedrovgp / upsert_df.py

Last active August 22, 2024 05:32

Allow upserting a pandas dataframe to a postgres table (equivalent to df.to_sql(..., if_exists='update')

	# Upsert function for pandas to_sql with postgres
	# https://stackoverflow.com/questions/1109061/insert-on-duplicate-update-in-postgresql/8702291#8702291
	# https://www.postgresql.org/docs/devel/sql-insert.html#SQL-ON-CONFLICT
	import pandas as pd
	import sqlalchemy
	import uuid
	import os


	def upsert_df(df: pd.DataFrame, table_name: str, engine: sqlalchemy.engine.Engine):

pedrovgp / fetch_stock_prices_for_gnucash.py

Last active March 29, 2021 14:50

Python script to fetch stock prices for gnucash using http://alphavantage.co/ api. Since Quotes::Finance fetching from Yahoo finance no longer works, it is an alternative.

	# INSTALL DEPENDENCIES BEFORE RUNNING: pandas, sqlite3, sqlalchemy, requests
	# There is one thing you have to do though: gnucash needs to know the price's currency and it needs a guid (unique identifier)
	# for this. This guid is unique for each installation, so you need to find yours and assign it to CURRENCY_GUID.
	# OR: you can just leave it, and the script will fetch the currency from the last price added
	import pandas as pd
	import sqlite3
	import sqlalchemy
	from sqlalchemy import create_engine

	import datetime