Create advance-decline line for ASX200
Author: Yuyu
Creation Date: 4/29/2015 2:08 AM
profile picture

Yuyu

#1
Hi all,

I am trading in ASX 200 (Australia market)

I set up the 200 shares in the database and I want to create an advance-decline line in each stock page.

and the line can show up with ALL ords and S&P ASX200 under the stock trading graph.

The formula : (# of Advancing Stocks - # of Declining Stocks) + Previous Period's

Can anyone please help ?


profile picture

Eugene

#2
Hi,

Start Index-Lab (Tools menu), choose "Advance Decline Line" and your ASX200 DataSet. More information is available in the User Guide.
profile picture

Yuyu

#3
Hi Eugene,

Thank you.

It does work.

Can you advise how can I add ALL ords or S&P ASX200 into the chart ?

Thank you


profile picture

Eugene

#4
Sure. Check out WealthScript Programming Guide > DataSeries > Accessing Secondary Symbols > How to: Access DataSeries of Secondary Symbols
profile picture

Yuyu

#5
Hi Eugene,

I did successfully create advance decline line from database. however, the graph is not a line graph.. how do code it to let it become line chart ?
profile picture

Eugene

#6
Hi,

Switch to Line chart view. And again, the answer could be found in the User Guide: Charting > Chart Styles > How to: Change chart styles.
profile picture

Yuyu

#7
Hi Eugene,

Thanks.

One more question..

I am looking at STW.AX (SPDR S&P/ASX 200 Fund)

and I create an advance decline line for ASX200 - Index code: %STW

I wrote the code as below to access dataSeries of Secondary Symbols (%STW) when I look at STW.AX

CODE:
Please log in to see this code.


However, the code may be incorrect so that the chart didnt shows advance decline line for ASX200 in STW.AX chart.

The %STW shows the same as STW.AX

Can you please let me know how to fix it ?

Thank you


profile picture

Eugene

#8
Everything is correct but you have a misunderstanding of how Index-Lab works. An index created for a single symbol will naturally be identic to that symbol. The purpose of I-L is to apply an index formula like Advance Decline Ratio to a group of symbols (as mentioned in the User Guide). Applying it to a single symbol like STW.AX does not make sense and defeats the purpose.

Previously you said: "I set up the 200 shares in the database..." Index-Lab expects that you create the index based on those 200 individual symbols in your DataSet.