level profit column in excel

[spliffcity]

Afternoon all,

This is probably aimed at Gary, but maybe anyone that's better at maths than me.

how hard would it be to put the level profit column into excel?

the idea being that, once the profit hits a certain trigger, i can fire in the bets required using triggers auto magically?

Massive job?

cheers
Mark.

[osknows]

Gary developed this recently, perhaps it may help you?

http://gruss-software.co.uk/forum/viewtopic.php?t=4659

[spliffcity]

cheers for the reply.

I've used these already ajnd modified them to some extent.. but they are not really what I'm looking for.

I could probably code the stuff myself in vba i think, BUT..

I don't know where to start with the whole green up calcluation across multiple bets and the required stake on each bet.

so in effect I need the level profity column and the ability to fire the c"close positions" button in excel!

i've a feeling i might be asking for too much though?

[2020vision]

Hiya

may I re-enquire about the post below please Gary, been quite a while - relevant I think?
http://www.gruss-software.co.uk/forum/viewtopic.php?t=3360&highlight=close+positions

Ttfn - all the best - Michael

[Tarmac]

I would like to see the level profit workable through Excel for global and individual selections. I tried the link provided to Gary's workings in the earlier post but the level profit column just shows the same numbers as the profit column.

NG

[GaryRussell]

I would like to see the level profit workable through Excel for global and individual selections. I tried the link provided to Gary's workings in the earlier post but the level profit column just shows the same numbers as the profit column.

NG

I don't think you ticked "Log current bets" when you set up the Excel link. It needs to log your bets to the MyBets worksheet to do the calculations otherwise you will end up with the same values in the level profit column as the profit column.

[xraymitch]

Gary developed this recently, perhaps it may help you?

http://gruss-software.co.uk/forum/viewtopic.php?t=4659

[xraymitch]

Hiya

may I re-enquire about the post below please Gary, been quite a while - relevant I think?
http://www.gruss-software.co.uk/forum/viewtopic.php?t=3360&highlight=close+positions

Ttfn - all the best - Michael

[2020vision]

From what I can see no internal links are working?

Clicking any brings up "No input file specified" for me?

Bet Gary will sort it soon enough, Michael

[GaryRussell]

From what I can see no internal links are working?

Clicking any brings up "No input file specified" for me?

Bet Gary will sort it soon enough, Michael

It's because the links were referring to /phpBB2/ folder. I have updated all posts (604 in total!) to refer to /forum/ instead. Open the post again and the link should be pointing to /forum/ and should work.

[2020vision]

Cheers Gary

sorted quickly as predicted. Just have to amend any shortcuts I have from
"phpBB2" to "forum" now - makes sense, probably a good idea to change it?

Ttfn - Michael

[xraymitch]

Cheers Gary

sorted quickly as predicted. Just have to amend any shortcuts I have from
"phpBB2" to "forum" now - makes sense, probably a good idea to change it?

Ttfn - Michael

Many thanks Gary and Michael - was worried that perhaps we were losing the archive in the forum upgrade.

Cheers,

Ray

[Tony5578]

Hi,

I am hoping you can clear something up for me. I have been using excel to place bets and then using the auto level profit function manaully and I now want to try to use the speadsheet in this topic but I'm not sure how it works. What trigger should I use to enable the auto level profit in excel? i've had a go but at the moment I'm getting figures flashing in the offset bet columns.

Sorry if I've missed something obvious.

Tony