Very basic skills in VBA. Looking for something very simple:
Cell A1 is a stock symbol or option symbol
Cell A2 is bid
Cell A3 is ask
Cell A4 is last trade
Any help?
2
●1 ●1 ●2
Quote for stock and options
Hi @andybell ,
Thank you for your participation in the forum. Is the reply below satisfactory in resolving your query?
If so please can you click the 'Accept' text next to the appropriate reply? This will guide all community members who have a similar question.
Thanks,
AHS
22k
●58 ●14 ●21
We don't have much experience with REDI. The API page shows that REDI can be used with Excel and there is a Quickstart and couple of VB/Excel tutorials as well. If there is a specific API question, I would recommend that you reach out to the REDI product team at my.refinitiv.com.
Also see this question which shows how to use DDE with Excel to get real time quotes.
22k
●58 ●14 ●21
Hi @andybell,
Are you an existing Refinitiv customer - if yes, which products do you use. It is possible to get the real time data for an item in Excel without using any VBA, using the Eikon plugin for Excel.
