Quote for stock and options

andybell

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?

Gurpreet

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.

Gurpreet

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.

andybell

https://community.developers.refinitiv.com/discussion/comment/105189#Comment_105189

Using RediPlus. I have some coding for sending trades through using RediAddin.

andybell

https://community.developers.refinitiv.com/discussion/comment/105219#Comment_105219

Thanks for the help!