Weight of Money (WOM)

A place to discuss anything.
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

foxwood wrote:
Wed Oct 31, 2018 9:49 am
Well that got you scribbling early in the morning :D

Yes, understand all that - just prefer the unbounded myself.

Most people don't seem to reckon it as a metric anyway - never found it much use myself - maybe everyone should use the Jim Ratio (patent pending) instead :lol:
yeah - can't beat a good scribble after a muesli dribble!! :D

might just put a patent on that - good thinking. I actually agree that unless you have the full market depth, you're only really seeing the pointy bit of the action and not underlaying momentum/strength. that said, if taking a short term view on money flow, it might (for automation) be a useful tool when used in combo with other guiding factors.

btw -OT, the .net integration with BA->Excel going astonishingly well, just wish i'd embarked on it before knocking up 1000's of lines of vba code!!
User avatar
mcgoo
Posts: 898
Joined: Thu Jul 18, 2013 12:30 pm

I've found it indicative despite cross matching if you vary the % as jimibt seems to imply..admittedly I am 5 Halloween beers in :D :ugeek:
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

mcgoo wrote:
Wed Oct 31, 2018 10:00 am
I've found it indicative despite cross matching if you vary the % as jimibt seems to imply..admittedly I am 5 Halloween beers in :D :ugeek:
screw the WOM, pop another VB!! happy halloween (is that even a thing??) :D
User avatar
mcgoo
Posts: 898
Joined: Thu Jul 18, 2013 12:30 pm

jimibt wrote:
Wed Oct 31, 2018 10:02 am
mcgoo wrote:
Wed Oct 31, 2018 10:00 am
I've found it indicative despite cross matching if you vary the % as jimibt seems to imply..admittedly I am 5 Halloween beers in :D :ugeek:
screw the WOM, pop another VB!! happy halloween (is that even a thing??) :D
I have given up resisting.. a South African in Brisvegas with hundreds of kids over-running the suburbs one has to jut accept.But cheers :lol: :D :D :D
User avatar
jimibt
Posts: 3641
Joined: Mon Nov 30, 2015 6:42 pm
Location: Narnia

Halloween present -a little vba function for use in Excel automation to calculate varying WOM values:

Code: Select all

Public Function CalculateWOM(back1 As Single, back2 As Single, back3 As Single, _
                                lay1 As Single, lay2 As Single, lay3 As Single, _
                                Optional primaryWeightFactor As Single) As Single
                                
Dim totalPrices As Single, backPriceTotal As Single, layPriceTotal As Single
Dim weightFactor_1 As Single, weightFactor_2 As Single, weightFactor_3 As Single

    Const ARBITARY_FACTOR_DIVVY = 0.675

    If Not IsMissing(primaryWeightFactor) Then
        weightFactor_1 = primaryWeightFactor
        weightFactor_2 = (1 - primaryWeightFactor) * ARBITARY_FACTOR_DIVVY ' arbitary %AGE of remaining weight
        weightFactor_3 = 1 - (weightFactor_1 + weightFactor_2)
    Else
        ' defaults as per BA
        weightFactor_1 = 0.34
        weightFactor_2 = 0.33
        weightFactor_3 = 0.33
    End If
    
    ' exit if blank cells or no value on main back/lay
    If back1 = 0 Or lay1 = 0 Then
        CalculateWOM = 0
    End If
    
    ' get our 3 main moving values
    backPriceTotal = (back1 * weightFactor_1) + (back2 * weightFactor_2) + (back3 * weightFactor_3)
    layPriceTotal = (lay1 * weightFactor_1) + (lay2 * weightFactor_2) + (lay3 * weightFactor_3)
    totalPrices = backPriceTotal + layPriceTotal
    
    ' avoid divide by 0 error
    If (totalPrices = 0) Then
        CalculateWOM = 0
    Else
        CalculateWOM = backPriceTotal / totalPrices
    End If
                    
End Function
usage on sheet (put into one of the columns after AH) - this is referencing first row of runners in cell AI10. repeat as required:

Code: Select all

=CalculateWOM(G10,F10,E10,H10,I10,J10,$I$4)
note, $I$4 is a variable on the sheet, but could also simply be hardcoded as: 0.6 or whatever [=CalculateWOM(G10,F10,E10,H10,I10,J10,0.6)]

it could also simply be ignored, which would action the BA style defaults: [=CalculateWOM(G10,F10,E10,H10,I10,J10)]

enjoy...
User avatar
BetScalper
Posts: 1139
Joined: Sun Jul 02, 2017 10:47 pm

Hi,

A little update.

After allot of testing i went with the following:

Opening Trades

Minimum back_volume > 1000 AND Minimum lay_volume > 1000

BTL = IF lay_volume > back_volume * 2 AND ((back_amount1 * 0.6) + (back_amount2 * 0.3) + (back_amount3 * 0.1)) / ((back_amount1 * 0.6) + (back_amount2 * 0.3) + (back_amount3 * 0.1) + (lay_amount1 * 0.6) + (lay_amount2 * 0.3) + (lay_amount3 * 0.1)) < 0.33

LTB = IF back_volume > lay_volume * 2 AND ((back_amount1 * 0.6) + (back_amount2 * 0.3) + (back_amount3 * 0.1)) / ((back_amount1 * 0.6) + (back_amount2 * 0.3) + (back_amount3 * 0.1) + (lay_amount1 * 0.6) + (lay_amount2 * 0.3) + (lay_amount3 * 0.1)) > 0.66

Enjoy,
User avatar
mcgoo
Posts: 898
Joined: Thu Jul 18, 2013 12:30 pm

BetScalper wrote:
Wed Feb 13, 2019 11:45 pm
Hi,

A little update.

After allot of testing i went with the following:

Opening Trades

Minimum back_volume > 1000 AND Minimum lay_volume > 1000

BTL = IF lay_volume > back_volume * 2 AND ((back_amount1 * 0.6) + (back_amount2 * 0.3) + (back_amount3 * 0.1)) / ((back_amount1 * 0.6) + (back_amount2 * 0.3) + (back_amount3 * 0.1) + (lay_amount1 * 0.6) + (lay_amount2 * 0.3) + (lay_amount3 * 0.1)) < 0.33

LTB = IF back_volume > lay_volume * 2 AND ((back_amount1 * 0.6) + (back_amount2 * 0.3) + (back_amount3 * 0.1)) / ((back_amount1 * 0.6) + (back_amount2 * 0.3) + (back_amount3 * 0.1) + (lay_amount1 * 0.6) + (lay_amount2 * 0.3) + (lay_amount3 * 0.1)) > 0.66

Enjoy,
Cheers :) Interesting
Post Reply

Return to “General discussion”