Kamis, 13 Februari 2014

[smf_addin] Digest Number 2965

11 New Messages

Digest #2965

Messages

Wed Feb 12, 2014 7:05 pm (PST) . Posted by:

mikemcq802

Adding on to tc_nyc85's comment, Yahoo's dividends are listed by their ex-div date.
While it is a convenient function (I use it myself sometimes), the Nasdaq table lists each of the key dividend dates in case you want it by, say, payment or announce date instead.

Wed Feb 12, 2014 7:15 pm (PST) . Posted by:

"Marc ." whichwaytobeach

Not sure why this thread comment helps...

To: smf_addin@yahoogroups.com
From: mikemcq802@yahoo.com
Date: Wed, 12 Feb 2014 18:54:11 -0800
Subject: [smf_addin] RE: Want to Make Dividend Histogram

See Randy and my comments in this thread:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/topics/24929

Wed Feb 12, 2014 7:20 pm (PST) . Posted by:

"Marc ." whichwaytobeach

I am not understanding you, sorry.
Can I just put in =rchgetyahoohistory("ticker",,,,,,,"v"), where "ticker" in my case is C3, and I will get the annual dividends over the last 10 years? I don't know what is an array or how to do it.
Regards,
Marc
From: thomas.m.carnevale@gmail.com
To: smf_addin@yahoogroups.com
Date: Wed, 12 Feb 2014 18:50:36 -0800
Subject: [smf_addin] RE: Want to Make Dividend Histogram

What I use to get dividend history is the RCHgetyahoohistory function (which when entered as an array gets you the dividend history). The syntax is as follows =rchgetyahoohistory("ticker",,,,,,,"v"). Make sure you include the V, that's what tells it you want the dividend history).

Wed Feb 12, 2014 7:20 pm (PST) . Posted by:

mikemcq802

Because we describe how to retrieve dividend history. Once you have that you can chart it any way you like.

You can also use the RCHGetYahooHistory function as already described. I think the Yahoo history goes back further than Nasdaq - you'll have to look into that if you want lots of history.

Wed Feb 12, 2014 7:30 pm (PST) . Posted by:

"Marc ." whichwaytobeach

I guess it's beyond simple then...
When I do the RCHGetYahooHistory function I simply get back the word "Date". Does someone have dividend history for 10 years in their Excel spreadsheet (just that piece) that they can send me?
Thanks,
Marc

To: smf_addin@yahoogroups.com
From: mikemcq802@yahoo.com
Date: Wed, 12 Feb 2014 19:20:10 -0800
Subject: [smf_addin] RE: Want to Make Dividend Histogram

Because we describe how to retrieve dividend history. Once you have that you can chart it any way you like.

You can also use the RCHGetYahooHistory function as already described. I think the Yahoo history goes back further than Nasdaq - you'll have to look into that if you want lots of history.

Wed Feb 12, 2014 7:38 pm (PST) . Posted by:

mikemcq802

You just need to enter it as an array formula. Search the conversations, see the help, or Google excel and array formula. It's well covered.
A specific example for Yahoo dividend history is in the Files / Templates section of this group. See SMF-Template-Yahoo-Historical-Quotes.xls. It is setup for pricing. To get dividends the trick is to put a "V" in the "period" box. You can blank out the "items" flags.

Wed Feb 12, 2014 7:41 pm (PST) . Posted by:

tc_nyc85

The "date" value is just one value in the array. Select an array of cells that's 2 columns by 15 rows. Hit F2 and type in =rchgetyahoohistory("aapl";,,,,,,,"v") (entering the ticker you want) and then hit control shift enter. You can also put the ticker in a cell so it's easy to change. The date by default will be formatted as a number, you should format it as a date.

Wed Feb 12, 2014 7:57 pm (PST) . Posted by:

elderbands

Am I in the group? How do I make a Dividend Histogram On NYCB?
Thank you,
elderbands@aol.com

Wed Feb 12, 2014 11:15 pm (PST) . Posted by:

"Nikola Ganev" ganevniko

Thank you Randy, it worked fine, it was a mistake with the array, now I get exactly what I want

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, February 13, 2014 12:53 AM
Subject: Re: [smf_addin] Getting S&P500 components

 
I don't get the symptoms you describe when I use the formula. It opens it clean right away, and updates any time I open the workbook, or run the smfForceRecalculation macro. To double-check, I just cut and pasted the formula that was repeated in your message, and it worked fine here.

For example, the first few rows and first few columns look like this:

Holdings
Weighting
Type
Ticker
Style
Apple Inc 2.96 EQUITY AAPL Large Core
Exxon Mobil Corporation 2.43 EQUITY XOM Large Value
Google, Inc. Class A 2.05 EQUITY GOOG Large Growth
Microsoft Corporation 1.74 EQUITY MSFT Large Core
Johnson & Johnson 1.6 EQUITY JNJ Large Value
Did you array-enter it over a range?

On Wed, Feb 12, 2014 at 3:07 PM, Nikola Ganev <ganevniko@yahoo.com> wrote:

>
>Thank you Randy but this link opens a new window with the csv file and all the data is in the first column I need to convert it manually, is there not a way to get it clean right away and be able to update it every time I want ?
>
>
>
>From: Randy Harmelink <rharmelink@gmail.com>
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, February 12, 2014 10:44 PM
>Subject: Re: [smf_addin] Getting S&P500 components
>
> 
>Which function to use would depend on your data source. For my own use, I usually just grab the components of the ETF that is supposed to match the index. For example:
>
>=smfGetCSVFile("http://portfolios.morningstar.com/fund/holdingsExport?exportType=details&t=SPY")
>

Thu Feb 13, 2014 12:27 am (PST) . Posted by:

matthewpaulreid

That is exactly right Cris, thanks for clarifying! They are awesome, automated spreadsheets, but the data sources seem to have changed. I would definitely be interested as well if anyone has taken the time to do this already! It would be greatly appreciated!!!

Thanks,
Matt

Thu Feb 13, 2014 12:33 am (PST) . Posted by:

matthewpaulreid

Where is this macro? which folder? for some reason i could not find it...
Diposting oleh EXCEL FEED LEARNING di 00.35

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)