Randy: I am using =RCHGETHTMLTable("http://www.indiainfoline.com/stocks/sectorwatch.asp? lmn=2§or=MET&tmenu=3&ln=nr6","Current Price",-1,"",1) I only get...
The problem is that the table is improperly coded on that web page. For example, I found at least one "<td>" to start a new cell that should have been a...
Hi ... I am wanting to find the ATM Option symbol and option last price of the current month (now Dec) if the following is known ... Col A ... Stock Symbol Col...
Has anyone got such a message before. what does it mean adn how can one overcome this problem. Stock symbol A, I was getting information for the following. ...
The add-in uses saved web pages to extract the data from. It only has room for saving 1000 web pages. Anything beyond 1000 web pages in a single session...
Randy ... thanks for the feedback ... I will try it on Monday and let you know Richard ... From: Randy Harmelink To: smf_addin@yahoogroups.com Sent: Sunday,...
Hi: I run my macro on ONLY 2 symbols. msft and A. When i got the error message on A three times. I decided to try other symbols and they worked fine. In fact,...
You should only get that error message if the add-in needed to grab a new web page and it already has saved 1000 of them. Any formulas grabbing data elements...
Also, if you're curious which web pages have been retrieved and saved, you can use the smfGetAData() function. I added it on the last release for my own...
Randy, I was wondering how I download the yahoo mutual fund management information under yahoo's mutual fund profile page. I am using the mutual fund data...
You could use the RCHGetTableCell() function to grab the data. For example, something like: =RCHGetTableCell("http://finance.yahoo.com/q/pr?s=FDIVX",0, "Lead...
I am getting the same data elements from the same webpage. I have macro that loops that loops through 30 stocks and populates my spreadsheet. I will find out ...
Thanks Randy. I've monitored this site for several months now and I'm still not certain of all its posibilities. However, it sure has helped me learn a...
Randy: I am doing research and at times, I have to run the symbols over several years. I got the same error messages. If I turn off my computer and restart,...
You shouldn't need to turn off the computer. Just exit and restart EXCEL, or just use the macro I mentioned. I am confused by two things you mentioned: --...
Thanks you Don and Randy, I have all the collected spreadsheets DJ data entered into the Zacks Industry Excel spreadsheet using your trim recommendation. ...
I believe you need to remove the trailing blank from each ticker symbol in the "ZacksIndustryB2:B6000" range. You can't do it in your VLOOKUP() formula. But...
Oops. I left it out when I copied it here, but it is in my spreadsheet and didn't work. If by brute force, that means entering every symbol manually, I can do...
No. By brute force, I meant to use a manual process of "Replace all" or use a TRIM() function in a nearby column and do a copy and paste values back over the...
Randy ... most of the symbols works fine, but take IBM ... I am getting Error in the Stike1, 2, and 3 fields ... any ideas? Richard ... From: Randy Harmelink ...
Hmmm. Looks like what I cut and pasted into the message isn't what Yahoo posted. All of the formatting strings for the TEXT() function should be " 0.00" (no...
Randy ... I had alread fixed the items you had marked But I did have to change F3 to the following Old ... F3: =IF(C3>0,C3,IF(D3>0,D3,E3)) New ... F3:...
