Messages In This Digest (22 Messages)
- 1a.
- Re: getyahhooquotes dividend code d From: dguillett1
- 1b.
- Re: getyahhooquotes dividend code d From: charles
- 1c.
- Re: getyahhooquotes dividend code d From: Randy Harmelink
- 1d.
- Re: getyahhooquotes dividend code d From: Austin Tran
- 1e.
- Re: getyahhooquotes dividend code d From: Randy Harmelink
- 1f.
- cell range problem From: Austin Tran
- 1g.
- Re: cell range problem From: Randy Harmelink
- 2a.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: smortonm
- 2b.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: Randy Harmelink
- 2c.
- Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11 From: chaim422
- 3a.
- Problem with excel From: tim.wisniewski
- 3b.
- Re: Problem with excel From: Glen Fullmer
- 4a.
- MACD From: high_winger
- 4b.
- MACD From: high_winger
- 4c.
- Re: MACD From: Glen Fullmer
- 4d.
- Re: MACD From: Bill Durrance
- 5a.
- About industry data using RCHGetElementNumber From: Amir
- 5b.
- Re: About industry data using RCHGetElementNumber From: Randy Harmelink
- 6a.
- Re: Latest stock headline From: chaim422
- 6b.
- Re: Latest stock headline From: Randy Harmelink
- 7a.
- restated Financial Data From: alexander
- 7b.
- Re: restated Financial Data From: Randy Harmelink
Messages
- 1a.
-
Re: getyahhooquotes dividend code d
Posted by: "dguillett1" dguillett1@gmail.com donaldb36
Thu Jul 21, 2011 5:04 am (PDT)
To get the forward dividend you cannot use the yahoo tags, ie: "d". You would need to use another method such as an external query.
From: Randy Harmelink
Sent: Wednesday, July 20, 2011 6:32 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] getyahhooquotes dividend code d
Your complaint should be directed to Yahoo -- the add-in is just giving you what Yahoo is sending. What you are seeing is how Yahoo (or their data provider) chose to handle the spinoff's affect on the data. The ex-dividend and payable dates are for the spinoff -- the most recent distribution on the stock.
On Wed, Jul 20, 2011 at 4:20 PM, chj.2010 <chasjohn02@yahoo.com > wrote:
Hello all - Am trying to pull dividend data using the smf_addin symbols.
The following is extracted from an Excel worksheet.
l1 t8 d r1 q e7 e8
Tick1 Price Target Div Pay Ex EPS11 EPS12
MRO 31.03 40.78 21.70 Jun 10 Jul 1 4.28 4.13
The d symbol is giving the trailing dividend yield, not the actual dividend. The dividend dates also appear to be incorrect.
Yahoo statistics for MRO (Marathon Oil)
Dividends & Splits
Forward Annual Dividend Rate4: 1.00
Forward Annual Dividend Yield4: 3.20%
Trailing Annual Dividend Yield3: 21.70
Trailing Annual Dividend Yield3: 69.50%
5 Year Average Dividend Yield4: N/A
Payout Ratio4: 23.00%
Dividend Date3: Jun 9, 2011
Ex-Dividend Date4: May 16, 2011
- 1b.
-
Re: getyahhooquotes dividend code d
Posted by: "charles" chasjohn02@yahoo.com chasjohn02
Thu Jul 21, 2011 8:08 am (PDT)
Randy - This wasn't intended to be a complaint - just a query. I downloaded a template that you created; inserted the d symbol and found it didn't grab the dividend data. The template uses an array formula. I went to GetElementNumber and got the correct dividend data but found that GetElementNumber can't be used in an array formula. In no way am I complaining about a great, free, downloadable, utility.
Thanks!
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Your complaint should be directed to Yahoo -- the add-in is just giving you
> what Yahoo is sending. What you are seeing is how Yahoo (or their data
> provider) chose to handle the spinoff's affect on the data. The ex-dividend
> and payable dates are for the spinoff -- the most recent distribution on the
> stock.
>
> On Wed, Jul 20, 2011 at 4:20 PM, chj.2010 <chasjohn02@...> wrote:
>
> > Hello all - Am trying to pull dividend data using the smf_addin symbols.
> > The following is extracted from an Excel worksheet.
> > l1 t8 d r1 q e7 e8
> > Tick1 Price Target Div Pay Ex EPS11 EPS12
> > MRO 31.03 40.78 21.70 Jun 10 Jul 1 4.28 4.13
> >
> > The d symbol is giving the trailing dividend yield, not the actual
> > dividend. The dividend dates also appear to be incorrect.
> >
> > Yahoo statistics for MRO (Marathon Oil)
> > Dividends & Splits
> > Forward Annual Dividend Rate4: 1.00
> > Forward Annual Dividend Yield4: 3.20%
> > Trailing Annual Dividend Yield3: 21.70
> > Trailing Annual Dividend Yield3: 69.50%
> > 5 Year Average Dividend Yield4: N/A
> > Payout Ratio4: 23.00%
> > Dividend Date3: Jun 9, 2011
> > Ex-Dividend Date4: May 16, 2011
> >
>
- 1c.
-
Re: getyahhooquotes dividend code d
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jul 21, 2011 9:09 am (PDT)
There's no point in doing RCHGetElementNumber() in an array formula -- it
would still take just as long to get the data, since each item would still
have to be retrieved individually. So it's just as efficient to use
individual cell formulas, without adding the disadvantages of an
array-entered formula (e.g. sorting, modifying). The reason
RCHGetYahooQuotes() is designed as an array-entered function is that Yahoo
can provide a CSV file with numerous data items in a single Internet access,
which saves time. That's true of most of the array-entered functions.
My comment about the complaint was just meant that if there are data issues,
they need to be handled by Yahoo. I have used their feedback process myself
to complain about things. For example, the dropping of option quotes from
their CSV process (not that it helped any).
On Thu, Jul 21, 2011 at 8:08 AM, charles <chasjohn02@yahoo.com > wrote:
> Randy - This wasn't intended to be a complaint - just a query. I downloaded
> a template that you created; inserted the d symbol and found it didn't grab
> the dividend data. The template uses an array formula. I went to
> GetElementNumber and got the correct dividend data but found that
> GetElementNumber can't be used in an array formula. In no way am I
> complaining about a great, free, downloadable, utility.
>
- 1d.
-
Re: getyahhooquotes dividend code d
Posted by: "Austin Tran" austin_tran92@yahoo.com austin_tran92
Thu Jul 21, 2011 9:36 am (PDT)
Hey guys, sorry if I ask a nooby question but I was wondering on how I could get an infinite cell range. I would like to get data from all the way into the past that YHOO finance has.
I tried figuring it out but I kept getting #VALUE!
However, when I choose 7 columns and a set number of rows, it loads the values just fine. Is there anyway to get Excel to define the cell range for me automatically by using the "Date" value? I can't figure out how to set the row #s to a variable. Stocks like LNKD and AAPL will have different amount of rows needed.
If anyone can help me, I'd deeply appreciate it. Thanks. - 1e.
-
Re: getyahhooquotes dividend code d
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jul 21, 2011 9:41 am (PDT)
Please start a new thread when you start a new topic -- it appears you are
asking questions about a different function: RCHGetYahooHistory().
The function can only return data to the range you array-enter the formula
over, so nothing can be done automatically. However, you could write your
own VBA routine that customizes the output. If you specify too large a
range, it blank fills the excess, so I'm not sure why there would be an
issue?
Also, #VALUE! would normally mean you specified an incorrect parameter -- an
integer where a string was expected, for example.
On Thu, Jul 21, 2011 at 9:28 AM, Austin Tran <austin_tran92@yahoo.com >wrote:
>
> Hey guys, sorry if I ask a nooby question but I was wondering on how I
> could get an infinite cell range. I would like to get data from all the way
> into the past that YHOO finance has.
>
> I tried figuring it out but I kept getting #VALUE!
>
> However, when I choose 7 columns and a set number of rows, it loads the
> values just fine. Is there anyway to get Excel to define the cell range for
> me automatically by using the "Date" value? I can't figure out how to set
> the row #s to a variable. Stocks like LNKD and AAPL will have different
> amount of rows needed.
>
> If anyone can help me, I'd deeply appreciate it. Thanks.
>
- 1f.
-
cell range problem
Posted by: "Austin Tran" austin_tran92@yahoo.com austin_tran92
Thu Jul 21, 2011 10:45 am (PDT)
Hey sorry about not starting a new topic. Yea I assumed that it would blank fill the excess but it doesnt and gives me an error. I was looking through the source code and found that it gets the data from a .csv file.
Is there anyway to get =rchgetyahoohistory to just dump the entire .csv file without defining the cell range?
--- On Thu, 7/21/11, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] Re: getyahhooquotes dividend code d
To: smf_addin@yahoogroups.com
Date: Thursday, July 21, 2011, 12:40 PM
Please start a new thread when you start a new topic -- it appears you are asking questions about a different function: RCHGetYahooHistory().
The function can only return data to the range you array-enter the formula over, so nothing can be done automatically. However, you could write your own VBA routine that customizes the output. If you specify too large a range, it blank fills the excess, so I'm not sure why there would be an issue?
Also, #VALUE! would normally mean you specified an incorrect parameter -- an integer where a string was expected, for example.
On Thu, Jul 21, 2011 at 9:28 AM, Austin Tran <austin_tran92@yahoo.com > wrote:
Hey guys, sorry if I ask a nooby question but I was wondering on how I could get an infinite cell range. I would like to get data from all the way into the past that YHOO finance has.
I tried figuring it out but I kept getting #VALUE!
However, when I choose 7 columns and a set number of rows, it loads the values just fine. Is there anyway to get Excel to define the cell range for me automatically by using the "Date" value? I can't figure out how to set the row #s to a variable. Stocks like LNKD and AAPL will have different amount of rows needed.
If anyone can help me, I'd deeply appreciate it. Thanks.
- 1g.
-
Re: cell range problem
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jul 21, 2011 12:45 pm (PDT)
What parameters are you using with the formula that gives you an error? I
can't see how you can get an error without miscoding the parameters. I've
only seen it once in the past, when Yahoo had bad data.
The only way to do it without defining a cell range is to code your own VBA.
Functions can only return data to cells/ranges that they have been given
access to, which is why they need to be array-entered when a range of data
is returned. So the range MUST be predefined for a function.
On Thu, Jul 21, 2011 at 10:45 AM, Austin Tran <austin_tran92@yahoo.com >wrote:
>
> Hey sorry about not starting a new topic. Yea I assumed that it would blank
> fill the excess but it doesnt and gives me an error. I was looking through
> the source code and found that it gets the data from a .csv file.
>
> Is there anyway to get =rchgetyahoohistory to just dump the entire .csv
> file without defining the cell range?
>
- 2a.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "smortonm" smmarder@yahoo.com smortonm
Thu Jul 21, 2011 6:35 am (PDT)
Just wondering: Since the Yahoo Quote issue arose, I noticed that my
main spreadsheet has taken a VERY long time to open. I'm talking 20
minutes or so. This SS has hundreds of quote downloads.. Is anyone else
experiencing this, and is there any ideas on how to speed it up??
Thanks
Sid
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...>
wrote:
>
> You could try:
>
> =0+smfGetTagContent("
> http://investing.money.msn. com/investments/ etf-list/ ?symbol=
> "&Ticker,"span",-1,"'Last' ")
>
> ...but I'm not sure how reliable the search string is.
>
> On Wed, Jul 20, 2011 at 5:35 PM, sihlai sihlai@... wrote:
>
> > Is there another solution to obtaining quotes from MSN for ETF?
> >
>
- 2b.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jul 21, 2011 9:04 am (PDT)
Are those hundreds of quote downloads in a single array-entered formula or
individual formulas in each cell? The latter can take a bit longer,
especially if Yahoo is lagging. Maybe the "bad server" is timing out and
returning the bogus info -- that could really extend the time it takes to
get quotes...
On Thu, Jul 21, 2011 at 6:35 AM, smortonm <smmarder@yahoo.com > wrote:
> Just wondering: Since the Yahoo Quote issue arose, I noticed that my
> main spreadsheet has taken a VERY long time to open. I'm talking 20
> minutes or so. This SS has hundreds of quote downloads.. Is anyone else
> experiencing this, and is there any ideas on how to speed it up??
>
- 2c.
-
Re: RCHGetYahooQuotes erratic behavior beginning Fri, 7/15/11
Posted by: "chaim422" chaim422@gmail.com chaim422
Thu Jul 21, 2011 1:51 pm (PDT)
What is another good site for international stocks?
- 3a.
-
Problem with excel
Posted by: "tim.wisniewski" twiztidfreaksho2@hotmail.com tim.wisniewski
Thu Jul 21, 2011 11:14 am (PDT)
I got some clarification on the issue and tried alot of the fixes that were posted before but they have not fixed the issue. The problem is listed below.
Works fine on 2007 Excel - Only fails on 2010 Excel. Cells show #VALUE?. Original spreadsheet is located on a network share and is opened by everyone except the administrator in read-only mode.
- 3b.
-
Re: Problem with excel
Posted by: "Glen Fullmer" gfullmer@cox.net gfullmer
Thu Jul 21, 2011 12:17 pm (PDT)
Hi Tim,
As per your ###### data, I got the same today for the first time and
expanded the field and got something over $300 million that was bigger
than the ask that was what I was requesting for 6.50 (on an option).
Also I have got a couple of #Value even with the execution of the
smfForceRecalculation macro according to the documentation. I noticed
these (##### and #VALUE) happens when my computer is very busy. I have
a video conference, and two real time quotes from two brokerages,
although I am not sure if that is related. I just execute the
smfForceRecalculation macro a number of times until all fields clear.
Tedious, I know but eventually all clear. I am using Excel 2007.
Glen
On Thu, 2011-07-21 at 18:14 +0000, tim.wisniewski wrote:
> I got some clarification on the issue and tried alot of the fixes that
> were posted before but they have not fixed the issue. The problem is
> listed below.
> Works fine on 2007 Excel - Only fails on 2010 Excel. Cells show
> #VALUE?. Original spreadsheet is located on a network share and is
> opened by everyone except the administrator in read-only mode.
>
>
>
>
>
- 4a.
-
MACD
Posted by: "high_winger" high_winger@yahoo.com high_winger
Thu Jul 21, 2011 1:05 pm (PDT)
Anyone know where to find downloadable MACD data? Several sites plot the data, but I can't locate one that provides the data so it can be read in by smf.
- 4b.
-
MACD
Posted by: "high_winger" high_winger@yahoo.com high_winger
Thu Jul 21, 2011 1:24 pm (PDT)
Found it
- 4c.
-
Re: MACD
Posted by: "Glen Fullmer" gfullmer@cox.net gfullmer
Thu Jul 21, 2011 1:34 pm (PDT)
On Thu, 2011-07-21 at 20:24 +0000, high_winger wrote:
>
> Found it
Where?
- 4d.
-
Re: MACD
Posted by: "Bill Durrance" high_winger@yahoo.com high_winger
Thu Jul 21, 2011 1:56 pm (PDT)
I searched in RCHGetElementNumber-Element- Definitions. xls for MACD. I've found a couple outputs, so far that differ in what they report.
From: Glen Fullmer <gfullmer@cox.net >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, July 21, 2011 4:34 PM
>Subject: Re: [smf_addin] MACD
>
>
>
>On Thu, 2011-07-21 at 20:24 +0000, high_winger wrote:
>>
>> Found it
>
>Where?
>
>
>
>
>
- 5a.
-
About industry data using RCHGetElementNumber
Posted by: "Amir" amir.rehman@yahoo.com amir.rehman
Thu Jul 21, 2011 1:11 pm (PDT)
Hi,
I have searched the RCH element numbers for industry information but can't find for these values. Please help!
Earning / Share
Book Value / Share
Free Cash Flows (from morningstar)
Thanks,
Amir
- 5b.
-
Re: About industry data using RCHGetElementNumber
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jul 21, 2011 1:41 pm (PDT)
Looks like you'll need to use the RCHGetTableCell() function to retrieve
them from a page like:
http://quicktake.morningstar. com/stocknet/ printreport. aspx?symbol= MMM
...because Morningstar has changed some of their web page presentations. For
example:
=RCHGetTableCell("
http://quicktake.morningstar. ",2,">Price/com/stocknet/ printreport. aspx?symbol= MMM Cash
Flow")
On Thu, Jul 21, 2011 at 1:11 PM, Amir <amir.rehman@yahoo.com > wrote:
>
> I have searched the RCH element numbers for industry information but can't
> find for these values. Please help!
>
> Earning / Share
> Book Value / Share
> Free Cash Flows (from morningstar)
>
- 6a.
-
Re: Latest stock headline
Posted by: "chaim422" chaim422@gmail.com chaim422
Thu Jul 21, 2011 1:58 pm (PDT)
Thanks Randy. It works. I'm using smfGetTagContent to get the news from Yahoo. Is there a way to get the time and date for the news item?
BTW, I'm using
=smfGetTagContent("http://finance. yahoo.com/ ","a",1,"Press Release")q?s=BAC
and
=smfGetTagContent("http://finance. yahoo.com/ ","a",1,"Filter Headlines")q?s=BAC
Thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The table cell came up as empty because the entire table cell is a link tag
> -- and the add-in removes all HTML tag data in the table cell before
> returning the remaining data in the cell. Instead, try something like:
>
> =smfGetTagContent("
> http://www.advfn.com/company- news-TSE/ Bioexx-Specialty -Proteins- BXI.html
> ","a",1,">Source")
>
> On Tue, Jul 19, 2011 at 5:35 PM, chaim422 <chaim422@...> wrote:
>
> >
> > I've been trying to import the latest headline from either Yahoo Finance
> > or ADVFN
> > (http://www.advfn.com/company- > > l) using RCHGetTableCell(news-TSE/ Bioexx-Specialty -Proteins- BXI.htm\
) but came up empty. Is there a way?
> >
>
- 6b.
-
Re: Latest stock headline
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu Jul 21, 2011 2:10 pm (PDT)
Just look for the first "span" tag instead:
=smfGetTagContent("http://finance. yahoo.com/ ","span",1,"q?s=BAC Press
Release")
=smfGetTagContent("http://finance. yahoo.com/ ","span",1,"q?s=BAC Filter
Headlines")
On Thu, Jul 21, 2011 at 1:58 PM, chaim422 <chaim422@gmail.com > wrote:
>
> Thanks Randy. It works. I'm using smfGetTagContent to get the news from
> Yahoo. Is there a way to get the time and date for the news item?
>
> BTW, I'm using
> =smfGetTagContent("http://finance. yahoo.com/ ","a",1,"Pressq?s=BAC
> Release")
> and
> =smfGetTagContent("http://finance. yahoo.com/ ","a",1,"Filterq?s=BAC
> Headlines")
>
- 7a.
-
restated Financial Data
Posted by: "alexander" life2539@yahoo.com life2539
Fri Jul 22, 2011 2:23 am (PDT)
I have been looking for restated financial data that is available on the net that can be used for smf-addin but unfortunately have not found any. Has anyone found any financials of this sort? I would like to know.
Thanks,
- 7b.
-
Re: restated Financial Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Fri Jul 22, 2011 2:39 am (PDT)
As far as I know, most of the data sources present the restated financials
if they are available. I've seen headings on a column that indicated the
data is restated...
On Fri, Jul 22, 2011 at 2:23 AM, alexander <life2539@yahoo.com > wrote:
> I have been looking for restated financial data that is available on the
> net that can be used for smf-addin but unfortunately have not found any. Has
> anyone found any financials of this sort? I would like to know.
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar