05-12-2017 06:01
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report this post

05-12-2017 06:01
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report this post
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.

Accepted Solutions
05-12-2017 14:15
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report this post


05-12-2017 14:15
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report this post
- Who Voted for this post?
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.
Gondwana Software
05-12-2017 14:15
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report this post


05-12-2017 14:15
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report this post
- Who Voted for this post?
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.
Gondwana Software
