In running weighted average price

[rik]

I need to find out weighted average price for in running horse racing market, how would i go about that? Are there any tools available or anyone could sell that are able to show that? thank you

[napshnap]

We need to:
- calculate sum_of_each_order_price_X_sum_of_each_order_size
- calculate sum_of_each_order_size
- WAP = sum_of_each_order_price_X_sum_of_each_order_size /
sum_of_each_order_size

Here's example, we're сalculating WAP of lay orders:

[rik]

can you do that?

[napshnap]

can you do that?

Sorry, I can't, but don't get upset - as you can see this is ridiculously simple calculations.

[rik]

I dont understand excel, your file you can just load all prices into it through betangel?

[napshnap]

I dont understand excel, your file you can just load all prices into it through betangel?

I'm afraid it can't, cause it's just a simple file without any macros and programing I've created today to show how to calculate WAP.
It's not my business, but if you're interested in deeper and more specific way to understand market you should learn how to use Excel. This is a wonderful tool for such purposes.

[jimibt]

I dont understand excel, your file you can just load all prices into it through betangel?

I'm afraid it can't, cause it's just a simple file without any macros and programing I've created todady to show how to calculate WAP.
It's not my business, but if you're interested in deeper and more specific way to understand market you should learn how to use Excel. This is a wonderful tool for such purposes.

i agree with you here. learning excel in the context of BA would open so many doors to ideas that aren't feasible using BA automation alone. in terms of the OP's question, he could create a class object (using a dictionary objects collection) which could record the VWAP every second for every runner in a given race. All the internals would be reuasable and black boxed, therefore would be very CLEAN to re-use against different scenarios (i.e. could be dropped into different strategies). fwiw - i do an almost identical thing using .net to good effect.

so yes, learn excel and you'll open up multiple new doors.

[Dallas]

Why not just use Bet Angels Advanced automation and run a 'Checkpoint VWAP' rule at the off?
Then store the VWAP in-running with a stored value rule triggering every second?

If your using the latest version of Bet Angel that value could then be passed to Excel if you wanted to run the rest of your automation from there

[napshnap]

Why not just use Bet Angels Advanced automation and run a 'Checkpoint VWAP' rule at the off?
Then store the VWAP in-running with a stored value rule triggering every second?

If your using the latest version of Bet Angel that value could then be passed to Excel if you wanted to run the rest of your automation from there

I'n sorry, what's stand for V in this "VWAP" abbreviation? Virtual?

[Dallas]

Why not just use Bet Angels Advanced automation and run a 'Checkpoint VWAP' rule at the off?
Then store the VWAP in-running with a stored value rule triggering every second?

If your using the latest version of Bet Angel that value could then be passed to Excel if you wanted to run the rest of your automation from there

I'n sorry, what's stand for V in this "VWAP" abbreviation? Virtual?

Volume

[ayermt]

Why not just use Bet Angels Advanced automation and run a 'Checkpoint VWAP' rule at the off?
Then store the VWAP in-running with a stored value rule triggering every second?

If your using the latest version of Bet Angel that value could then be passed to Excel if you wanted to run the rest of your automation from there

Hey Dallas, I can only see how to store the value of 'VWAP per selection', not for the market. I'm looking to record the average price of the market at any given time in play. I've seen you refer to it as 'price of net runner' before. Any ideas?
Thanks

[ShaunWhite]

I'm afraid it can't, cause it's just a simple file without any macros and programing

Macros and programming won't help you becuase BA doesn't expose the entire ladder to Excel.

Just do what Dallas suggests, BA can reset the VWAP start time and calculate it when needed as standard.

[napshnap]

I'm afraid it can't, cause it's just a simple file without any macros and programing

Macros and programming won't help you becuase BA doesn't expose the entire ladder to Excel.

Just do what Dallas suggests, BA can reset the VWAP start time and calculate it when needed as standard.

Thanks Shaun, but that was for TS, I'm personally prefer traditional programing for automation tasks.