diff options
Diffstat (limited to 'generate_prices')
| -rwxr-xr-x | generate_prices | 38 |
1 files changed, 2 insertions, 36 deletions
diff --git a/generate_prices b/generate_prices index c9696aa..a167e2b 100755 --- a/generate_prices +++ b/generate_prices @@ -1,47 +1,13 @@ -#!/usr/bin/python +#!/usr/bin/python3 -from gnucash import Session, Account, Split, GncPrice from alpha_vantage.timeseries import TimeSeries -from fractions import Fraction -from datetime import datetime - -session = Session("xml://./money.gnucash") -root = session.book.get_root_account() -book = session.book -account = book.get_root_account() -pdb = book.get_price_db() - -table = book.get_table() symbols = ["GOOGL", "APPL"] for symbol in symbols: - stock = table.lookup("NASDAQ", symbol) - cur = table.lookup("CURRENCY", "USD") - - prices = pdb.get_prices(stock, cur), - price = prices[0][0] - - for i in range(1, len(prices)): - pdb.remove_price(prices[i]) - ts = TimeSeries(key="your alpha_vantage key") data, meta_data = ts.get_monthly(symbol) - for key in data: - desired_years = ["2017", "2018"] for year in desired_years: if year in key: - new_price = price.clone(book) - new_price = GncPrice(instance = new_price) - year, month, day = list(map(int, key.split("-"))) - new_price.set_time(datetime(year, month, day)) - value = new_price.get_value() - value.num = int(Fraction.from_float(float(data[key]["4. close"])).limit_denominator(100000).numerator) - value.denom = int(Fraction.from_float(float(data[key]["4. close"])).limit_denominator(100000).denominator) - new_price.set_value(value) - pdb.add_price(new_price) - -session.save() -session.end() -session.destroy() + print("P " + key.replace("-", "/") + " " + symbol + " " + data[key]["4. close"] + " USD") |