Recalculating Staking

[philuk]

Is there a way to tell the spreadsheet to update my staking total at the end of each day.

Like for example I use the sheet that updates the races at midnight every night.

How will I go ahead to make it adjust my stake according to my bank account.

For example , if after today my bank is £120 , it must work out the stake at 0.15% of that. The next night at twelve it must then work the new stake out according to my new bank total. etc....

I presume it is a VB code , no idea.

Thanx

[mak]

if you place in j2 the letter U through vba it will update your balance in i2.you can work it from there. you can find it at the special trigger cells in the help section of ba.

[philuk]

Thanx for that , I saw that there , the only thing is that it will update my stake everytime my balance changes.

What I would like is for my stake to update at 00:00:00 , same when the markets refreshes , and then the stake must stay the same throughout the whole day untill 00:00:00 and then update it again for the next day.

[mak]

sorry, but i am not good at all in vba. i am sure that this can be done & it is easy but not for me...

[milfor]

Click in the Excel menu 'Tools' on 'Macro' and 'Visual Basic Editor' and copy the following code there:

Code: Select all

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Application.EnableEvents = False
    If Now-Int(Now)<1/1440 Then
        Worksheets(1).Cells(2,17).Value = "U"
    End If
    Application.EnableEvents = True
End Sub

This will update your balance only in the first minute after midnight.

[philuk]

Thanx for that , will try that and let you know

[philuk]

Click in the Excel menu 'Tools' on 'Macro' and 'Visual Basic Editor' and copy the following code there:

Code: Select all

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    Application.EnableEvents = False
    If Now-Int(Now)<1/1440 Then
        Worksheets(1).Cells(2,17).Value = "U"
    End If
    Application.EnableEvents = True
End Sub

This will update your balance only in the first minute after midnight.

Thanx again , just one question...

Where do I fill in the percentage of what my stake will be.
For example : 0.15% of bank ?

Thanx

[milfor]

After the update the cells I2 and L2 contain balance and exposure. Their sum is your current bank. Wherever you need the stake you could write the formula =(I2+L2)*0.0015

[philuk]

Thanx for that Milfor

Excellent , no i understand.

Cheers

Philip

[philuk]

sorry, but i am not good at all in vba. i am sure that this can be done & it is easy but not for me...

no problem Mak , me neither.

I have learnt more about VBA in this Forum , than anywhere else.

Since I have been using BA , my knowledge has broadend lots.

Not there yet , but getting there