I need help developing my excel trade journal
- or -
Post a project like this2670
$$
- Posted:
- Proposals: 5
- Remote
- #1379814
- Awarded
Description
Experience Level: Intermediate
I am a financial trader and I want to be able to keep an accurate record of my trading and perform an analysis on the figures.
On bonds i want to be able to record the orders
date , time currency whether I buy or sell the bond order size the broker i placed order with any limitations any hedge instructions and then the allocation i may get .. plus a comment column for comments.
I want the trade blotter to record
trade date trade exit time whether i buy or sell currency the bond name the broker i bought from the commission i payed the broker (fee) size of my trade buy price sell price the net profit or loss. be able to convert to a currency of my choice and running total for month
I want to do the same with equity..
i want to keep a running total of my monthly profit and loss.. I want to be able to analyse my risk reward with brokers.. ie the return i get in allocation size to the size of the orders i place.
i want to be able to easily convert from a currency to another currency.. ie the running total should be able to choose usd eur or stg.
I dont need zero allocation from the bond orders tab to show on the bond trade blotter
I may place orders with multiple counter parties I then total up the total allocation I have for trading ... I pay each counterpart a commission .. I may sell as one total of combined allocation or as partial amount..
I am charged a fee for each time I execute a trade i.e. I may place orders with 3 counterparties and then receive 3 different amounts and then total up all individual allocation and then sell as one trade that would be 4 trades in total where I will be charged a fee 4 times the fee currently is say 20 dollars but this needs to be able to be changed for amount and currency ..,and account for in the total profit and loss calculations but also be a deprecate total do I can see the fees I am paying
each month must start a seperate profit and loss but a running record kept in running monthly totals.
I have attached a sample spread sheet of factious trades..
I have attached what I have designed but got am now stuck on.. I hope you may be able to use mine or come up with something much better
On bonds i want to be able to record the orders
date , time currency whether I buy or sell the bond order size the broker i placed order with any limitations any hedge instructions and then the allocation i may get .. plus a comment column for comments.
I want the trade blotter to record
trade date trade exit time whether i buy or sell currency the bond name the broker i bought from the commission i payed the broker (fee) size of my trade buy price sell price the net profit or loss. be able to convert to a currency of my choice and running total for month
I want to do the same with equity..
i want to keep a running total of my monthly profit and loss.. I want to be able to analyse my risk reward with brokers.. ie the return i get in allocation size to the size of the orders i place.
i want to be able to easily convert from a currency to another currency.. ie the running total should be able to choose usd eur or stg.
I dont need zero allocation from the bond orders tab to show on the bond trade blotter
I may place orders with multiple counter parties I then total up the total allocation I have for trading ... I pay each counterpart a commission .. I may sell as one total of combined allocation or as partial amount..
I am charged a fee for each time I execute a trade i.e. I may place orders with 3 counterparties and then receive 3 different amounts and then total up all individual allocation and then sell as one trade that would be 4 trades in total where I will be charged a fee 4 times the fee currently is say 20 dollars but this needs to be able to be changed for amount and currency ..,and account for in the total profit and loss calculations but also be a deprecate total do I can see the fees I am paying
each month must start a seperate profit and loss but a running record kept in running monthly totals.
I have attached a sample spread sheet of factious trades..
I have attached what I have designed but got am now stuck on.. I hope you may be able to use mine or come up with something much better
Chris P.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
11 Dec 2016
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies