VBA code leads to #value! in cell but works in immediate box

[bpage]

I have written a getprice function for retrieving stock tickers from yahoo and bitcoin prices from an online api. However the code for bitcoin results in an #value! in my excel cell. But it performs fine when I run the function from the immediate box in VB. I sense it's some sort of compatibility problem but I've exhausted my troubleshooting knowledge. Any help or pointers would be appreciated!

here is the file
https://drive.google.com/file/d/0B-CQNUWfWnMzQTA5MW9Vb3NiLXc/view?usp=sharing

 

[John_w]

Please post links to your cross-post(s).

 

[bpage]

Here they are:
VBA code leads to #value! in cell but works in immediate box

arrays - VBA code leads to #value! in cell but works in immediate box - Stack Overflow