Rabu, 11 April 2012

[smf_addin] Digest Number 2173

Messages In This Digest (20 Messages)

1a.
Re: dividends analysis From: chocronalberto@ymail.com
2a.
Errors with RchGetYahooQuotes From: Craig
2b.
Re: Errors with RchGetYahooQuotes From: Sudhir Agarwal
2c.
Re: Errors with RchGetYahooQuotes From: Glen Fullmer
2d.
Re: Errors with RchGetYahooQuotes From: Craig
2e.
Re: Errors with RchGetYahooQuotes From: Randy Harmelink
2f.
Re: Errors with RchGetYahooQuotes From: Craig
2g.
Re: Errors with RchGetYahooQuotes From: Randy Harmelink
2h.
Re: Errors with RchGetYahooQuotes From: Glen
2i.
Re: Errors with RchGetYahooQuotes From: Randy Harmelink
3a.
Re: Getting different data using same spreadsheet on different compu From: Randy Harmelink
4a.
Re: EPS -TTM From: Sowmy
4b.
Re: EPS -TTM From: Randy Harmelink
5.1.
New file uploaded to smf_addin From: smf_addin@yahoogroups.com
6a.
Re: London Stock Exchange - historical EPS data? From: kenyondj@ymail.com
6b.
Re: London Stock Exchange - historical EPS data? From: Randy Harmelink
7a.
Macro help From: d.sweitzer22
7b.
Re: Macro help From: Randy Harmelink
8a.
Australian data not updated in MSN Money From: John
8b.
Re: Australian data not updated in MSN Money From: Randy Harmelink

Messages

1a.

Re: dividends analysis

Posted by: "chocronalberto@ymail.com" chocronalberto@gmail.com   chocronalberto@ymail.com

Tue Apr 10, 2012 4:27 am (PDT)



Randy, thanks anyways.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Sounds like bookkeeping instead of analysis. But, no, I'm not aware of
> anything.
>
> On Mon, Apr 9, 2012 at 7:44 AM, chocronalberto@... <
> chocronalberto@...> wrote:
>
> >
> > Is there already a Dividend analysis of portfolio ?
> > I'm looking for something that will help with qualified dividends as well
> > as with non qualifies dividends, qualified dividend income (qdi), dividend
> > received deduction (drd) and tax withholdings.
> >
>

2a.

Errors with RchGetYahooQuotes

Posted by: "Craig" craig.sander@comcast.net   c1sander

Tue Apr 10, 2012 9:01 am (PDT)



I am getting a lot of "error" values returned when using RchGetYahooQuotes. This strated probably about a week ago. They seem random - sometimes it returns the right value, sometimes it returns "error". Anyone else having the same problem? Any suggested fixes?

Thanks,
Craig

2b.

Re: Errors with RchGetYahooQuotes

Posted by: "Sudhir Agarwal" Agarwal.sudhir@gmail.com   sudhir_agarwal1

Tue Apr 10, 2012 9:02 am (PDT)



I am having similar issue. In my case the data is not getting updated.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of Craig
Sent: Tuesday, April 10, 2012 12:01 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Errors with RchGetYahooQuotes

I am getting a lot of "error" values returned when using RchGetYahooQuotes.
This strated probably about a week ago. They seem random - sometimes it
returns the right value, sometimes it returns "error". Anyone else having
the same problem? Any suggested fixes?

Thanks,
Craig

2c.

Re: Errors with RchGetYahooQuotes

Posted by: "Glen Fullmer" gfullmer@centurylink.net   gfullmer

Tue Apr 10, 2012 9:53 am (PDT)



On Tue, 2012-04-10 at 12:02 -0400, Sudhir Agarwal wrote:

> I am having similar issue. In my case the data is not getting updated…

So am I having this problem and it did start last week. I am wondering
if Yahoo has been looking at the time between quote requests from the
same IP. I can go back and double click on the request field in excel
(showing the formula items) and hit return it eventually returns the
correct value, but out of 17 stocks I am requesting I am getting only 8
with the correct value. The stocks that I am requesting for quotes are
ALXN, CSC, CVS, DELL, FDX, GILD, HUM, INTC, NOK, NE, SLB, SWKS, T, TXT,
UAN, V, WDC. The ones that fail are ALXN, CSC, CVS, NOK, T, TXT, UAN,
WDC. But it changes over time and when I do a smfForceRecalculation,
but still have 5-7 which fail and they are not always the some stocks.

2d.

Re: Errors with RchGetYahooQuotes

Posted by: "Craig" craig.sander@comcast.net   c1sander

Tue Apr 10, 2012 10:24 am (PDT)



I don't think it is an issue of time between requests. If I manually recalculate the same cell (and only that cell) multiple times, it will randomly give me a good value or give me an error – even if I wait seconds between recalculations.

Craig

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Glen Fullmer
Sent: Tuesday, April 10, 2012 9:53 AM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Errors with RchGetYahooQuotes

On Tue, 2012-04-10 at 12:02 -0400, Sudhir Agarwal wrote:

> I am having similar issue. In my case the data is not getting updated…

So am I having this problem and it did start last week. I am wondering
if Yahoo has been looking at the time between quote requests from the
same IP. I can go back and double click on the request field in excel
(showing the formula items) and hit return it eventually returns the
correct value, but out of 17 stocks I am requesting I am getting only 8
with the correct value. The stocks that I am requesting for quotes are
ALXN, CSC, CVS, DELL, FDX, GILD, HUM, INTC, NOK, NE, SLB, SWKS, T, TXT,
UAN, V, WDC. The ones that fail are ALXN, CSC, CVS, NOK, T, TXT, UAN,
WDC. But it changes over time and when I do a smfForceRecalculation,
but still have 5-7 which fail and they are not always the some stocks.

2e.

Re: Errors with RchGetYahooQuotes

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Apr 10, 2012 11:02 am (PDT)



It's Yahoo having problems.

What I would suggest is to use the array-entered version of
RCHGetYahooQuotes(). Then it will be an "All or None" deal and easier to
deal with. And the updates should be a lot faster too.

On Tue, Apr 10, 2012 at 9:01 AM, Craig <craig.sander@comcast.net> wrote:

> I am getting a lot of "error" values returned when using
> RchGetYahooQuotes. This strated probably about a week ago. They seem
> random - sometimes it returns the right value, sometimes it returns
> "error". Anyone else having the same problem? Any suggested fixes?
>
2f.

Re: Errors with RchGetYahooQuotes

Posted by: "Craig" craig.sander@comcast.net   c1sander

Tue Apr 10, 2012 11:27 am (PDT)



Thanks for the reply. Unfortunately, my spreadsheet has automated functions to insert new stocks (by adding rows) that would be difficult to deal with in array mode. I've also noted that Yahoo is much slower than it used to be.

Craig

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Tuesday, April 10, 2012 11:02 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Errors with RchGetYahooQuotes

It's Yahoo having problems.

What I would suggest is to use the array-entered version of RCHGetYahooQuotes(). Then it will be an "All or None" deal and easier to deal with. And the updates should be a lot faster too.

On Tue, Apr 10, 2012 at 9:01 AM, Craig <craig.sander@comcast.net> wrote:

I am getting a lot of "error" values returned when using RchGetYahooQuotes. This strated probably about a week ago. They seem random - sometimes it returns the right value, sometimes it returns "error". Anyone else having the same problem? Any suggested fixes?

2g.

Re: Errors with RchGetYahooQuotes

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Apr 10, 2012 12:36 pm (PDT)



You can have the array-entered function input 200 ticker cells, even though
only 50 are populated with ticker symbols. Then, instead of inserting a
row, you just add it to the ticker symbol list...

But it does depend on the process...

On Tue, Apr 10, 2012 at 11:27 AM, Craig <craig.sander@comcast.net> wrote:

>
> Thanks for the reply. Unfortunately, my spreadsheet has automated
> functions to insert new stocks (by adding rows) that would be difficult to
> deal with in array mode. I've also noted that Yahoo is much slower than it
> used to be.****
>
>
>
2h.

Re: Errors with RchGetYahooQuotes

Posted by: "Glen" gfullmer@centurylink.net   gfullmer

Tue Apr 10, 2012 1:01 pm (PDT)



Just uploaded a file to show the problems I am having with RchGetYahooQuotes..... Any suggestions to fix this?

Thanks,
Glen

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> You can have the array-entered function input 200 ticker cells, even though
> only 50 are populated with ticker symbols. Then, instead of inserting a
> row, you just add it to the ticker symbol list...
>
> But it does depend on the process...
>
> On Tue, Apr 10, 2012 at 11:27 AM, Craig <craig.sander@...> wrote:
>
> >
> > Thanks for the reply. Unfortunately, my spreadsheet has automated
> > functions to insert new stocks (by adding rows) that would be difficult to
> > deal with in array mode. I’ve also noted that Yahoo is much slower than it
> > used to be.****
> >
> >
> >
>

2i.

Re: Errors with RchGetYahooQuotes

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Apr 10, 2012 1:14 pm (PDT)



Your workbook took a long time to recalculate when I opened it. I'm
thinking the "Error" results are "time outs" when accessing Yahoo --
probably one of their servers has a problem.

Again, I would suggest putting ALL of your quote retrievals in a single
worksheet, as an array-entered formula. Then, at least the "Error" result
is an "All or Nothing" type problem. Which is easy to fix with an
smfForceRecalculation.

For example, your formula:

=IF(RCHGetYahooQuotes(Stock,"a")="N/A",RCHGetYahooQuotes(Stock,"l1"),RCHGetYahooQuotes(Stock,"a"))

...requires TWO internet access to get a single quote. And you do it for
both the bid and the ask.

On Tue, Apr 10, 2012 at 9:01 AM, Craig <craig.sander@comcast.net> wrote:

> I am getting a lot of "error" values returned when using
> RchGetYahooQuotes. This strated probably about a week ago. They seem
> random - sometimes it returns the right value, sometimes it returns
> "error". Anyone else having the same problem? Any suggested fixes?
>
3a.

Re: Getting different data using same spreadsheet on different compu

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Apr 10, 2012 11:04 am (PDT)



My first suspicion is that you're having location errors (see entry in
"Links" area of the group).

Have you checked your Internet Options (also see "Links" area of the group)?

Reinstall shouldn't make a difference.

On Mon, Apr 9, 2012 at 11:57 AM, kkkutty <kkkutty@yahoo.com> wrote:

>
> I'm using a spreadsheet to track about 15 stocks which I copy to view on
> two different computers. I get the data from ADVFN and for 2 out of the 15
> tickers when I try to retrieve, for example, element 8006 (Quarterly ending
> date), on one computer it shows up as 2011/12 (the correct date) and the
> other computer it shows up as 2008/06. In other words, for 2 out of the 15
> stocks I'm tracking, I'm retrieving old data on one computer and the
> correctly updated data on a different computer even though it's from the
> same spreadsheet. Any ideas as to why this is happening and how I can fix
> it. When I go to the website, I don't have any problem viewing the
> correctly updated data. Do I need to reinstall the add-in for one
> computer? Thank you very much in advance.
>
4a.

Re: EPS -TTM

Posted by: "Sowmy" sowmy.aura@yahoo.com   sowmy.aura

Tue Apr 10, 2012 12:00 pm (PDT)



Thanks..that is great...another silly question ..how do I get excel to replace the symbol with the value in a particular cell (say $J3)?

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> For an American company, it's on this page:
>
> http://www.reuters.com/finance/stocks/overview?symbol=MMM
>
> You'd need to use the RCHGetTableCell() function to pull it:
>
> =RCHGetTableCell("http://www.reuters.com/finance/stocks/overview?symbol=MMM",1,"EPS
> (TTM):")
>
> On Mon, Apr 2, 2012 at 9:52 AM, Sowmy <sowmy.aura@...> wrote:
>
> >
> > Since I am analyzing Indian stocks, the only data source that I can use
> > with the RCHgetelementnumber() function is 'Reuters'. I was wondering if
> > there was a way to figure out EPS for the TTM using Reuters and the
> > RCHgetelementnumber() function. I was only able to find EPS-TTM vs TTM one
> > year ago...can you help please?
> >
>

4b.

Re: EPS -TTM

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Apr 10, 2012 12:37 pm (PDT)



Ordinary EXCEL string concatenation:

"http://www.reuters.com/finance/stocks/overview?symbol="&$J3

On Tue, Apr 10, 2012 at 12:00 PM, Sowmy <sowmy.aura@yahoo.com> wrote:

> Thanks..that is great...another silly question ..how do I get excel to
> replace the symbol with the value in a particular cell (say $J3)?
>
5.1.

New file uploaded to smf_addin

Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com

Tue Apr 10, 2012 12:58 pm (PDT)




Hello,

This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.

File : /Uploads by forum members/RPMTrading.xlsx
Uploaded by : gfullmer <gfullmer@centurylink.net>
Description : Radio Active trading spreadsheet - Posted to show getYahooQuote error for stock bid and ask prices.

You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/Uploads%20by%20forum%20members/RPMTrading.xlsx

To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,

gfullmer <gfullmer@centurylink.net>


6a.

Re: London Stock Exchange - historical EPS data?

Posted by: "kenyondj@ymail.com" kenyondj@ymail.com   kenyondj@ymail.com

Tue Apr 10, 2012 1:44 pm (PDT)



Hi Randy

I'm afraid that I'm still struggling.

=smfGetAdvFNElement("LSE:PDL","A",1,">Year End Date<") for example returns an error but I can get to the Financials webpage for LSE:PDL.

Am I missing something obvious?

Thanks

DK

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I think you just have to use the appropriate prefix on the ticker symbols
> for London stocks on AdvFN.
>
> On Fri, Apr 6, 2012 at 12:24 PM, kenyondj@... <kenyondj@...>wrote:
>
> >
> > I'm trying to build a worksheet with historical EPS data (the last 8
> > quarterlies and the last 4 annual).
> >
> > I can do this using the smfGetADVFNElement function for US based stocks.
> > I'm more interested in stocks listed on the London Exchange. From having
> > a quick play on the ADVFN website I can't find UK stocks.
> >
> > Is there a way to download the UK EPS data?
> >
>

6b.

Re: London Stock Exchange - historical EPS data?

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Apr 10, 2012 2:09 pm (PDT)



I don't see any quarterly or annual financial data web pages for LSE:PDL?

On Tue, Apr 10, 2012 at 1:44 PM, kenyondj@ymail.com <kenyondj@ymail.com>wrote:

>
> I'm afraid that I'm still struggling.
>
> =smfGetAdvFNElement("LSE:PDL","A",1,">Year End Date<") for example returns
> an error but I can get to the Financials webpage for LSE:PDL.
>
> Am I missing something obvious?
>
7a.

Macro help

Posted by: "d.sweitzer22" d.sweitzer22@yahoo.com   d.sweitzer22

Tue Apr 10, 2012 1:56 pm (PDT)



Hey, I am new to VBA and I am trying to write a macro using your getyahoohistory function. What I have now is a column starting in A7 with ticker symbols and then the date I want in an array with the year(in N14), month(in O14), and day(in P14). What I am trying to do is have the have the column starting at C7 display the closing price for each ticker at the set date, without it putting the function itself in the cell. Right now I can get the number but it changes that cell into the function instead of just displaying the number.

The parameters of the function im using are:

=RCHGetYahooHistory(A7,N14,O14,P14,N14,O14,P14,"d","C",0,0,0)

for the first ticker.

If anyone has any spare time I would greatly appreciate any help.

Thanks in advance.

7b.

Re: Macro help

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Apr 10, 2012 2:12 pm (PDT)



Please tell me you're not retrieving historical data one day at a time?

You should post your macro code so people have some idea of what you have
already.

On Tue, Apr 10, 2012 at 1:56 PM, d.sweitzer22 <d.sweitzer22@yahoo.com>wrote:

> Hey, I am new to VBA and I am trying to write a macro using your
> getyahoohistory function. What I have now is a column starting in A7 with
> ticker symbols and then the date I want in an array with the year(in N14),
> month(in O14), and day(in P14). What I am trying to do is have the have the
> column starting at C7 display the closing price for each ticker at the set
> date, without it putting the function itself in the cell. Right now I can
> get the number but it changes that cell into the function instead of just
> displaying the number.
>
> The parameters of the function im using are:
>
> =RCHGetYahooHistory(A7,N14,O14,P14,N14,O14,P14,"d","C",0,0,0)
>
> for the first ticker.
>
> If anyone has any spare time I would greatly appreciate any help.
>
8a.

Australian data not updated in MSN Money

Posted by: "John" jfp1008@yahoo.com   jfp1008

Tue Apr 10, 2012 6:50 pm (PDT)



Hello Randy:

Since 3/29/2012 Australian data has not been updated on MSN Money.

For example, see the 10-day price chart for AU:MIN --

http://investing.money.msn.com/investments/charts?symbol=au:min#all=on&period=10d&interactive=on&symbol=au:min

It shows $12.03 on March 29 and nothing since.

Any thoughts?

John

8b.

Re: Australian data not updated in MSN Money

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Tue Apr 10, 2012 6:52 pm (PDT)



Sounds like a question for MSN...

On Tue, Apr 10, 2012 at 6:43 PM, John <jfp1008@yahoo.com> wrote:

>
> Since 3/29/2012 Australian data has not been updated on MSN Money.
>
> For example, see the 10-day price chart for AU:MIN --
>
>
> http://investing.money.msn.com/investments/charts?symbol=au:min#all=on&period=10d&interactive=on&symbol=au:min
>
> It shows $12.03 on March 29 and nothing since.
>
> Any thoughts?
>
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need traffic?

Drive customers

With search ads

on Yahoo!

Yahoo! News

Get it all here

Breaking news to

entertainment news

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web

Tidak ada komentar:

Posting Komentar