Reply To: Combine GETDATA() and RRG script

Optuma Forums Optuma Scripting Combine GETDATA() and RRG script Reply To: Combine GETDATA() and RRG script

  • Topics: 5
  • Replies: 616
  • Posts: 621


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):

We do have workbooks for the US S&P 500 and Australian sectors you can access from here to get started:

1 user thanked author for this post.

Pin It on Pinterest