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
    AvatarJason
    • Topics: 1
    • Replies: 1
    • Posts: 2

    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
    DarrenDarren
    • Topics: 62
    • Replies: 503
    • Posts: 565

    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

    Attachments:
    #60855
    AvatarJason
    • Topics: 1
    • Replies: 1
    • Posts: 2

    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

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close