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 ?

Hi,

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

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

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

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 ?

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.

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

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.