3 New Messages

Digest #2743

Re: Extracting/Parsing Dates with RCHGetYahooHistory by "Sheldon" sheldon.eden

Re: Extracting/Parsing Dates with RCHGetYahooHistory by "Randy Harmelink" rharmelink

Re: AdvFn not updating by "MLawson" mlawson3

Messages

1a

Re: Extracting/Parsing Dates with RCHGetYahooHistory

Fri Aug 23, 2013 9:29 am (PDT) . Posted by:

"Sheldon" sheldon.eden

I'm having problems getting the dates properly translated. Simply replacing the dates with the corresponding cell references doesn't work. How can I write the formula to reference a single cell for three separate values, especially when the formula is YYYY-MM-DD, while the cell is formatted

MM-DD-YYYY

or

DD-MM-YYYY

and the formula values are comma-separated? I'm looking at using the DATEVALUE function to do this, but I haven't come up with anything so far.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Sure. For the most part, you can treat them like any other EXCEL function.
> Just do the cell references.
>
> But you can't give it values for just one of beginning and ending
> dates...you need to either do none, or both.
>
> On Mon, Aug 19, 2013 at 12:51 PM, Sheldon <sheldon.eden@...> wrote:
>
> > When using the RCHGetYahooHistory function, is it possible to extract the
> > date information out of another cell? Specifically, I'm doing some data
> > analysis to track price changes over time, and I want to get the Open and
> > Close values of the stock for my date range. I am able to use the formula
> > to reference a cell for the symbol, and I would like to be able to do the
> > same for the date.
> >
> > My formula so far is like so:
> >
> > =RCHGetYahooHistory([symbolCell],2013,8,5,2013,8,5,,"OC",0)
> >
> > In this case, what I would like to do is be able to replace the two Date
> > parameters with a reference to another cell, so that it might wind up like
> > this:
> >
> > =RCHGetYahooHistory([symbolCell],[startDateCell],[endDateCell],,"OC",0)
> >
> > My reasoning for this is so that I can use the same worksheet and list of
> > stocks, but I could set a filter on my Date column to adjust my start date.
> >
> > Is this possible?
> >
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1b

Re: Extracting/Parsing Dates with RCHGetYahooHistory

Fri Aug 23, 2013 1:36 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Formatting of the cell is irrelevant, unless you've created the date as a
text field (not a good idea). If the cell contains a normal EXCEL serial
date value, then month, day, and year are simply:

MONTH(A1)
DAY(A1)
YEAR(A1)

On Fri, Aug 23, 2013 at 9:29 AM, Sheldon <sheldon.eden@yahoo.com> wrote:

>
> I'm having problems getting the dates properly translated. Simply
> replacing the dates with the corresponding cell references doesn't work.
> How can I write the formula to reference a single cell for three separate
> values, especially when the formula is YYYY-MM-DD, while the cell is
> formatted
>
> MM-DD-YYYY
>
> or
>
> DD-MM-YYYY
>
> and the formula values are comma-separated? I'm looking at using the
> DATEVALUE function to do this, but I haven't come up with anything so far.
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

2a

Re: AdvFn not updating

Fri Aug 23, 2013 6:04 pm (PDT) . Posted by:

"MLawson" mlawson3

I just received an email indicating that the problem has been solved. The advfn rep sent me a link to McDonalds' financials - the entire history was present. He also wrote that all the companies are expected to be updated by Tuesday.

The site looks different, so I don't know if the add-in is going to work right away, though.

--- In smf_addin@yahoogroups.com, "indinvestor111" <elandry@...> wrote:
>
> Hi,
>
> Was wondering if anybody's heard anything about AdvFN not providing the latest quarter's results on US tickers.
>
> I noticed the issue was raised a month ago, where the folks at the site mentioned a fix was in the offing and likely to be out in a week or two. Am I missing something?
>
> Thanks
>