Hi friends,
I have been trying to download stock data from google finance link (http://www.google.com/finance/getpri...&f=d,o,h,l,c,v) into excel and have created vba macro for the same.
The below is the sample data I get from the above link.
1,3882,3890.8,3862.35,3890.8,724
2,3873.6,3879.9,3873.6,3879.9,161
3,3880,3880,3873.6,3873.6,403
4,3865.3,3878.75,3865.3,3877.15,281
...
...
372,3898.65,3900,3898.55,3900,259
373,3897.2,3900,3896.05,3898.65,638
374,3890,3896,3890,3895,474
385,3901.4,3901.4,3901.4,3901.4,34
Kindly note the data highlighted in bold in the above sample. I can download all into excel as a text format (except for the bold data) since their is a comma AND decimal points both in all other data samples. However in the data highlighted in bold above, there is no decimal point only comma is appearing. When this data is transferred to excel it is converted into numeric. And this is what I do not want. I want the same data in text format with commas as I further have to do text to columns and use comma as delimiter. The data what is transferred for the highliget data point is 3.7438903896389E+21.
Experts kindly advise me on what code I should put in the web query to solve this problem.
Thanks,
R. Pandit
Bookmarks