def appreciation(money_transactions, stocks, owner): m = prg.to_dataframe(money_transactions) m = m[m.owner == owner] m['neg'] = m.apply(lambda x: (x.quantity * (-1)), axis=1) subset = m[['dt_date', 'neg']] investments = [tuple(x) for x in subset.values] assets = st.worth_at_date_czk(stocks, date.today()) assets = assets.loc[owner] assets = assets.iloc[0] assetss = (date.today(), assets) investments.append(assetss) return xirr(investments)
import money as mn import read_transaction as rt import stocks as st import report as rp ## This is how the lambda is done # ds['total_czk'] = ds.total_value.apply(lambda x: x * cv.getUSDCZK()) ## Bezny check print "Akcie v USD" print "Dne: " + str(date.today()) print str(st.worth_at_date('../transactions/us_stocks', date.today())) print "V czk:" print str(st.worth_at_date_czk('../transactions/us_stocks', date.today())) print "Investovane penize" print mn.invested(rt.read_file('../transactions/czk')) print "Prodat lze" print str(st.three_years_test('../transactions/us_stocks')) print "Zhodnoceni" print "Honza" print str(rp.appreciation(rt.read_file('../transactions/czk'), '../transactions/us_stocks', 'jd')) print "Deni" print str(rp.appreciation(rt.read_file('../transactions/czk'), '../transactions/us_stocks', 'deni')) print "Mama" print str(rp.appreciation(rt.read_file('../transactions/czk'), '../transactions/us_stocks', 'mama')) print "Terka"
def test_worth_at_date_czk(): res = str(st.worth_at_date_czk('transactions', date(2014, 4, 10))) assert "alice 26071.359935" in res assert "bob 26071.359935" in res