2 New Messages

Digest #2351

Re: Error retrieving ^DJI data by "thomas91112" thomas91112

SMFaddin now working by "futurehou" futurehou

Messages

1a

Re: Error retrieving ^DJI data

Fri Sep 21, 2012 7:57 am (PDT) . Posted by:

"thomas91112" thomas91112

You can try using the ETF for the Dow which is "DIA". This data set goes back to Jan 1998.

--- In smf_addin@yahoogroups.com, "kdpsf18" <kdpsf18@...> wrote:
>
> Randy,
>
> Since yahoo is no longer licensed to provide the file, is there another way to get the data?
>
> Thanks
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > Yahoo is no longer licensed to provide a CSV file of the historical DJIA
> > quotes...
> >
> > On Sat, Sep 8, 2012 at 8:35 AM, Harry Gross <harry@> wrote:
> >
> > >
> > > I'm having a problem retrieving values for the Dow:-(
> > >
> > > The formula in question is as follows:
> > >
> > >
> > > =RCHGetYahooHistory("^DJI",YEAR(N3),MONTH(N3),DAY(N3),YEAR(N3),MONTH(N3),DAY(N3),,"A",0)
> > >
> > > Where cell N3 contains that date I need data for. The problem is, I don't
> > > get anything back. However, if I change the symbol to, say, 'IBM' or
> > > '^GSPC' (the S&P 500), it works just fine.
> > >
> > > Did the symbol for Dow Industrial change? Is there something else going
> > > on?
> > >
> > > Note - this is happening in a spreadsheet that I loaded off the net - I
> > > didn't create it, and am not familiar with the various macro calls, so . . .
> > >
> > > Thanks for any assistance you can provide!
> > >
> >
>

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

2 SMFaddin now working

Fri Sep 21, 2012 12:04 pm (PDT) . Posted by:

"futurehou" futurehou

I have using the addin without problems for several years. However i have a new newtwork security device now and it appears to block SMF_addin. Tried the 'version' test and all is well. I have spent hours checking my firewall for problems but still the macro refuses to even return the simple stock price. Any ideas?