df = pd.read_csv(filename, usecols=columns, delimiter='\t', encoding='utf-16') print(df.to_string()) pf = Portfolio() for index, row in df.iterrows(): ticker = row['Verdipapir'] amount = float(row['Antall'].replace(',', '.').replace(' ', '')) kurs = float(row['Kurs'].replace(',', '.').replace(' ', '')) vekslingskurs = float(row['Vekslingskurs'].replace(',', '.').replace(' ', '')) transaksjonstype = row['Transaksjonstype'] belop = float(row['Beløb'].replace(',', '.').replace(' ', '')) if transaksjonstype == 'KJØPT' or transaksjonstype == 'SALG': a = Asset(ticker) pf.add_asset(a) pf_asset = pf.get_asset(ticker) pf_asset.buy(amount, kurs * vekslingskurs) if belop < 0 else pf_asset.sell( amount, kurs * vekslingskurs) if transaksjonstype == 'INNSKUDD' or transaksjonstype == 'UTTAK INTERNET': if transaksjonstype == 'INNSKUDD': print(f"DEPOSIT: {belop}") pf.deposit(belop) for a in pf.get_assets(): print(a) print(pf)
my_portfolio = Portfolio() # Create Assets asset_one = Asset(7000, 'Equity', 'US', .5, .1) asset_two = Asset(1000, 'Fixed', 'EM', .3, .2) asset_three = Asset(2000, 'Equity', 'DM', .08, .075) asset_four = Asset(30000, 'Equity', 'US', .06, .085) asset_five = Asset(6000, 'Fixed', 'EM', .05, .03) asset_six = Asset(2000, 'Equity', 'DM', .08, .075) asset_seven = Asset(30000, 'Equity', 'US', .06, .085) # Create Liabilities liability_one = Liability(1500, .03, 30) liability_two = Liability(6500, .03, 30) # Add Assets to Portfolio my_portfolio.add_asset(asset_one) my_portfolio.add_asset(asset_two) my_portfolio.add_asset(asset_three) my_portfolio.add_asset(asset_four) my_portfolio.add_asset(asset_five) my_portfolio.add_asset(asset_six) #my_portfolio.add_asset(asset_seven) # Add Liabilities to Portfolio my_portfolio.add_liability(liability_one) my_portfolio.add_liability(liability_two) # Create Asset and Liabilities Dataframes pd_assets = my_portfolio.asset_dataframe() pd_liability = my_portfolio.liability_dataframe()