2 Messages
Digest #4246
Messages
Fri Nov 24, 2017 3:59 am (PST) . Posted by:
cawley1647@rogers.com
Hi Randy,
That link to the TMX seems to return an error for me, however, even TMX is not as up to date on ex-div dates for the monthly div payers (Go figure- the TMX not as up to date on CDN stocks!).
The Financial times is more up to date. (Sheesh).
Try here:
https://markets.ft.com/data/equities/tearsheet/summary?s=ALA:TOR https://markets.ft.com/data/equities/tearsheet/summary?s=ALA:TOR
ALA is a monthly div payer and is up to date on their site, but I don't know how to extract the info to my spread sheet for the next ex date other than going in and manually doing it
Neil (near Toronto)
Thanks again for your hard work!
That link to the TMX seems to return an error for me, however, even TMX is not as up to date on ex-div dates for the monthly div payers (Go figure- the TMX not as up to date on CDN stocks!).
The Financial times is more up to date. (Sheesh).
Try here:
https://markets.ft.com/data/equities/tearsheet/summary?s=ALA:TOR https://markets.ft.com/data/equities/tearsheet/summary?s=ALA:TOR
ALA is a monthly div payer and is up to date on their site, but I don't know how to extract the info to my spread sheet for the next ex date other than going in and manually doing it
Neil (near Toronto)
Thanks again for your hard work!
Fri Nov 24, 2017 4:41 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Hmm. I just cut and past the TMX formula again, from the Yahoo group, and
it worked fine here.
For the
Financial times, try:
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/summary?s=ALA:TOR",1,">Div
ex-date")
On Fri, Nov 24, 2017 at 4:59 AM, cawley1647@
...
wrote:
> That link to the TMX seems to return an error for me, however, even TMX is
> not as up to date on ex-div dates for the *monthly* div payers (Go
> figure- the TMX not as up to date on CDN stocks!).
>
> The
>
> Financial times is more up to date. (Sheesh).
>
> Try here:
>
> https://markets.ft.com/data/equities/tearsheet/summary?s=ALA:TOR
>
> ALA is a monthly div payer and is up to date on their site, but I don't
> know how to extract the info to my spread sheet for the next ex date other
> than going in and manually doing it
>
>
>
it worked fine here.
For the
Financial times, try:
=RCHGetTableCell("
https://markets.ft.com/data/equities/tearsheet/summary?s=ALA:TOR",1,">Div
ex-date")
On Fri, Nov 24, 2017 at 4:59 AM, cawley1647@
...
wrote:
> That link to the TMX seems to return an error for me, however, even TMX is
> not as up to date on ex-div dates for the *monthly* div payers (Go
> figure- the TMX not as up to date on CDN stocks!).
>
> The
>
> Financial times is more up to date. (Sheesh).
>
> Try here:
>
> https://markets.ft.com/data/equities/tearsheet/summary?s=ALA:TOR
>
> ALA is a monthly div payer and is up to date on their site, but I don't
> know how to extract the info to my spread sheet for the next ex date other
> than going in and manually doing it
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar