6 New Messages
Digest #2918
Messages
Mon Jan 6, 2014 10:43 am (PST) . Posted by:
confederate_yankee1965
Trying to create a spreadsheet that will give me the dividend pay dates. What RCHGetYahooHistory shows is the Ex-Dividend date, but not the pay date. Now I can get the pay date with the RCHGetYahooQuotes, but I need that data spanning the past year. Example would be the Stock symbol "O". They pay monthly, and I need to get the pay dates for the previous year. I own the stock and can go trolling through my history and get the pay date, but, that is a lot of work to do for even just 10 stocks.
I know this is likely as clear as mud, but if more info is needed, please ask.
I know this is likely as clear as mud, but if more info is needed, please ask.
Mon Jan 6, 2014 11:01 am (PST) . Posted by:
"Randy Randall" randyr_cds
Is this what you are looking for:
http://www.nasdaq.com/symbol/o/dividend-history
Randy
On Mon, Jan 6, 2014 at 1:43 PM, <cyankee65@gmail.com> wrote:
>
>
> Trying to create a spreadsheet that will give me the dividend pay dates.
> What RCHGetYahooHistory shows is the Ex-Dividend date, but not the pay
> date. Now I can get the pay date with the RCHGetYahooQuotes, but I need
> that data spanning the past year. Example would be the Stock symbol "O".
> They pay monthly, and I need to get the pay dates for the previous year. I
> own the stock and can go trolling through my history and get the pay date,
> but, that is a lot of work to do for even just 10 stocks.
>
> I know this is likely as clear as mud, but if more info is needed, please
> ask.
>
>
>
http://www.nasdaq.
Randy
On Mon, Jan 6, 2014 at 1:43 PM, <cyankee65@gmail.
>
>
> Trying to create a spreadsheet that will give me the dividend pay dates.
> What RCHGetYahooHistory shows is the Ex-Dividend date, but not the pay
> date. Now I can get the pay date with the RCHGetYahooQuotes, but I need
> that data spanning the past year. Example would be the Stock symbol "O"
> They pay monthly, and I need to get the pay dates for the previous year. I
> own the stock and can go trolling through my history and get the pay date,
> but, that is a lot of work to do for even just 10 stocks.
>
> I know this is likely as clear as mud, but if more info is needed, please
> ask.
>
>
>
Mon Jan 6, 2014 11:02 am (PST) . Posted by:
mikemcq802
I use Nasdaq's website to get recent dividend dates. They show all of them (announce, record, ex-, and pay) in a straight-forward manner. For SMF, try this:
=DATEVALUE(RCHGetTableCell("http://www.nasdaq.com/symbol/"&$B6&"/dividend-history",$Z$4,"dividendhistoryGrid",,,,2))
Where $B6 contains the ticker value
Where $Z$4 contains the number indicating the column of data to retrieve. If you look at page you'll see column 1 is the ex-date, 6=pay date, 4=declare, and 5=record.
The literal 2 on the end selects the row of the table. 2 is the first row of data (1 is the row with the headings). Change the 2 to 3 to get the second set of dividend dates and so on.
It will be clearer if you display the webpage as you read these instructions.
Oh, I wrap the RCH function in a DATEVALUE to have Excel convert the text string to a proper date (so I can perform math on it).
=DATEVALUE(RCHGetTa
Where $B6 contains the ticker value
Where $Z$4 contains the number indicating the column of data to retrieve. If you look at page you'll see column 1 is the ex-date, 6=pay date, 4=declare, and 5=record.
The literal 2 on the end selects the row of the table. 2 is the first row of data (1 is the row with the headings). Change the 2 to 3 to get the second set of dividend dates and so on.
It will be clearer if you display the webpage as you read these instructions.
Oh, I wrap the RCH function in a DATEVALUE to have Excel convert the text string to a proper date (so I can perform math on it).
Mon Jan 6, 2014 2:53 pm (PST) . Posted by:
confederate_yankee1965
That is what I am looking for, just need to pay date of the dividend. Again, yes, I could go back and manually copy the data into the spreadsheet, but that takes time. If it was just one stock, no problem, but I have 24 stocks I own. I am trying to work up an investment pattern based upon several factors and dividend history is one of them.
Mon Jan 6, 2014 2:56 pm (PST) . Posted by:
confederate_yankee1965
Ok, I am still working out how to use these functions. Didn't realize I could pull data from a table online.
Mon Jan 6, 2014 3:29 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You can also grab the whole table all at once. Just array-enter this over a
range:
=RCHGetHTMLTable("http://www.nasdaq.com/symbol/o/dividend-history","Cash
Amount",-1,"",1)
On Mon, Jan 6, 2014 at 3:56 PM, <cyankee65@gmail.com> wrote:
> Ok, I am still working out how to use these functions. Didn't realize I
> could pull data from a table online.
>
range:
=RCHGetHTMLTable(
Amount"
On Mon, Jan 6, 2014 at 3:56 PM, <cyankee65@gmail.
> Ok, I am still working out how to use these functions. Didn't realize I
> could pull data from a table online.
>
Tidak ada komentar:
Posting Komentar