im trying to use excel to say, when i insert stock symbols on column A, it would load me the stock prices...
when i insert till 200 rows, it seems to work
but if say, i insert 400 rows, i starting to get the error: subscript out of range.
test1.JPG
Pls help!
my code:
Please Login or Register to view this content.
Last edited by Leith Ross; 09-14-2014 at 12:11 AM. Reason: Added Code Tags
Hi geekohi,
This error means that the code cannot locate something it is supposed to work/make changes on.
It could mean a misspelled/missing object such as a Worksheet name just as one example.
Can you post the file you're using and advise the row that the error occurs on?
Thanks
Remember you are unique, like everyone else
Hi, noboffinme, I really appreciate your response and truly thankful if you could make this work.
the download link for the file: https://www.sendspace.com/file/frn43o
the code you should be focusing is in "sheet19 (stocks)" line 135 to 179 under the tab loaddata()
I want to be able to download say a thousands of stocks data instead of hundreds. Thanks.
Hi, noboffinme, I really appreciate your response and truly thankful if you could make this work.Originally Posted by noboffinme
the download link for the file: https://www.sendspace.com/file/frn43o
the code you should be focusing is in "sheet19 (stocks)" line 135 to 179 under the tab loaddata()
I want to be able to download say a thousands of stocks data instead of hundreds. Thanks.
Can you post the file through this site?
Go to 'Go Advanced' >> 'Manage Attachments' >> 'Select File' >> 'Upload File' >> 'Done'
Thanks
yeap, done.
Where in the code do you get the error?
If posting code please use code tags, see here.
the thing I dont quite understand is, I am not getting any errors in my code.
The code does function as expected when say, I insert roughly 200 stock code on column A.
If I insert > 300-400, then it runs and just says that: subscript out of range (without pointing to me, where in the code I get the error)
Im trying to make this stock data loader applicable to say, thousands of stocks.
The line of code used for the loading process (when press on "load button"), its sheet19 (stocks)
Please Login or Register to view this content.
When you get the error is there no option to debug?
Im still a newbie to programming using excel, starting to learn.
Everytime I got an error, excel will roughly highlight the line of code in yellow, I will work from there on.
But for this, when I got the error, there is no indication of where which the line got the error.
VBA should highlight the line the error occured on when you click debug.
It won't specifically say what in that line caused the error.
I've actually got a hunch that this is what's causing the problem, probably something to do with the response the the web request not being what you expected.
In fact when I run the code this is what sLine is.Please Login or Register to view this content.
and if I look further up in the code this is what's in Resp, which is the response from the web query.
Thx Norie, I researched further and found that the limit is set at 200 ticker symbols at a time. Not very convenient if I'm trying to load all at once.
Have any suggestion how I can improvise this.
Can I actually scrap data from the official stock data website, such as this one using the same method as before
but grabbing all data at once based on its stock code:
http://www.bursamalaysia.com/market/...tock_code=0010
I found the code throws this error as it looks for a worksheet called 'Trading Volume' in the 'Calculator Sub.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks