Thank you for your answer. In fact I'm only looking for the ending values. And I don't know which function to use for extracting these values. Could you show...
Hello Randy, While using "rchgettablecell-template-barchart-technical-signals.xls"; Under the OVERALL Rating cell, I am not getting a rating answer? I get a...
Hi, I retrieve 8 webpages with GetWebData and extract information A, then I retrieve the same 8 webpages with GetWebData and extract information B, then I...
Chill. No virus. They just changed the content of the web page, so the search strings I was using didn't get to the right area of the web page. I just uploaded...
There should be no reason to open the add-in. By using the add-in manager, EXCEL opens the add-in automatically and its functions are available to you in the...
I'm trying to array-enter this formula: =RCHGetElementNumber(A4:A22,13865) A4 through A22 are stock ticker symbols. When I hit Ctrl-Shift-Enter, I get #VALUE...
RCHGetElementNumber() only returns a single element number for a single ticker symbol, so giving it a range of ticker symbols (or element numbers) will not...
Thanks Randy, I mean I write formulas like this in the cells: =RCHGetWebData(...) =RCHGetTableCell(...) then if I open the sheet for the first time, the actual...
If I well understand, what we want to do is to extract the value from the source of the webpage. Unfortunately it doesn't seem to work for me. I don't...
I just tried the file from the group and it works fine for me. "Doesn't seem to work" gives me no information about what might be working. What version of the...
It is on their web pages of the dividend data, but not in their CSV file offering. So you could grab them off of the web pages by iterating over them. However,...
Thanks very much, just what I needed. FYI: My use of Global Variables apparently was hiding info EXCEL needed to do things in the proper sequence. Getting...
I was wondering if there's a way to extract highest and lowest closing price for a particular stock in any given time frame, i.e. user enters a time frame of...
Dear All, I have a newbie question. I am using rchgetyahoohistory to download historical data. It seems, the maximum i can download at any one time is only...
You should be able to download as much data as Yahoo has. For many companies, that means data back to 1970. For an index like the DJIA, that means data back to...
Take a look at the smfPricesBetween() function... Or you can extract data from BarChart. They have a number of high/low values, by day, week, or month. For...
Ah. I missed the fact you wanted closing prices only, so smfPricesBetween() won't work either. You're pretty much going to need to use RCHGetYahooHistory() to...
As noted in the intro page of the group, and in your introductory email: "The "Files" area of this group contains the add-in, documentation on its functions,...
Yes, smfForceRecalculation has worked on the workday. I tested it on Saturday last time and the stock market was closed... retrieved data was unchanged....
Hello, I have downloaded the last version present on this yahoo website. I have a Value# type of error. In your example for the first line I have: mai...
Randy - I have been getting data from this page.http://federalreserve.gov/releases/h15/data/Business_day/H15_TCMNOM_Y7.txt My spreadsheet stopped working. ...
