Cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

VBA Excel access possible?

ANSWERED

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

Best Answer
0 Votes
1 BEST ANSWER

Accepted Solutions

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.

Peter McLennan
Gondwana Software

View best answer in original post

Best Answer
1 REPLY 1

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.

Peter McLennan
Gondwana Software
Best Answer