Hmmm. I just got the closing price on 3500 stocks using RchGetYahooQuotes(). It took 10 minutes, but it worked-I checked a random sample of them. ... From:...
203
cykwan80
Aug 14, 2006 10:51 pm
thanks...
202
Steve Shepherd
wheelchair1956
Aug 14, 2006 6:31 pm
200 ... From: cykwan80 To: smf_addin@yahoogroups.com Sent: Monday, August 14, 2006 1:19 PM Subject: [smf_addin] RchGetYahooQuotes It seems there is an upper...
201
Randy Harmelink
rharmelink
Aug 14, 2006 6:04 pm
... There is an upper limit imposed by Yahoo of 200 symbols per request. Just use the function multiple times, each with 200 or less symbols. In the next...
200
cykwan80
Aug 14, 2006 5:22 pm
It seems there is an upper limit of stocks I can handle in one spreadsheet using the RchGetYahooQuotes() add_in function, as my spreadsheets work perfectly...
199
smf_addin@yahoogroups...
Aug 13, 2006 7:02 pm
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the smf_addin group. File :...
198
Randy Harmelink
rharmelink
Aug 13, 2006 5:35 pm
... Actually, it's available free. But non-subscribers get a delayed value. For example, I think their free online screener can have values delayed up to a...
197
jp_ibd
Aug 13, 2006 5:14 pm
I was interested in creating addin which used the "Zacks Rank". I now realize the data is only available unless you subscribe to one of Zacks data packages. Do...
196
Randy Harmelink
rharmelink
Aug 12, 2006 7:54 pm
... One already exists -- it's in the files area. That's the one we've been talking about. There are a number of different templates and examples there. ... ...
195
Steve Shepherd
wheelchair1956
Aug 12, 2006 7:07 pm
Could you please give me an example of how to construct a price history template? Also, when writing the month, do you use three letter abbreviations or...
194
Randy Harmelink
rharmelink
Aug 11, 2006 11:00 pm
The quickest thing you can do to check for excess worksheet size is to compare the used range of each worksheet to what you actually need. For example, if you...
193
Dieter Engelke
dieterengelke
Aug 11, 2006 8:51 pm
I am using EXCEL 2003 and my spreadsheet has a lot of formulas and external links. Has anyone else this problem too and a solution? _____ Von:...
192
Randy Harmelink
rharmelink
Aug 11, 2006 6:33 pm
... Hmmm. I created my own little batch downloader from the template. My original saved size was 48KB. I retrieved historical data for 5 ticker symbols and...
191
dieterengelke
Aug 11, 2006 3:00 pm
Hi Randy, since last monday I use your SMF-Template-Yahoo-Historical-Quotes once a day to fetch with a batchmacro the recent month Historical Quotes for some...
Let me make a correction. PowerInvestors software has merit, however it is outdated and there is better available. If the objective is fundamental analysis,...
188
jp_ibd
Aug 10, 2006 4:19 pm
I would like to change the formula path from: "='F:\Program Files\SMF Add-In\RCH_Stock_Market_Functions.xla'!RCHGetElementNumber(Ticker,461)" to ...
187
Randy Harmelink
rharmelink
Aug 10, 2006 3:38 am
... That's why I said I use the technique of Ctrl-Z (undo). If the C7:G14 range doesn't work, I immediately hit Ctrl-Z and then adjust the range further and...
186
cykwan80
Aug 10, 2006 3:22 am
thanks Randy, eventually I have this working. But I still have some problems with array enter. I follow your procedure in the thread: 1.) enter the formula ...
185
Kermit W. Prather
kermitpra
Aug 9, 2006 8:58 pm
The new TC2007 will have 15 years of historical fundamental data. So you;ll be able to chart the fundamental just like stock. But investigate thoroughly as I...
184
don j
jp_ibd
Aug 9, 2006 6:58 pm
PowerInvestors looks good on paper, however it doesn't work. There is zero support !! It crashes the system. They keep saying they add functions, yeah, ...
183
S N
sia_nyc
Aug 9, 2006 4:27 pm
Got it thanks!!! ... You mentioned in another thread you had problems using the RCHGetHTMLTable() function to do this? I was able to get them. For calls: ...
182
Randy Harmelink
rharmelink
Aug 9, 2006 3:33 am
... Each "source" is basically a single web page. At this point, they are: AdvFN-Ahttp://ogres-crypt.com/php/advfn-financials.php?per=a&sym=~~~~~ ...
181
Randy Harmelink
rharmelink
Aug 9, 2006 3:25 am
... I looked at your upload file. Once I changed the RCHGetYahooHistory() function to be array-entered (using range C7 to G14), it worked fine. By the way,...
180
cykwan80
Aug 8, 2006 9:12 pm
When I was going over the list of RCHGetElementNumber() function, document 2.1, I was wondering the following sources? BWtech BWOpin BWsumm Earnings AdvFn-Q ...
179
Ron Gaillard
rgaillard
Aug 8, 2006 7:14 pm
One thing that might simplify things is to force a simple recalculation. I have this code in module1 of the spreadsheet. The VBA command for a full recalc is...
178
Randy Harmelink
rharmelink
Aug 8, 2006 5:02 pm
... Can you upload a copy of the workbook that doesn't appear to work? All of my testing to try and reproduce the problem was based on using a range for the...
177
cykwan80
Aug 8, 2006 4:26 pm
But the main problem is that the add_in function seems to fail to recognize my column of stocks on A column when I use A1:A200 while it works well by typing...
176
Randy Harmelink
rharmelink
Aug 8, 2006 9:44 am
... The only thing Ron's routine is missing is the "GetQuotes" subroutine, which the timer would be calling every two minutes. If your range of ticker symbols...
175
Randy Harmelink
rharmelink
Aug 8, 2006 9:27 am
... I definitely would NOT recommend using the RCHGetElementNumber() function instead -- that would do one web page request for each ticker symbol and take a...
