Greetings. The 1-30-2012 version does not appear to be in the works in progress folder at this time. (I see only three items there (need to be looked at...
Hi Randy, I see that the SMFTech function is coded to print the results base don the dates running from bottom to top i.e. the latest date is at the bottom of...
Those are AdvFN elements and you need the absolute latest SMF which addresses the recent change to that website. Those elements are working fine for me with...
Nope. However, you could get the free TA-Lib add-in, which has a reverse function library that will. Do a search of the message archives for more info on it....
Randy I am having a problem with the following code: Public Sub x() Dim f1 As String Dim f2 As String Dim i As Integer Dim j As Integer Dim np As String f2 = "...
No, it's that the XMLHTTP protocol only returns a truncated copy of the source code of the web page. I don't know why. I looked into the problem several years...
I don't think the add-in can be of any help in this case. All add-in functions require a bookmarkable URL. It can't be a URL generated dynamically by...
When I'm on the historical quotes page for Google or MSN, both have a "Download" option. You should just grab that file and sort it in whatever order you need,...
Ah yes thanks. Am I missing something here? Why is it that the SMFGetYahooHistory displays the columns with the earliest date at the top of the array, whilst...
RCHGetYahooHistory() can sort the data either way. The default is to go from the latest date at the top, just like the others. But SMFTech() can only take it...
Previous posts indicate last year Stockhouse.com stopped listing stock scores. I'd like to continue using the Signal StockScore and Sentiment StockScore...
I don't get an "Error" with your sample formula below. It's just that they have extraneous data in the table cell. As examples: B4: EWZ B6: Signal Stockscore ...
Good morning Randy, I am trying to extract Sector and Industry Classifications from the following site:"http://tmx.quotemedia.com/company.php?qm_symbol=AAV". I...
Thanks Randy. I have not put it manually but I tried to update the link since I was getting the error when I opened the file... When I remove the location as...
You need to array-enter the formula over a range to get the data into the worksheet. If you just enter it into a single cell, you just get the first row and ...
Can't do it, sorry. I can see the web site fine in FireFox, but if I try to use EXCEL's Web Query dialog, it says that Internet Explorer cannot access the web...
Randy, I can see that site just fine in Excel Web Query (and IE). In fact, I used W/Q to place that whole web page in my worksheet and I saw it fine - ...
