search

krijnsent / crypto_vba

An Excel/VBA project to communicate with various cryptocurrency exchanges APIs
MIT License
157 stars 54 forks source link

Definition of some functions #76

Closed fariborz1221 closed 3 years ago

fariborz1221 commented 3 years ago

I would appreciate if you could let me know where I can find the following functions definition: WebRequestURL(... DictToString(...

krijnsent commented 3 years ago

Hi there,

I hope you already checked out the code? WebRequestURL is in ModWeb , there are quite some examples in the test procedure at the top of the module. What it basically does is throw a request to a web server. That could be a GET, POST, etc request (strMethod parameter) and the function allows you to e.g. add headers to the web request. It will always return JSON.

DictToString is in ModFunctions, the test cases at the top of the module show how it can be used. What it basically does: translate a dictionary object into a string. That's practical to e.g. get the JSON or URL required for a web request.

Hope that helps, Koen

fariborz1221 commented 3 years ago

Hi,

Thank you very much for taking the time to answer my question. Somehow I had perceived that your codes are using Python to make requests. I wanted to get the cryptocurrency ticker prices from Binance. I will learn a lot from your way of coding.

Regards,

Fariborz Rafati

On Wed, May 26, 2021 at 1:59 AM Koen Rijnsent @.***> wrote:

Hi there,

I hope you already checked out the code? WebRequestURL is in ModWeb , there are quite some examples in the test procedure at the top of the module. What it basically does is throw a request to a web server. That could be a GET, POST, etc request (strMethod parameter) and the function allows you to e.g. add headers to the web request. It will always return JSON.

DictToString is in ModFunctions, the test cases at the top of the module show how it can be used. What it basically does: translate a dictionary object into a string. That's practical to e.g. get the JSON or URL required for a web request.

Hope that helps, Koen

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/krijnsent/crypto_vba/issues/76#issuecomment-848597735, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUG7RMA5M45W5SYTA5QA7GLTPSZ5PANCNFSM45PZPJQQ .

krijnsent commented 3 years ago

Nope, all this code is pure VBA :-)

fariborz1221 commented 3 years ago

Thank you very much

On Thu, May 27, 2021 at 4:53 AM Koen Rijnsent @.***> wrote:

Closed #76 https://github.com/krijnsent/crypto_vba/issues/76.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/krijnsent/crypto_vba/issues/76#event-4805274654, or unsubscribe https://github.com/notifications/unsubscribe-auth/AUG7RMD5PNSXENOAQROHPJLTPYXC3ANCNFSM45PZPJQQ .