GetOptionL1Value() failing

Hi all, I'm having trouble getting L1 data for options. Please see code below. GetL1Value() returns true (and the correct price) but GetOptionL1Value() returns false (and no price). I have access to the options data in the UI so I can see the bid/ask in the Option Series window. Is it a permissions thing - maybe a separate permission setting for options L1 data via API? Thanks.

    Dim L1Cache As New RediLib.CacheControl
    Dim vTable, vwhere, verr, tmpVal, askPx As Variant
    vTable = "L1"
    vwhere = "true"
    tmpVal = L1Cache.Submit(vTable, vwhere, verr)
    ' equity
    tmpVal = L1Cache.GetL1Value("VICI US", "Ask", askPx)
    Debug.Print askPx
    ' option
    tmpVal = L1Cache.GetOptionL1Value("VICI M2023D350000", "PUT_AskPrice", askPx)
    Debug.Print askPx

Find more posts tagged with

redi-api

Accepted answers

brian.mullane

@DDALY ,

Got it...here's what I'd suggest:

1) Try reinstalling the REDI Excel add in (you can do this via the REDIStart launcher app...Tools menu)

2) Always uncheck any VB references that say "missing".

3) Check with your account representative to ensure you're entitled for REDI API DDE links.

-Brian

All comments

brian.mullane

Hi @DDALY ,

To verify permissions, please run this Excel example to see if you can options market data from the REDI API.

Assuming you're correctly entitled, please try "L1OPT" instead of "L1".

-Brian

DDALY

Hi @brian.mullane, Thanks for getting back. That file doesn't work. Looks like it can't find the addin/exe it needs. Installation issue?

brian.mullane

Hi @DDALY ,

There are expired options in that screenshot. If you enter valid options, do you still see the issue?

-Brian

DDALY

Hi Brian, I tried this one and getting Not Found.

Side Issue: I had to manually relink the REDIAddIn.xla to point to my AppData folder. I assume that's not how it's supposed to work, every user has to relink to their own folder?

Thanks! Dermot

brian.mullane

@DDALY ,

Got it...here's what I'd suggest:

1) Try reinstalling the REDI Excel add in (you can do this via the REDIStart launcher app...Tools menu)

2) Always uncheck any VB references that say "missing".

3) Check with your account representative to ensure you're entitled for REDI API DDE links.

-Brian

DDALY

@brian.mullane, I don't believe I have access to the REDIStart launcher app so I'll check with the account rep. on that as well. RE: point (3), is permission to the REDI API DDE links the same permission required to load the data using GetOptionL1Value()?

brian.mullane

@DDALY yes...there are actually a few entitlements for the REDI API...your account rep can ensure you're set up

DDALY

@brian.mullane, permissions have been set up and GetOptionL1Value() is now working. Thank You!

EXPLORE OUR SITES