Hi @artemiso, just wanted point out that the implementation you shared will skew more to the negative since implied matches (side='N') will count as negative.
I modified the lambda as follows (I am not good with python so hopefully I got this right):
df['signed_vol'] = df['side'].apply(lambda s: 1 if s == 'B' else (-1 if s == 'A' else 0)) * df['size']
And this is what the resulting graph looks like:
and the original was this:
The following user says Thank You to Hulk for this post:
Hi @artemiso, just wanted point out that the implementation you shared will skew more to the negative since implied matches (side='N') will count as negative.
I modified the lambda as follows (I am not good with python so hopefully I got this right):
df['signed_vol'] = df['side'].apply(lambda s: 1 if s == 'B' else (-1 if s == 'A' else 0)) * df['size']
And this is what the resulting graph looks like:
and the original was this:
Oh good catch, thank you!
The following user says Thank You to artemiso for this post:
So this isn't strictly to do with market depth, but I've discovered a major discrepancy between the two data feeds today which has me questioning which one is correct.
This is the CL open today 3rd February 2023 from approx. 8AM - 10AM central time.
Left is Motivewave running Rithmic non-aggregated data. Right is SC + Denali.
The bottom of both platforms is the cumulative delta. SC is using the cumulative delta - trades indicator.
As you can see, Motivewave/Rithmic is showing positive delta on the way up, SC/Denali is showing negative delta.
When I check the footprints on both on a random bar, the bids and asks and delta totals all add up on both.
When I compare the two feeds over the past few days, at a cursory glance, they're pretty much the same.
The fact that both are showing pretty much opposites of each other has me scratching my head.
Anyone else care to check and chime in?
SCR-20230204-1p7
If it helps, NinjaTrader is closer to matching your SC + Denali screenshot. In my attached screenshot, this is using NinjaTrader brokerage data that is included with my account and the Order Flow Cumulative Delta Indicator.
So this isn't strictly to do with market depth, but I've discovered a major discrepancy between the two data feeds today which has me questioning which one is correct.
This is the CL open today 3rd February 2023 from approx. 8AM - 10AM central time.
Left is Motivewave running Rithmic non-aggregated data. Right is SC + Denali.
The bottom of both platforms is the cumulative delta. SC is using the cumulative delta - trades indicator.
As you can see, Motivewave/Rithmic is showing positive delta on the way up, SC/Denali is showing negative delta.
When I check the footprints on both on a random bar, the bids and asks and delta totals all add up on both.
When I compare the two feeds over the past few days, at a cursory glance, they're pretty much the same.
The fact that both are showing pretty much opposites of each other has me scratching my head.
Anyone else care to check and chime in?
SCR-20230204-1p7
SierraCharts has 3 different versions of cumulative delta. Most platforms just do CumulativeDelta by volume, but you're looking at trades. Kind of odd that they're going in opposite directions though. It suggests that there's more orders getting filled one way, but the orders being filled on the other side are bigger.