05-12-2017 06:01
05-12-2017 06:01
Hello all,
Iam creating an excel tool with vba coding where I can analyse my data. Is it also possible/allowed to use the API via VBA that I can export the data into my Excel project?
Thanks in advance!
Matthias
Answered! Go to the Best Answer.
05-12-2017 14:15
05-12-2017 14:15
I don't think VBA is sophisticated enough to do the OAUTH2 authentication needed to access the data directly. You may have to use other tools to get the data, which you can then open/import in Excel. For example, some intra-day data is obtainable from here.
05-12-2017 14:15
05-12-2017 14:15
I don't think VBA is sophisticated enough to do the OAUTH2 authentication needed to access the data directly. You may have to use other tools to get the data, which you can then open/import in Excel. For example, some intra-day data is obtainable from here.