Completion of my started Libreoffice Excel Trading Journal, make it work.
Budget: $10 – $30 USD
Hi,
Contact me in chat after you are sure you`ve understood the project!
SEE ATTACHMENT!
This is a custom day trading journal I`ve been working on but all text is just static and I need YOU to make this excel sheet work properly.
That means it have to be automatically calculating different metrics such as weekly and monthly profit & loss %, total number of fees, total account balance,
win rate %, average win, average loss, largest win, largest loss, total winning trades, total losing trades, total trades, total profit in usd and total loss in
usd based on (of course) the numbers I type in every day.
So you need to be good at mathematics, calculus and formulas. it helps if you understand the trading business.
I`ve already made the excel sheet with most of the necessary columns, cells and text, but they are just static at the moment.
When I`m typing in daily day trading information, All the formulas and calculations need to be working perfectly.
It also need some touch up regarding cells, position of columns, text and colors.
Please see attachment and make sure you fully understand how to do the calculations formulas and so on.
This should be a fairly easy project for a skilled excel expert with calculus knowledge.
Please note this is LIBREOFFICE EXCEL AND NOT MICROSOFT EXCEL!
This is what needs to be done,
Calculations of:
profit/loss (average) based on profit/loss usd column.
account Balance based on profit/loss usd column and deposit column minus total fees column.
win rate % based on win/lose color column OR profit/loss usd column.
average win based on profit/loss usd column.
average loss based on profit/loss usd column.
largest win based on profit/loss usd column.
largest loss based on profit/loss usd column.
weekly and monthly profit & loss (P/L) usd columns based on profit/loss usd column minus the fees column.(negative can be red, profit can be green i.e)
total winning trades based on the win/loss color column.
total losing trades based on the win/loss color column.
total trades based on numbers of trades column.
total number of fees based on the fees column. Please add a total fees column somewhere around the other columns under the trade log font.
total account balance based on profit/loss column minus total fees column.
win rate % based on win/lose color column. In the win/loose clr column I want Green for win and Red for loss based from the profit/loss usd column. OR if easier
profit/loss usd can be based on what color I choose in the win/loose color colum, the two columns then need to switch places.
total profit in usd based on the profit/loss usd column.
total loss in usd based on the profit/loss usd column.
please add a Total trade duration column in proximity of the total fees column you created.
Touch up:
Please make the columns correct lenght according to text.
Time column corrections, please center the numbers. 24h format.
Please make notes column grey too.
That`s it!
Contact me in chat after you are sure you`ve understood the project!
SEE ATTACHMENT!
This is a custom day trading journal I`ve been working on but all text is just static and I need YOU to make this excel sheet work properly.
That means it have to be automatically calculating different metrics such as weekly and monthly profit & loss %, total number of fees, total account balance,
win rate %, average win, average loss, largest win, largest loss, total winning trades, total losing trades, total trades, total profit in usd and total loss in
usd based on (of course) the numbers I type in every day.
So you need to be good at mathematics, calculus and formulas. it helps if you understand the trading business.
I`ve already made the excel sheet with most of the necessary columns, cells and text, but they are just static at the moment.
When I`m typing in daily day trading information, All the formulas and calculations need to be working perfectly.
It also need some touch up regarding cells, position of columns, text and colors.
Please see attachment and make sure you fully understand how to do the calculations formulas and so on.
This should be a fairly easy project for a skilled excel expert with calculus knowledge.
Please note this is LIBREOFFICE EXCEL AND NOT MICROSOFT EXCEL!
This is what needs to be done,
Calculations of:
profit/loss (average) based on profit/loss usd column.
account Balance based on profit/loss usd column and deposit column minus total fees column.
win rate % based on win/lose color column OR profit/loss usd column.
average win based on profit/loss usd column.
average loss based on profit/loss usd column.
largest win based on profit/loss usd column.
largest loss based on profit/loss usd column.
weekly and monthly profit & loss (P/L) usd columns based on profit/loss usd column minus the fees column.(negative can be red, profit can be green i.e)
total winning trades based on the win/loss color column.
total losing trades based on the win/loss color column.
total trades based on numbers of trades column.
total number of fees based on the fees column. Please add a total fees column somewhere around the other columns under the trade log font.
total account balance based on profit/loss column minus total fees column.
win rate % based on win/lose color column. In the win/loose clr column I want Green for win and Red for loss based from the profit/loss usd column. OR if easier
profit/loss usd can be based on what color I choose in the win/loose color colum, the two columns then need to switch places.
total profit in usd based on the profit/loss usd column.
total loss in usd based on the profit/loss usd column.
please add a Total trade duration column in proximity of the total fees column you created.
Touch up:
Please make the columns correct lenght according to text.
Time column corrections, please center the numbers. 24h format.
Please make notes column grey too.
That`s it!