I would like to retrieve real-time stocks and options to excel, may you advise the procedure ? Thanks.
Please follow REDI API Quickstart to enable access.
Next, please download REDI API Excel Examples.
Then, the relevant examples to review and run are "Quote Monitor - DDE Equities" and "Quote Monitor -DDE - US Options".
Please note for completeness: to be able to access market data, REDI user needs to be permissioned to access market data.