Hello all,
I believe in statistics - I think if we have a look at someone's stats, it says a lot about the trader's style, performance and habits. Position traders won't have many 10 pip trades and scalpers won't have trades that last for days. It is also interesting to have an eye on what % of your trades were profitable, did you win/lose more on shorts that longs etc etc.
I think there are many many good and profitable strats and I don't want to open a discussion on trading or MM issues. Scalping the tick charts can be as profitable as trading trends on the daily, or using some stats-based correlational strategy that cares little for support & resistance or candlestick formations.
I created a tool that can be used to evaluate our trading based on Oanda transaction logs. It's an MS Access database - I will explain all the important details and encourage others to add their modifications and post it back to the thread. You can also post ideas/requests, but I cannot guarantee that I will have time to add them.
Also please put in some effort before asking very basic things like "how can I save the trades log in Oanda".
I use this tool mainly to check if my win/loss ratio does not deviate from the yearly average. Also gives me a quick overview of how many pips I earned versus pips lost, which pairs were traded most, what was my smallest/biggest/average winner/loser, average position size etc. etc.
So here is the file along with usage instructions. Please find the thread attachments list and pick the most recent file.
1. You need Access 2000 or later installed. Please if posting back any modifications, make sure the file is saved in this format. I personally don't have the latest Office and Microsoft tends to save everything in the newst format by default.
2. Save your Oanda transaction log from the web browser as "plain html". Note you can adjust the list a bit (filters, profile etc). The statement should be in English.
3. Open the MDB file. If the file has a Transactions table already, and you want to create new stats, then you will have to delete that table first.
4. Import the html file (import wizard somewhere under File menu in Access):
-Select "first row has column names".
Other options don't matter much, probably the "Balance" field name will cause a warning because it contains a space in the html file like "Balance (USD)".
Please check column names offered by Access and make sure the last one is Balance.
5. Save the data to new table called Transactions.
6. Run the numbered queries (1...13). Those will preprocess and format the data a bit. If asked about rows changed/deleted, click OK.
Now you can use the other queries (those without numbers). The most important is ClosedTrades, which is a nice list with open-close tickets, dates and prices. You can export this trades list to Excel (right-click ClosedTrades then Export). After exporting to Excel, if you share the file, you might want to delete some columns in the XLS file for privacy - eg. Balance, OpenedUnits etc.
The other queries provide stats about your trading.
There are 2 functions in the code module that might need your attention.
First is StringToDate that converts Oanda date/time to my time (that is CET, GMT+1). So feel free to change the "DateAdd" statement in the last line to match your time zone. (No, don't ask me what's your timezone).
Nothing bad happens if you can't or don't want to delve into the code module - you will have trade times in CET, and what then?
Another function that might need your attention is PipDigits. It tells which digit after the decimal is the pip value for a certain pair. As you might have guessed, I have added only those that I traded. You don't need to add every possible pair there, only those where the "pip" is not the 4th digit after the decimal. Such an example is - gold, USD/MXN or all JPY pairs.
(Yes I know Oanda displays 5 decimals for all majors eg. GBP/USD - 1.45678 but the "8", is a pipette, so the pip is the 4th digit, that is "7".)
Not sure but I think you would have to add NOK and other krones too. It's simple to check whether you're right - have a look at the Pips row of ClosedTrades - if it's how much you earned/lost on that trade, then your PipDigits function needs no modifications.
Huh, that should be enough for a start...if interested, please find the attached zip file (forum does not accept MDB files, so had to zip it)
Happy stats creation, I hope it will help you to improve your trading, find your strengths and weaknesses too.
I believe in statistics - I think if we have a look at someone's stats, it says a lot about the trader's style, performance and habits. Position traders won't have many 10 pip trades and scalpers won't have trades that last for days. It is also interesting to have an eye on what % of your trades were profitable, did you win/lose more on shorts that longs etc etc.
I think there are many many good and profitable strats and I don't want to open a discussion on trading or MM issues. Scalping the tick charts can be as profitable as trading trends on the daily, or using some stats-based correlational strategy that cares little for support & resistance or candlestick formations.
I created a tool that can be used to evaluate our trading based on Oanda transaction logs. It's an MS Access database - I will explain all the important details and encourage others to add their modifications and post it back to the thread. You can also post ideas/requests, but I cannot guarantee that I will have time to add them.
Also please put in some effort before asking very basic things like "how can I save the trades log in Oanda".
I use this tool mainly to check if my win/loss ratio does not deviate from the yearly average. Also gives me a quick overview of how many pips I earned versus pips lost, which pairs were traded most, what was my smallest/biggest/average winner/loser, average position size etc. etc.
So here is the file along with usage instructions. Please find the thread attachments list and pick the most recent file.
1. You need Access 2000 or later installed. Please if posting back any modifications, make sure the file is saved in this format. I personally don't have the latest Office and Microsoft tends to save everything in the newst format by default.
2. Save your Oanda transaction log from the web browser as "plain html". Note you can adjust the list a bit (filters, profile etc). The statement should be in English.
3. Open the MDB file. If the file has a Transactions table already, and you want to create new stats, then you will have to delete that table first.
4. Import the html file (import wizard somewhere under File menu in Access):
-Select "first row has column names".
Other options don't matter much, probably the "Balance" field name will cause a warning because it contains a space in the html file like "Balance (USD)".
Please check column names offered by Access and make sure the last one is Balance.
5. Save the data to new table called Transactions.
6. Run the numbered queries (1...13). Those will preprocess and format the data a bit. If asked about rows changed/deleted, click OK.
Now you can use the other queries (those without numbers). The most important is ClosedTrades, which is a nice list with open-close tickets, dates and prices. You can export this trades list to Excel (right-click ClosedTrades then Export). After exporting to Excel, if you share the file, you might want to delete some columns in the XLS file for privacy - eg. Balance, OpenedUnits etc.
The other queries provide stats about your trading.
There are 2 functions in the code module that might need your attention.
First is StringToDate that converts Oanda date/time to my time (that is CET, GMT+1). So feel free to change the "DateAdd" statement in the last line to match your time zone. (No, don't ask me what's your timezone).
Nothing bad happens if you can't or don't want to delve into the code module - you will have trade times in CET, and what then?
Another function that might need your attention is PipDigits. It tells which digit after the decimal is the pip value for a certain pair. As you might have guessed, I have added only those that I traded. You don't need to add every possible pair there, only those where the "pip" is not the 4th digit after the decimal. Such an example is - gold, USD/MXN or all JPY pairs.
(Yes I know Oanda displays 5 decimals for all majors eg. GBP/USD - 1.45678 but the "8", is a pipette, so the pip is the 4th digit, that is "7".)
Not sure but I think you would have to add NOK and other krones too. It's simple to check whether you're right - have a look at the Pips row of ClosedTrades - if it's how much you earned/lost on that trade, then your PipDigits function needs no modifications.
Huh, that should be enough for a start...if interested, please find the attached zip file (forum does not accept MDB files, so had to zip it)
Happy stats creation, I hope it will help you to improve your trading, find your strengths and weaknesses too.
Attached File(s)
oandastats.zip
26 KB
|
614 downloads
forget about tomorrow, just steal away into the night