API Not Working

I have attached a workbook that I need to make the API from the website that is listed in the workbook function properly. I have some VBA but need to make it work properly, then after collecting the data, I want need help programming to be able to do some analysis on the data after it is collected. Any help would greatly be appreciated.

You have missed the function call to JSON parser: Set Parsed = JsonConverter.parseJSON(Upload)
You need to include this function in your code.
The link has got all the functions you need.

https://www.excelforum.com/excel-pro...using-api.html

I did not write that code so I do not know how to do what you are saying. Also, i need to get those buttons working, then figure out how to generate a line chart after data is imported from the API... Any help would be greatly appreciated.

Well, I do not know and do not have your API. You need to register with the owner of the site and get an API as the site requires one. Since exposing an API key to a public is not good idea, I suggest you should follow the above link. The OP on that thread did not know anything about API, but managed the code to get to work.

https://coinmarketcap.com/api/ is where their API is listed. They are public API's. I just don't know how or where to insert them into the VBA...

Since I have started it, I managed to get the figures you are want, but big IF, this is just a sample from the first link-https://api.coinmarketcap.com/v1/ticker/. The link has many lines of the same data, but the code just picks up from the first line ONLY.
You need to do a couple of things before you run the code.
You need to go to VBE editor, Tools and tick the following libraries:
Microsoft Scripting Runtime Library.
XML v6.0
Microsoft WINHTTP Services Library.
I have added the JSON parser from the above link in to your module.
I know this might be complicated for you since you are new to VBA, but unfortunately, VBA does not have a native JSON parser, we need to use a third-part code plus some VBA's libraries. You might need to adjust the code for the other links as well.
That is all I could do for you.

I appreciate your help to this point. is there a way to apply the VBA to the "download" Button on the worksheet?

The code is now attached to the "Download" button. Just click it and see the output.

Wow!! that is awesome!!! thats what i'm talking about.... Lol So in the cell where I typed "xlm/eth", that is like a search for a specific ticker Symbol.. then the radial button next to it would prompt for the search for whatever symbol gets typed into the search box..... Is that possible too??

Hmm! I am wondering where this thread is going to end
Just change the symbol in C9 and press the same button and see the result. I have not touched the other button.

That doesn't seem to work on my end.... Typed a different symbol in and pressed the download button and nothing happens...??

Ahhh, just discovered.... It appears to be case sensitive....When I went all CAPS, it worked...I wonder when this thread is going to end.....Lol. In summary, what I am ultimately trying to accomplish is import data into this workbook, then anylise the results via possible line chart, but more importantly, I want to be able to look at the history of a given symbol and find out what it's mean is, then be able to see how often and how much above and below the mean takes place and how much time goes by till large spikes or large drops take place.... I think if I could get the historic data imported, then I could somehow extract that type of data.... but you don't have to keep messing with it if you don't feel like it... Maybe somebody will come along that would get a kick out of it.... I sure appreciate your help and mad skills with VBA.. Awesome work!! I would love to see what you can do with what I just explained but will understand if you decline...Still much appreciate what you have done so far though, Thanks again!!!

I would not promise anything due to time constraints. I need more information and clarification.
You can use this amended line to enter the symbol in to a small cases.

If Parsed(i)("symbol") = UCase(Trim(.Range("C9"))) Then

HTML Code: 

. I want to find the middle, or average of the Highest to the Lowest price over a user selected time period or all time as shown in the attached link to the same website. I want to be able to import to Excel and analyze the data.

Sorry! I simply do not know how to get data from a chart. I suggest you start a new thread and hopefully, somebody will butt in.

Ok, will do.... Thank you So much for your help, Great job!!!