Login Page - Create Account

Support Board


Date/Time: Thu, 07 Jul 2022 17:29:24 +0000



[User Discussion] - Volume by Price in spraedsheet

View Count: 1284

[2014-01-26 13:37:48]
User025429 - Posts: 26
Two spreadsheet questions
1.  Is there a more efficient way to create a spreadsheet table, of volume by price, of trades taken after a specified time other than to use sumproduct and < than the specified time?
2.  When using volume charts, I want to record the volume by price for each bar in a spreadsheet row.
Thank you in advance

[2014-01-26 21:30:15]
vegasfoster - Posts: 444
1. I don't understand what you are asking for, but in general you can use the sumif function if you only have one parameter, e.g. =sumif(a1:a300, "<"&X, b1:b300). If you have two parameters then you could try to use an array formula, e.g. {=sum(if(a1:a300<X, if(b1:b300<Y, b1:b300)))}. Where X and Y are values or cell references containing the values you want to evaluate against. I don't use array formulas very often, so I am not sure how much more efficient this would be, you will need to test it.

Link to brief explanation of array formulas.
http://spreadsheets.about.com/od/2010statisticalfunctions/qt/2010-04-26-excel-2010-min-function.htm

2. As far as I know, currently you can't do this because the information is not output by the study and SC does not make the source code available for this study. Your options are to ask for the source code or recode the study yourself.
Date Time Of Last Edit: 2014-01-26 21:34:57

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account