9 New Messages
Digest #2343
| |
Messages
Tue Sep 11, 2012 8:27 am (PDT) . Posted by:
"whitney" thelancour
I have another challenge, at this url http://205.166.161.12/oncoreV2/search.aspx?bd=1%2F1%2F2012&ed=9%2F11%2F2012&n=realcet&bt=O&d=9%2F11%2F2012&pt=-1&dt=D%2CAGD%2CEAS&st=fullname&vbt=M (you will have to enter the CAPTCHA code) there is a csv export link to retrieve the data. Is there a way to use the get csv data function to obtain this data, or is there a way to use another function to retrieve this data? Thoughts...?
Tue Sep 11, 2012 9:30 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't see a way to grab the export file with the add-in. It appears the
link actually creates the CSV file, instead of it downloading an existing
file.
On Tue, Sep 11, 2012 at 8:27 AM, whitney <thelancour@yahoo.com > wrote:
> I have another challenge, at this url
> http://205.166.161.12/oncoreV2/search.aspx?bd=1%2F1%2F2012&ed=9%2F11%2F2012&n=realcet&bt=O&d=9%2F11%2F2012&pt=-1&dt=D%2CAGD%2CEAS&st=fullname&vbt=M (you will have to enter the CAPTCHA code) there is a csv export link to
> retrieve the data. Is there a way to use the get csv data function to
> obtain this data, or is there a way to use another function to retrieve
> this data? Thoughts...?
>
link actually creates the CSV file, instead of it downloading an existing
file.
On Tue, Sep 11, 2012 at 8:27 AM, whitney <thelancour@yahoo.
> I have another challenge, at this url
> http://205.166.
> retrieve the data. Is there a way to use the get csv data function to
> obtain this data, or is there a way to use another function to retrieve
> this data? Thoughts...?
>
Tue Sep 11, 2012 9:16 am (PDT) . Posted by:
"indinvestor111" indinvestor111
Hi Randy,
I'm getting an error message with this function:
=smfGetAdvFNElement(ticker,"q",V$3,$B177,$A177)
V$3 is the period (numerical)
$B177 is INVESTING ACTIVITIES
$A177 is purchase of short-term investments
Any idea what's going on here? Seems all of the other functions on the page work fine.
Thanks
I'm getting an error message with this function:
=smfGetAdvFNElement
V$3 is the period (numerical)
$B177 is INVESTING ACTIVITIES
$A177 is purchase of short-term investments
Any idea what's going on here? Seems all of the other functions on the page work fine.
Thanks
Tue Sep 11, 2012 9:26 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Which ticker symbol? Does it have the specified line item?
On Tue, Sep 11, 2012 at 9:16 AM, indinvestor111 <elandry@bmlcapital.com >wrote:
>
> I'm getting an error message with this function:
>
> =smfGetAdvFNElement(ticker,"q",V$3,$B177,$A177)
>
> V$3 is the period (numerical)
> $B177 is INVESTING ACTIVITIES
> $A177 is purchase of short-term investments
>
> Any idea what's going on here? Seems all of the other functions on the
> page work fine.
>
On Tue, Sep 11, 2012 at 9:16 AM, indinvestor111 <elandry@bmlcapital.
>
> I'm getting an error message with this function:
>
> =smfGetAdvFNElement
>
> V$3 is the period (numerical)
> $B177 is INVESTING ACTIVITIES
> $A177 is purchase of short-term investments
>
> Any idea what's going on here? Seems all of the other functions on the
> page work fine.
>
Tue Sep 11, 2012 9:31 am (PDT) . Posted by:
"indinvestor111" indinvestor111
Thanks for the reply. It does it with all tickers. Just tried CHS then KIRK. Both came up "Error". As for the specific line item, I'm just using the line items on the AdvFN page. Same descriptions.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Which ticker symbol? Does it have the specified line item?
>
> On Tue, Sep 11, 2012 at 9:16 AM, indinvestor111 <elandry@...>wrote:
>
> >
> > I'm getting an error message with this function:
> >
> > =smfGetAdvFNElement(ticker,"q",V$3,$B177,$A177)
> >
> > V$3 is the period (numerical)
> > $B177 is INVESTING ACTIVITIES
> > $A177 is purchase of short-term investments
> >
> > Any idea what's going on here? Seems all of the other functions on the
> > page work fine.
> >
>
--- In smf_addin@yahoogrou
>
> Which ticker symbol? Does it have the specified line item?
>
> On Tue, Sep 11, 2012 at 9:16 AM, indinvestor111 <elandry@...
>
> >
> > I'm getting an error message with this function:
> >
> > =smfGetAdvFNElement
> >
> > V$3 is the period (numerical)
> > $B177 is INVESTING ACTIVITIES
> > $A177 is purchase of short-term investments
> >
> > Any idea what's going on here? Seems all of the other functions on the
> > page work fine.
> >
>
Tue Sep 11, 2012 9:46 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Just looked at CHS. This works:
=smfGetADVFNElement("CHS","q",1,"Investing Activities","Purchase of
short-term investments")
Note that there are TWO blanks between "of" and "short-term" -- that's the
label they have on the web page.
On Tue, Sep 11, 2012 at 9:31 AM, indinvestor111 <elandry@bmlcapital.com >wrote:
> Thanks for the reply. It does it with all tickers. Just tried CHS then
> KIRK. Both came up "Error". As for the specific line item, I'm just using
> the line items on the AdvFN page. Same descriptions.
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
> >
> > Which ticker symbol? Does it have the specified line item?
> >
> > On Tue, Sep 11, 2012 at 9:16 AM, indinvestor111 <elandry@...>wrote:
> >
> > >
> > > I'm getting an error message with this function:
> > >
> > > =smfGetAdvFNElement(ticker,"q",V$3,$B177,$A177)
> > >
> > > V$3 is the period (numerical)
> > > $B177 is INVESTING ACTIVITIES
> > > $A177 is purchase of short-term investments
> > >
> > > Any idea what's going on here? Seems all of the other functions on the
> > > page work fine.
>
=smfGetADVFNElement
short-term investments"
Note that there are TWO blanks between "of" and "short-term" -- that's the
label they have on the web page.
On Tue, Sep 11, 2012 at 9:31 AM, indinvestor111 <elandry@bmlcapital.
> Thanks for the reply. It does it with all tickers. Just tried CHS then
> KIRK. Both came up "Error". As for the specific line item, I'm just using
> the line items on the AdvFN page. Same descriptions.
>
> --- In smf_addin@yahoogrou
> >
> > Which ticker symbol? Does it have the specified line item?
> >
> > On Tue, Sep 11, 2012 at 9:16 AM, indinvestor111 <elandry@...
> >
> > >
> > > I'm getting an error message with this function:
> > >
> > > =smfGetAdvFNElement
> > >
> > > V$3 is the period (numerical)
> > > $B177 is INVESTING ACTIVITIES
> > > $A177 is purchase of short-term investments
> > >
> > > Any idea what's going on here? Seems all of the other functions on the
> > > page work fine.
>
Tue Sep 11, 2012 9:54 am (PDT) . Posted by:
"indinvestor111" indinvestor111
Yup. That did the trick. Just inserted the extra space, and Whala!
Great work!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Just looked at CHS. This works:
>
> =smfGetADVFNElement("CHS","q",1,"Investing Activities","Purchase of
> short-term investments")
>
> Note that there are TWO blanks between "of" and "short-term" -- that's the
> label they have on the web page.
>
> On Tue, Sep 11, 2012 at 9:31 AM, indinvestor111 <elandry@...>wrote:
>
> > Thanks for the reply. It does it with all tickers. Just tried CHS then
> > KIRK. Both came up "Error". As for the specific line item, I'm just using
> > the line items on the AdvFN page. Same descriptions.
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Which ticker symbol? Does it have the specified line item?
> > >
> > > On Tue, Sep 11, 2012 at 9:16 AM, indinvestor111 <elandry@>wrote:
> > >
> > > >
> > > > I'm getting an error message with this function:
> > > >
> > > > =smfGetAdvFNElement(ticker,"q",V$3,$B177,$A177)
> > > >
> > > > V$3 is the period (numerical)
> > > > $B177 is INVESTING ACTIVITIES
> > > > $A177 is purchase of short-term investments
> > > >
> > > > Any idea what's going on here? Seems all of the other functions on the
> > > > page work fine.
> >
>
Great work!
--- In smf_addin@yahoogrou
>
> Just looked at CHS. This works:
>
> =smfGetADVFNElement
> short-term investments"
>
> Note that there are TWO blanks between "of" and "short-term" -- that's the
> label they have on the web page.
>
> On Tue, Sep 11, 2012 at 9:31 AM, indinvestor111 <elandry@...
>
> > Thanks for the reply. It does it with all tickers. Just tried CHS then
> > KIRK. Both came up "Error". As for the specific line item, I'm just using
> > the line items on the AdvFN page. Same descriptions.
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Which ticker symbol? Does it have the specified line item?
> > >
> > > On Tue, Sep 11, 2012 at 9:16 AM, indinvestor111 <elandry@>wrote:
> > >
> > > >
> > > > I'm getting an error message with this function:
> > > >
> > > > =smfGetAdvFNElement
> > > >
> > > > V$3 is the period (numerical)
> > > > $B177 is INVESTING ACTIVITIES
> > > > $A177 is purchase of short-term investments
> > > >
> > > > Any idea what's going on here? Seems all of the other functions on the
> > > > page work fine.
> >
>
Tue Sep 11, 2012 4:44 pm (PDT) . Posted by:
"kdpsf18" kdpsf18
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!
> >
>
Since yahoo is no longer licensed to provide the file, is there another way to get the data?
Thanks
--- In smf_addin@yahoogrou
>
> 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
> >
> > 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!
> >
>
Tue Sep 11, 2012 4:46 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
That can be answered any of a dozen ways, depending on exactly what data
you're going after...
In my case, I just use DIA instead.
On Tue, Sep 11, 2012 at 3:40 PM, kdpsf18 <kdpsf18@yahoo.com > wrote:
>
> Since yahoo is no longer licensed to provide the file, is there another
> way to get the data?
>
you're going after...
In my case, I just use DIA instead.
On Tue, Sep 11, 2012 at 3:40 PM, kdpsf18 <kdpsf18@yahoo.
>
> Since yahoo is no longer licensed to provide the file, is there another
> way to get the data?
>
Tidak ada komentar:
Posting Komentar