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
Best Answer
-
@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
0
Answers
-
-
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?
0 -
Hi @DDALY ,
There are expired options in that screenshot. If you enter valid options, do you still see the issue?
-Brian
0 -
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
0 -
@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()?
0 -
@DDALY yes...there are actually a few entitlements for the REDI API...your account rep can ensure you're set up
0 -
@brian.mullane, permissions have been set up and GetOptionL1Value() is now working. Thank You!
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛