rippedit123
New Member
- Joined
- Apr 18, 2015
- Messages
- 33
Hi everyone,
I've started off a little project since Friday to create a spread-bet spreadsheet and mostly it seems to be almost there, but there are a few major formulas that I can't get my head around and would much appreciate it if someone could please help me with this.
Here is what the spreadsheet currently looks like (Ignore the colours which have been set using conditional formatting:-
As you can see from above, there is a problem with:-
1. Cells under I. If the market has gone in my favour i.e. I chose SELL and market goes SELL and VICE versa, then that should be a WIN. But my profit for Asset Germ 30 is showing as a loss of -£20.20 in cell I6....this should show as £20.20 automatically. Also as you can see, cell E3 shows -130 points, and because the market went opposite direction, this is showing correctly as a loss in cell J, however cell I2 is showing blank, when it should be showing a loss of £13.
2. Cells under J. Currently it shows a loss even if I've got a break-even. FYI, I want to show the following text dependant on choices between cells under G, H & E: "WIN", "LOSS","BREAK-EVEN" or "N/A". So for example:-
a)If cell G & H have equal text then this is a "WIN",
b)otherwise it's a "sell"...
c)If cells G & H are blank then it should say "N/A"
d)However, if Cell E (Pips Moved) is Zero, then show "Break-Even".
I hope I have explained myself as best as possible, but to help you further, please find the formulas I used (Apologies as they may/may not be correct):-
Thank you again, please let me know if you need further info.
I've started off a little project since Friday to create a spread-bet spreadsheet and mostly it seems to be almost there, but there are a few major formulas that I can't get my head around and would much appreciate it if someone could please help me with this.
Here is what the spreadsheet currently looks like (Ignore the colours which have been set using conditional formatting:-
As you can see from above, there is a problem with:-
1. Cells under I. If the market has gone in my favour i.e. I chose SELL and market goes SELL and VICE versa, then that should be a WIN. But my profit for Asset Germ 30 is showing as a loss of -£20.20 in cell I6....this should show as £20.20 automatically. Also as you can see, cell E3 shows -130 points, and because the market went opposite direction, this is showing correctly as a loss in cell J, however cell I2 is showing blank, when it should be showing a loss of £13.
2. Cells under J. Currently it shows a loss even if I've got a break-even. FYI, I want to show the following text dependant on choices between cells under G, H & E: "WIN", "LOSS","BREAK-EVEN" or "N/A". So for example:-
a)If cell G & H have equal text then this is a "WIN",
b)otherwise it's a "sell"...
c)If cells G & H are blank then it should say "N/A"
d)However, if Cell E (Pips Moved) is Zero, then show "Break-Even".
I hope I have explained myself as best as possible, but to help you further, please find the formulas I used (Apologies as they may/may not be correct):-
Thank you again, please let me know if you need further info.
