Combine GETDATA() and RRG script

[Bui]

Hi there,

I would like to know when the sector of stocks in my watchlist is heading north west, then I will concentrate more on those stocks but I do not know how to script getdata(the sector) with rrg.heading from 0 to 60 degree.

Please help me with that

[Matthew]

Hi,

That type of automatic mapping for sectors and sector constituents for the RRG requires a connection to Bloomberg terminal.

If you do not have Bloomberg data, you can achieve a similar result but there are additional steps.

First you need to setup your Watchlist / RRG script for all the Sector codes, to find the headings (no GETDATA() required).

Once you have found the sector(s) of interest you can open an RRG chart for the constituents of that sector.  To do this you will need your own symbol lists for the different sectors (as a CSV file or manual list): https://help.optuma.com/kb/faq.php?id=1197

We do have workbooks for the US S&P 500 and Australian sectors you can access from here to get started: https://www.optuma.com/sector-workbooks/

1 user thanked author for this post.

Bui

[Bui]

Thank you for your reply. I indeed have a workbook which has pages for stocks on each sectors and I use it to do top down analysis.

But I have a special list of stocks that I am really care about in different sectors and it took lots of time to know which heading of those stocks ‘s sector are at the same time. So I try to script it but get stuck at GETDATA(sector) and JDKRS(index).heading (both stocks and sector using same index as benchmark)

 

• This reply was modified 7 months ago by Bui.

[Author]

Posts