I am building an access database which calculates the profitability of trading foreign exchange under different levels of leverage. I have created a query which reviews the % of the account value gained or lost for each trade under different leverage scenarios. This is represented in the following query, called "% made per trade at different amounts of leverage". The query currently shows the following partial results, (which are comma delimited, and is actually 1280 records), and was created using the following SQL: SELECT [% of account per 100 pips].[% of account per 100 pips], [Entry and exit with pips made].[Pips made], [Pips made]*[% of account per 100 pips]/100 AS [% of account made per trade], 1+[% of account made per trade] AS [Account multiplier]
FROM [% of account per 100 pips], [Entry and exit with pips made];
What I want to do in a new query, is multiply all of the values of "account multiplier" by each other, for each value of "% of account per 100 pips", thereby giving the total value of a trading account for all of the trades, using each amount of leverage. This then allows traders to optimise the amount of leverage they should be using for their style of trading. I always seem to run into problems with access whenever I try to do anything with data that all comes from the same field, can anyone help me please.
% of account per 100 pips,Pips made,% of account made per trade,Account multiplier
1.00%,100,0.01,1.01
1.00%,109,0.0109,1.0109
1.00%,3,0.0003,1.0003
1.00%,24,0.0024,1.0024
1.00%,-39,-0.0039,0.9961
1.00%,-50,-0.005,0.995
1.00%,-50,-0.005,0.995
1.00%,-50,-0.005,0.995
2.00%,100,0.02,1.02
2.00%,109,0.0218,1.0218
2.00%,3,0.0006,1.0006
2.00%,24,0.0048,1.0048
2.00%,-39,-0.0078,0.9922
FROM [% of account per 100 pips], [Entry and exit with pips made];
What I want to do in a new query, is multiply all of the values of "account multiplier" by each other, for each value of "% of account per 100 pips", thereby giving the total value of a trading account for all of the trades, using each amount of leverage. This then allows traders to optimise the amount of leverage they should be using for their style of trading. I always seem to run into problems with access whenever I try to do anything with data that all comes from the same field, can anyone help me please.
% of account per 100 pips,Pips made,% of account made per trade,Account multiplier
1.00%,100,0.01,1.01
1.00%,109,0.0109,1.0109
1.00%,3,0.0003,1.0003
1.00%,24,0.0024,1.0024
1.00%,-39,-0.0039,0.9961
1.00%,-50,-0.005,0.995
1.00%,-50,-0.005,0.995
1.00%,-50,-0.005,0.995
2.00%,100,0.02,1.02
2.00%,109,0.0218,1.0218
2.00%,3,0.0006,1.0006
2.00%,24,0.0048,1.0048
2.00%,-39,-0.0078,0.9922