External field on external symbol

Optuma Forums Optuma Scripting External field on external symbol

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • #60843
    Jason
    • Topics: 2
    • Replies: 1
    • Posts: 3

    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.

     

    #60849
    Darren
    • Topics: 66
    • Replies: 633
    • Posts: 699

    Hi Jason,

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

    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

    #60855
    Jason
    • Topics: 2
    • Replies: 1
    • Posts: 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!

Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.

Pin It on Pinterest