In Eikon samples there was a file called RHistoryAPI.xlsm to retreive historical data, like prices time series.
We have not been able to get it working with Workspace Excel.
Hi.
I was finally able to find the page with the necessary reference files and examples
https://developers.lseg.com/en/api-catalog/workspace-sdk/lseg-com-library-for-workspace