How to call Factset using Matlab through an Excel spreadsheet.

2 visualizaciones (últimos 30 días)
Ajpaezm
Ajpaezm el 7 de Feb. de 2017
Hello,
I'd like to know how to use FDS codes (Factset codes) in Matlab like I do in a Excel spreadsheet. For example, if I wanted to call the FDS formula for symbols in an excel file, I'd have to use:
=FDS("Identifier","XP_Symbol")
I'm aware Matlab has the datafeed box, but I can't use it to extract identifiers and other data I need, but I can get it in Excel.
My thinking was somehow using ActiveX or DDE to call the formulas indirectly, but I'm not sure if something like that can work out, specially speaking about ActiveX, knowing that FDS codes are also DDE codes.
If anyone has tried something similar and succeeded, please let me know.

Respuestas (0)

Categorías

Más información sobre Use COM Objects in MATLAB en Help Center y File Exchange.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by