[TRADE TRACKING]
Spent most of the weekend programming a new spreadsheet for Excel. Always have to manually enter trades because my platform won't export the data. Anyway, pretty pleased with the outcome.
Couple of teething programs about the Excel code, I'm trying to code an IF AND THEN COUNT with minimal success. This part is for IF (setup) AND (profit) THEN (count). I would also like to try to eventually program in an odds calculator. For example if X and Y setups consistently reap profit on X, then increase reward ratios.
I am currently programming a risk:reward to profit ratio which should be interesting. Basically it involves a pre-trade calculator that will give you a number between 1 and 5. The numbers are based on historical data and represent high risk to low risk and high reward to low reward. If I can combine this data with average profits based on the particular setup, the calculator should then show if your odds are strongly favourable or are very weak.
I normally use risk reward as a simple ratio where target gains/target loss. The higher the number the better. This is good in itself, but I think combining it with other probabilities will give a good decision making calculation.
I also need to find a way to export trade data through VBA into Excel.
Anyway the entry screen (simple):
Outcome (with sample data):
Topical information:
I'm sure there are programs out there that do all of this for you, but I needed a challenge for the weekend. I'll spend most of tonight thinking of other information to put in there.
Couple of teething programs about the Excel code, I'm trying to code an IF AND THEN COUNT with minimal success. This part is for IF (setup) AND (profit) THEN (count). I would also like to try to eventually program in an odds calculator. For example if X and Y setups consistently reap profit on X, then increase reward ratios.
I am currently programming a risk:reward to profit ratio which should be interesting. Basically it involves a pre-trade calculator that will give you a number between 1 and 5. The numbers are based on historical data and represent high risk to low risk and high reward to low reward. If I can combine this data with average profits based on the particular setup, the calculator should then show if your odds are strongly favourable or are very weak.
I normally use risk reward as a simple ratio where target gains/target loss. The higher the number the better. This is good in itself, but I think combining it with other probabilities will give a good decision making calculation.
I also need to find a way to export trade data through VBA into Excel.
Anyway the entry screen (simple):
Outcome (with sample data):
Topical information:
- Calculates individual trade performance
- Calculates daily trade performance
- Calculates performance by setup
- Calculates profits by stock
- Calculates win loss ratios
- Calculates S/L bias and percentages
- Interprets whether you are currently beating hypothetical profits
- Calculates closed trades by Targets met, Targets exceeded or Failed to meet
- Interprets your ability to close out a trade with regards to entry targets
- Displays cumulative net profit
- Trade browser tree by Date/Profit/Share/Direction/Setup
- Trade cross-reference
- Long =1
- Short = 7
- Win = 1
- Loss = 10
- 8 = Short win
- 17 = Short loss
- 2 = Long win
- 11 = Long loss
I'm sure there are programs out there that do all of this for you, but I needed a challenge for the weekend. I'll spend most of tonight thinking of other information to put in there.
0 comments:
Post a Comment