Help : Level Profit Not Appear in Excel.

[ferryfh]

Hi fellow,

I'm a newbie in trading.
I need level profit column in excel to calculate my formula, as Gary said base on GreenUp.xls it's should be appear in column AB (Greened up P&L), the problem is those column always blank. Others column works fine. Is it any setting to make level-profit appears ?
Level-Profit base on individual selection is active. (tick)

I'm using Excel 2007 and always click enable macro when start open that file.


Any suggestion would be very appreciate.
Thanks


Happy Trading & cheers,
Fh

[GaryRussell]

Did you tick "Log current bets" on the form that appears after selecting "Log current prices"?

[ferryfh]

Hi Gary,

Yes, "Log Current Price" is tick.
I try all variant sample about green-up but none appears on that column.
Or make it simple, can you give me the formula for level-profit ?
So I can insert 1 column calculate by my self.

Thank for fast reply Gary.


regards,
fh

[GaryRussell]

Not sure why you you are having a problem. Did you also tick "Enable triggered betting"? It's not quite as simple as giving a formula. The green up is based on your list of bets and so is based on a varying amount of information, it is calculated using VBA code in the example spreadsheet, not a formula.

[ferryfh]

Hi Gary,

Ok, let me try in other computers, maybe i have something wrong in excel setting.
Will let you know later... hope fixed my problems.

Thank for support,

cheers

[ferryfh]

Hi Gary,

I just tried on my office PC, yes level-profit column appears now.
My question :
If I want open more then 1 market what should i do :
I try to start on cell A21 for second market but level-profit not appear, should I create 1 sheet to each market ? Is your level-profit column have limited on some row ? If yes on row number ?

Thanks for support.

Happy trading,
ferry

[GaryRussell]

The spreadsheet is provided as an example. If you want it to work with multiple markets it will need to be adapted. It will be easier to adapt if you log each market to a separate worksheet. See http://www.gruss-software.co.uk/forum/v ... php?t=4659 where I provided a multiple market example in the 5th post.