Cymatic Trader Community

[nig299]

Just remember to press the button before you switch to the next market. Your p/l for each race is saved and shown on the p/l sheet. The results can be left there as long as you want (days or weeks), and each time you want a fresh lot, just delete any already there.

Note: Can't save the results automatically as the sum formula in BJ1 returns to zero as soon as the market is switched.

[Gavin]

Sounds like great work again Nigel.

Just a thought, to record profits from the previous market, after the market changes, how about doing this:

In the Worksheet_Calculate event, copy the results of the formulae to separate cells as values only (don't copy the formula too). This temporarily stores the values ready for logging when the markets change. Also store the market name (from cell A1, copy it to a temporary cell).

Could also put some code to see if the market name has changed then copy the temporary stored P&L values to the permanent log cell location.

Then it wouldn't be necessary to hit the log button before changing markets.

Untested, but it should work, if anyone wants to try coding that.

Kind regards,
Gavin

[dannozza]

thanksGavin, but I have no idea of programming and how to adapt it. I will have to think of some strategy.

thanks heaps

dan

[Gavin]

Hi Dan,

If you fancy getting a programmer to do it for you, then you could consider asking for quotes here:

Find A Developer

Kind regards,

Gavin

[turtle]

Just remember to press the button before you switch to the next market. Your p/l for each race is saved and shown on the p/l sheet. The results can be left there as long as you want (days or weeks), and each time you want a fresh lot, just delete any already there.

Note: Can't save the results automatically as the sum formula in BJ1 returns to zero as soon as the market is switched.

ridiculous should br able to see in demo mode like most other programmes.