is very tempermental today. Not able to retrive data for about half of tickers selected in an array entered retrieve that asks for price and change. A...
Randy, I must be making an error. I tried for ticker XBI and others. Get #VALUE!. Not sure what I'm doing wrong. It also does not like the "*" in three of...
The "column" is the number of columns from the string being searched for, while negative values get that relative column from the end of the row. For example,...
yes, that is what i was after! one more thing, how can i call RCHGetTableCell() from another function? call RCHGetTableCell() as i found out doesn't work....
Randy: We all just want to say Thanks a Zillion for all the help we have gotten from you without expecting anything in return for many years now. More than...
I've been having trouble with RCHGetYahooHistory for a while. I assume it is on the Yahoo end, because if it try it later on, it will be different. For...
It does appear to be a problem on the Yahoo end, since currently THMD history on Yahoo ends on 7/22/2008 when I view the historical quotes web page here: ...
Thanks. Is there a better (free!) place to get historical quotes from? I've wondered whether Yahoo is losing focus on their quality control given all the...
Sorry for the confusion. I would like to write a simple VBA function to return only the quote from Google. First, i would call RCHGetTableCell(), which would...
You need to set up a link to the add-in library using menu options > Tools > References. Otherwise, your VBA environment isn't aware the add-in functions...
I'd like to be able to construct a portfolio of indexes and then calculate return over a variable time period. I can see the return for a bunch of equities if...
I've done that -- even created a graph of my portfolio value over time. It's just a matter of getting the historical quotes for the indexes over the time...
that did it! i wanted to use vba in order avoid the double call to RCHGetTableCell(). as far as i can tell, google quotes are always in the form of xxxx.xx....
Thanks, Randy. I'm trying to use your smfPricesByDates() function available in the "Works in Progress" folder. I downloaded the example and the associated...
The #NAME? issue, the full path showing up in the cell, and the link error message are all telling you that it can't find the add-in function. Did you save...
No, I didn't do a save. But when I try to save I get another error: Microsoft Office Excel cannot access the file 'C:\Program Files\SMF Addin'. There are...
I don't know what you mean. The add-in does reside at C:\Program Files\SMF Addin. After I import the new macro I tried to "Save" and I get the error. How do...
If that's were the add-in resides, then you did create the path during the install. I just can't figure out why it won't let you save the add-in. Unless you...
Agree...to some extent. However, I don't think there are many professional traders relying upon either YHOO or GOOG for data. Services like Esignal and DTN IQ...
When I try, =RCHGetElementNumber("Version"), I get following. Stock Market Functions add-in, Version 2.0h when I try a web query, it works fine. I've disabled...
Randy .... have been trying to use "Raw Data for IBD Extract-Modified.xls" file (mentioned in your earlier post)with no success. When I open it there is a...
I just tried it and it worked fine for me, using the file from the Yahoo Group. However, I did use the EXCEL Web Query process to log in first, not IE. Right...
Randy: First, let me just echo the thanks I have seen from many others for your valuable efforts on these tools. I never ceased to be amazed at the number of...
This one has me stumped as well. All of the examples you cite work fine for me. The only time I get a #VALUE? error is if I try to use the returned time in a...
Randy: I neglected to mention that I am on WinXP (SP2) and Excel 2003, for whatever that's worth. I get the same string result as you when I used the...
The formula you gave for the morningstar stars worked for me...but the formula you gave for the Morningstar Fair Value did not...this is what you wrote: ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
