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
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.
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?
@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()?