Measuring sum total of money available at all prices

[jamesedwards]

Is there any quick way in Guardian to measure the sum total of money waiting at all prices for a selection, or even better, all prices below/above a certain price? I mean without having to build something that calculates the sum of all the values at every price individually?

[bdamir]

No built-in way. You’ll need to script it, loop through the ladder and sum what you want. Fast and easy if you use the API. Otherwise, you’re eyeballing.

[elofan0]

Maybe this is a start James viewtopic.php?p=344184&hilit=money+wait ... de#p344184

[Anbell]

Is there any quick way in Guardian to measure the sum total of money waiting at all prices for a selection, or even better, all prices below/above a certain price? I mean without having to build something that calculates the sum of all the values at every price individually?

Easy but a bit cumbersome - I thought that was your forte! Exporting to excel and then using SUM would probably save a few steps.

Why would you want to do this?

[jamesedwards]

Thanks all.

I can do it ok, but not without either dozens of lines, multiple refreshes, or taking it outside of Guardian. Just wondered if there was an option or clever workaround in Guardian that I'd missed.

[Euler]

We can consider expanding the ability in the next version perhaps. I'll put it as a suggestion.

[jamesedwards]

We can consider expanding the ability in the next version perhaps. I'll put it as a suggestion.

Thanks Peter. It would be fantastic to have something in this drop-down menu like "Sum of all prices below/above an entered price", or "Sum of all prices between two entered prices".

z181.jpg

[elofan0]

or maybe do like so if works

[jamesedwards]

or maybe do like so if works

Thanks, but I can already do it that way. But when you want to sum, perhaps, all money waiting at 100+ prices it quickly becomes unwieldly.

[elofan0]

No problem