LivePrice code
Posted: November 14th, 2017, 6:37 pm
I'll start a new post rather than muddy the water of the HYPTUS v11.31 Run-time error 5 thread...
Many years ago I managed to teach myself VBA and successfully cribbed anc1's Liveprice code to download the prices of my portfolio into an Access database rather than an Excel spreadsheet. (Thank you anc1/eventide by the way). This worked fine for many years but has, obviously, now hit the same problems as the HYPTUS spreadsheet code.
My problem is that a change of job and two young kids means that I have not looked at VBA code since around that time and old age is now having an impact on my understanding of it! JSON dictionaries are completely new to me, as is Python.
The post from PeterGray looked as if it might offer the start of a solution, but I was concerned with eventide's comment of "Although this may work as intended, isn't it a serious amount of inefficient code overhead to extract a single field from the server response? Why would anyone choose to pull data like this?"
So is there a simple solution for someone with very rusty VBA knowledge to bring back the required data (as a JSON dictionary?) and be able to convert it to a VBA array so that the rest of my code can work as before?
Cheers
RF
Many years ago I managed to teach myself VBA and successfully cribbed anc1's Liveprice code to download the prices of my portfolio into an Access database rather than an Excel spreadsheet. (Thank you anc1/eventide by the way). This worked fine for many years but has, obviously, now hit the same problems as the HYPTUS spreadsheet code.
My problem is that a change of job and two young kids means that I have not looked at VBA code since around that time and old age is now having an impact on my understanding of it! JSON dictionaries are completely new to me, as is Python.
The post from PeterGray looked as if it might offer the start of a solution, but I was concerned with eventide's comment of "Although this may work as intended, isn't it a serious amount of inefficient code overhead to extract a single field from the server response? Why would anyone choose to pull data like this?"
So is there a simple solution for someone with very rusty VBA knowledge to bring back the required data (as a JSON dictionary?) and be able to convert it to a VBA array so that the rest of my code can work as before?
Cheers
RF