4 New Messages
Digest #2669
Messages
Sun Jun 23, 2013 6:56 am (PDT) . Posted by:
"schlange.meister" schlange.meister
Hi Randy
That sheet is exactly what I was trying for. It worked the last weeks and suddendly this week, it does not work on either my work or personal laptop.
Does it still work for you? Everything except price comes back as #NA
Any advice?
Best
Schlange
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Copy and paste transpose doesn't work as you would want for array-entered
> functions. It will transpose the function itself, but the cell references
> and returned data will just plop into the resulting range without
> themselves being transposed. You'd need to redo the formula.
>
> I just uploaded a this version:
>
> Price-Performance-Data-Retrieval-v4.xls
>
> Is it what you are trying to do?
>
> On Wed, May 1, 2013 at 11:32 PM, schlange.meister <
> schlange.meister@...> wrote:
>
> > I have downloaded the Price-Performance-Data-Retreival-V3.xls sheet from
> > the files section. This sheet gives the 1 wee, 1 month, 3 month, 6 month
> > and 12 month returns (Momentum) of stocks from Yahoo. It seems to be using
> > arays, but not sure what those are or how to use them.
> >
> > I wanted to transpose all cells. It has Stocks listed in colums and the
> > different returns listed in rows. I wanted to have Stocks in the rows.
> >
> > When I select all and then paste with Transpose, it looks correct in
> > layouts, but the data no longer updates correctly. Only the 1 week return
> > is correct. The 1 month, 3 month and so on are exact copies of the 1
> > month. However, the formulas appear to be correct.
> >
> > Any ideas?
> >
>
That sheet is exactly what I was trying for. It worked the last weeks and suddendly this week, it does not work on either my work or personal laptop.
Does it still work for you? Everything except price comes back as #NA
Any advice?
Best
Schlange
--- In smf_addin@yahoogrou
>
> Copy and paste transpose doesn't work as you would want for array-entered
> functions. It will transpose the function itself, but the cell references
> and returned data will just plop into the resulting range without
> themselves being transposed. You'd need to redo the formula.
>
> I just uploaded a this version:
>
> Price-Performance-
>
> Is it what you are trying to do?
>
> On Wed, May 1, 2013 at 11:32 PM, schlange.meister <
> schlange.meister@
>
> > I have downloaded the Price-Performance-
> > the files section. This sheet gives the 1 wee, 1 month, 3 month, 6 month
> > and 12 month returns (Momentum) of stocks from Yahoo. It seems to be using
> > arays, but not sure what those are or how to use them.
> >
> > I wanted to transpose all cells. It has Stocks listed in colums and the
> > different returns listed in rows. I wanted to have Stocks in the rows.
> >
> > When I select all and then paste with Transpose, it looks correct in
> > layouts, but the data no longer updates correctly. Only the 1 week return
> > is correct. The 1 month, 3 month and so on are exact copies of the 1
> > month. However, the formulas appear to be correct.
> >
> > Any ideas?
> >
>
Sun Jun 23, 2013 8:59 am (PDT) . Posted by:
"Randy H" rharmelink
I just opened it up from the FILES area of the group and it worked as
expected:
Current Price 1 Week Return 1 Month Return 3
Month Return 6 Month Return 12 Month Return 2013-06-21
2013-06-14 2013-05-21 2013-03-21 2012-12-21 2012-06-21 ^GSPC
$1,592.43 -2.1% -4.6% 3.0% 11.3% 20.1% #N/A #N/A SPY $159.07 -2.0%
-4.3% 3.6% 12.5% 22.8% #N/A #N/A MMM $109.59 -1.3% -1.6% 5.0% 19.1%
29.5% #N/A #N/A IBM $195.46 -3.3% -6.3% -7.5% 2.0% 2.9% #N/A #N/A
Usually #N/A means a problem with the date for the historical quote
retrieval.
On Sun, Jun 23, 2013 at 6:56 AM, schlange.meister
<schlange.meister@yahoo.com <mailto:schlange.meister@yahoo.com > > wrote:
That sheet is exactly what I was trying for. It worked the last weeks
and suddendly this week, it does not work on either my work or personal
laptop.
Does it still work for you? Everything except price comes back as #NA
Any advice?
expected:
Current Price 1 Week Return 1 Month Return 3
Month Return 6 Month Return 12 Month Return 2013-06-21
2013-06-14 2013-05-21 2013-03-21 2012-12-21 2012-06-21 ^GSPC
$1,592.43 -2.1% -4.6% 3.0% 11.3% 20.1% #N/A #N/A SPY $159.07 -2.0%
-4.3% 3.6% 12.5% 22.8% #N/A #N/A MMM $109.59 -1.3% -1.6% 5.0% 19.1%
29.5% #N/A #N/A IBM $195.46 -3.3% -6.3% -7.5% 2.0% 2.9% #N/A #N/A
Usually #N/A means a problem with the date for the historical quote
retrieval.
On Sun, Jun 23, 2013 at 6:56 AM, schlange.meister
<schlange.meister@
That sheet is exactly what I was trying for. It worked the last weeks
and suddendly this week, it does not work on either my work or personal
laptop.
Does it still work for you? Everything except price comes back as #NA
Any advice?
Sun Jun 23, 2013 7:17 am (PDT) . Posted by:
"handc.jones@sbcglobal.net" handc.jones@sbcglobal.net
Hi Randy:
Most of the websites do not work on my computer and I don't know how to describe the errors I receive. So for now, rather than trying to figure it out, wonder if you can give me the code for Yahoo's "Next Earnings Date" or give me instructions on how to find the code. Yahoo is the only one that seems to work on my PC.
Thanks for your help.
Henrietta
Most of the websites do not work on my computer and I don't know how to describe the errors I receive. So for now, rather than trying to figure it out, wonder if you can give me the code for Yahoo's "Next Earnings Date" or give me instructions on how to find the code. Yahoo is the only one that seems to work on my PC.
Thanks for your help.
Henrietta
Sun Jun 23, 2013 9:04 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
I recently changed the definition of element 1285 to get it from the quotes
page:
=RCHGetTableCell("http://finance.yahoo.com/q?s=MMM ",1,"Next Earnings Date:")
Yahoo wasn't consistently populating the previous web page I was extracting
it from.
Some sites like MorningStar (and IBD) require you to manually visit the
website first, preferably via the EXCEL Web Query dialog, or via IE. That's
because they do a check for an advertising redirection on your first visit
without a current security cookie. And the add-in processing doesn't
execute the web page, it just retrieves the source code, so it can't update
the IE cookies to indicate you've visited the website.
For AdvFN, an Internet Options security item may need to be set. See the
entry for it in the LINKS area of the group.
On Sun, Jun 23, 2013 at 7:17 AM, handc.jones@sbcglobal.net <
handc.jones@sbcglobal.net > wrote:
> Most of the websites do not work on my computer and I don't know how to
> describe the errors I receive. So for now, rather than trying to figure it
> out, wonder if you can give me the code for Yahoo's "Next Earnings Date" or
> give me instructions on how to find the code. Yahoo is the only one that
> seems to work on my PC.
>
page:
=RCHGetTableCell(
Yahoo wasn't consistently populating the previous web page I was extracting
it from.
Some sites like MorningStar (and IBD) require you to manually visit the
website first, preferably via the EXCEL Web Query dialog, or via IE. That's
because they do a check for an advertising redirection on your first visit
without a current security cookie. And the add-in processing doesn't
execute the web page, it just retrieves the source code, so it can't update
the IE cookies to indicate you've visited the website.
For AdvFN, an Internet Options security item may need to be set. See the
entry for it in the LINKS area of the group.
On Sun, Jun 23, 2013 at 7:17 AM, handc.jones@
handc.jones@
> Most of the websites do not work on my computer and I don't know how to
> describe the errors I receive. So for now, rather than trying to figure it
> out, wonder if you can give me the code for Yahoo's "Next Earnings Date" or
> give me instructions on how to find the code. Yahoo is the only one that
> seems to work on my PC.
>
Tidak ada komentar:
Posting Komentar