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:
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.