Crear un porftolio de seguimiento de cartera usando google sheets
Budget: €8 – €30 EUR
I am looking for a freelancer to create a portfolio tracking system using Google Sheets. The portfolio will include stocks only.
-The portfolio must be updated and automatized shows profitability, amount of money invested, amount of shares, stock price, starting date of investment in a stock, consider the exchange rate of currencies and the commissions paid. The currencies used are: EUR,USD,PLN,DKK,AUD,GBP,CAD,SEK,CHF,NOR,CAD.
-It must show the historical movements of buys and sells and its performance.
-It must used the FIFO method.
-Rule of 2 months: refrain from repurchasing your stocks and offsetting losses and gains in the stock market
-It must included the following operations:sell,buy, dividend,split,contrasplit,deposit,withdrawal.
Ideal skills and experience for the job would include:
- Expertise in Google Sheets
- Experience in creating automated portfolio tracking systems
- Knowledge of stock market data and terminology
-The portfolio must be updated and automatized shows profitability, amount of money invested, amount of shares, stock price, starting date of investment in a stock, consider the exchange rate of currencies and the commissions paid. The currencies used are: EUR,USD,PLN,DKK,AUD,GBP,CAD,SEK,CHF,NOR,CAD.
-It must show the historical movements of buys and sells and its performance.
-It must used the FIFO method.
-Rule of 2 months: refrain from repurchasing your stocks and offsetting losses and gains in the stock market
-It must included the following operations:sell,buy, dividend,split,contrasplit,deposit,withdrawal.
Ideal skills and experience for the job would include:
- Expertise in Google Sheets
- Experience in creating automated portfolio tracking systems
- Knowledge of stock market data and terminology