External field on external symbol

Optuma Scripting
1

I’m trying to do a Signal Test for S&P 500 returns following jobless claims being higher than the median survey estimate.

I can get both the external symbol (claims) and data field (survey median) from Bloomberg just fine. I can do the test against jobless claims and get the dates.

However, I’d like to test this against the S&P 500, and can’t figure out a way to force the data field to refer to jobless claims, not the S&P.

I’ve tried everything I can think of and searched through the KB, forum, and other help topics with no effect, so hopefully, I’m not missing something obvious. Any help is appreciated.

v1 = GETDATA(CODE=INJCJC INDEX:BLMB);
v2 = DATAFIELD(FIELD=BN_SURVEY_MEDIAN);
v1>v2

 

2

Hi Jason,

You need to nest V1 in V2, so it knows to get the survey data for INJCJC:

v1 = GETDATA(CODE=INJCJC INDEX:BLMB);
v2 = DATAFIELD(v1, FIELD=BN_SURVEY_MEDIAN);
v1>v2

The green Show Bar arrows on the SPX chart uses the above to highlight when the claims > median survey (save and open the workbook attached to open on your system).

Capture
Capture1878×947 63.4 KB

Jobless-Claims.owb (16.6 KB)

3

Weird, I tried that and I was getting an error box in the bottom left-hand corner. Now that I try it again, it works perfectly. Must be user error. Thanks as always!