How to call Factset using Matlab through an Excel spreadsheet.

2 vues (au cours des 30 derniers jours)
Ajpaezm
Ajpaezm le 7 Fév 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.

Réponses (0)

Catégories

En savoir plus sur Use COM Objects in MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by