Optuma Forums › Optuma Scripting › Net Advancing Volume Percent
- This topic has 3 replies, 3 voices, and was last updated 2 months ago by
Darren.
-
AuthorPosts
-
January 28, 2021 at 1:13 am #62141
deepak
- Topics: 41
- Replies: 27
- Posts: 68
Hii Sirs,
I wanted to build a breadth measure of Net Advancing Volume percent.(Advancing Volume- Declining volume)/Total Volume;
How to calculate total volume.
Whereas
Advancing Volume is12345u1=volume();u2=CHANGE(u1) >0;u2Declining Volume is
12345u1=volume();u2=CHANGE(u1) <0;u2Regards
DeepakJanuary 28, 2021 at 3:20 pm #62153Rowan
- Topics: 0
- Replies: 1
- Posts: 1
Hi,
I’m also building this breadth, however I’m unsure if my total Advance/Decline Volume script is correct.
My scripting is different however achieves the same (forgive me I’m still relatively new to scripting):Advancing Volume:
u1 = VOL();
u2 = VOL(OFFSET=-1);
u3 = u2 – u1;
u3 > 0Declining Volume:
u1 = VOL();
u2 = VOL(OFFSET=-1);
u3 = u2 – u1;
u3 < 0Advance/Decline Volume:
u1 = VOL();
u2 = VOL(OFFSET=-1);
u3 = u2 – u1;
u4 = u3 > 0;
u5 = u3 < 0;
u6 = (u4 – u5) / u1;
u6January 30, 2021 at 1:01 am #62177deepak
- Topics: 41
- Replies: 27
- Posts: 68
Can anyone guide us on this?
January 31, 2021 at 12:11 am #62181Darren
- Topics: 66
- Replies: 576
- Posts: 642
We have the following data (including advance/decline volume ratio) in our Breadth Measures data if you have it enabled on your account:
https://help.optuma.com/kb/faq.php?id=1062
So Advance/Decline Volume Percent for the ASX200 has the symbol ADVPASX200:
We’ll be adding this data for the Indian NSE exchange in the next few months, but it’s a bit tricky to calculate manually. What you would need to do is calculate two breadth measures: one summing the advancing volume and one declining volume.
123456789C1=CLOSE();P1=VOL();//Calculate Advance/Decline volume;ADV1 = IF(C1 IsUp, P1,0);DEC1 = IF(C1 IsDown, P1,0);//Output ADV1 for Advances or DEC1 for DeclinesADV1Once ADV1 and DEC1 have been calculated in Market Breadth, use the Data > Custom Codes to calculate the ratio, which would be:
12345A1=GETDATA(CODE=ADV1:Market Breadth);D1=GETDATA(CODE=DEC1:Market Breadth);(A1-D1)/(A1+D1)2 users thanked author for this post.
-
AuthorPosts
- You must be logged in to reply to this topic.