7 Messages
Digest #4239
Messages
Thu Nov 16, 2017 11:28 pm (PST) . Posted by:
climbermel
I have trouble getting any info for items 35 and above.
Thanks,
Mel
Thanks,
Mel
Thu Nov 16, 2017 11:38 pm (PST) . Posted by:
a.bereziuk
Yes it works with latest version without "--".
Thu Nov 16, 2017 11:41 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Sounds like you have an older version of the add-in. Everything over 35 was
added later.
On Thu, Nov 16, 2017 at 7:47 PM, climbermel@
...
wrote:
>
> I have trouble getting any info for items 35 and above.
>
>
added later.
On Thu, Nov 16, 2017 at 7:47 PM, climbermel@
...
wrote:
>
> I have trouble getting any info for items 35 and above.
>
>
Thu Nov 16, 2017 11:45 pm (PST) . Posted by:
ridgebacksexcel
Randy,
It looks like Morningstar changed the format on the way they present upcoming dividends.
See: http://quotes.morningstar.com/stock/c-dividends?&t=vcit http://quotes.morningstar.com/stock/c-dividends?&t=vcit
They added USD in the front and of course that will mess up the lookup formatting.
I have played around trying to get it to format in the correct $ format. No luck so far.
Any ideas? I tried to use: RIGHT(RCHGetTableCell("http://quotes.morningstar.com/stock/c-dividends?&t="&$D14,1,"<tbody","Latest Indicated Dividend Amount",,,,,,""),6)
That removes the USD part but does not treat it as an actual number. Still text based. Formatting the result does not help.
It looks like Morningstar changed the format on the way they present upcoming dividends.
See: http://quotes.morningstar.com/stock/c-dividends?&t=vcit http://quotes.morningstar.com/stock/c-dividends?&t=vcit
They added USD in the front and of course that will mess up the lookup formatting.
I have played around trying to get it to format in the correct $ format. No luck so far.
Any ideas? I tried to use: RIGHT(RCHGetTableCell("http://quotes.morningstar.com/stock/c-dividends?&t="&$D14,
That removes the USD part but does not treat it as an actual number. Still text based. Formatting the result does not help.
Thu Nov 16, 2017 11:52 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=smfStrExtr(RCHGetTableCell("
http://quotes.morningstar.com/stock/c-dividends?&t="&$D14,1,"<tbody","Latest
Indicated Dividend Amount",,,,,,"")," ","~",1)
The RCHGetTableCell() extracts "USD 1.1750" from the web page, then the
smfStrExtr() extracts everything after the first blank to the end of the
string (i.e. "~"), and the final "1" parameter says to strip off any HTML
coding and convert to a number if possible.
Otherwise, you could have just put n smfConvertData() function around your
result.
On Thu, Nov 16, 2017 at 11:19 AM, tmallen2@
...
wrote:
> It looks like Morningstar changed the format on the way they present
> upcoming dividends.
>
> See: http://quotes.morningstar.com/stock/c-dividends?&t=vcit
>
> They added USD in the front and of course that will mess up the lookup
> formatting.
>
> I have played around trying to get it to format in the correct $ format.
> No luck so far.
>
> Any ideas? I tried to use: RIGHT(RCHGetTableCell("http://
> quotes.morningstar.com/stock/c-dividends?&t="&$D14,1,"<tbody","Latest
> Indicated Dividend Amount",,,,,,""),6)
>
> That removes the USD part but does not treat it as an actual number. Still
> text based. Formatting the result does not help.
>
=smfStrExtr(RCHGetTableCell("
http://quotes.morningstar.com/stock/c-dividends?&t="&$D14,1,"<tbody","Latest
Indicated Dividend Amount",,,,,,"")," ","~",1)
The RCHGetTableCell() extracts "USD 1.1750" from the web page, then the
smfStrExtr() extracts everything after the first blank to the end of the
string (i.e. "~"), and the final "1" parameter says to strip off any HTML
coding and convert to a number if possible.
Otherwise, you could have just put n smfConvertData() function around your
result.
On Thu, Nov 16, 2017 at 11:19 AM, tmallen2@
...
wrote:
> It looks like Morningstar changed the format on the way they present
> upcoming dividends.
>
> See: http://quotes.morningstar.com/stock/c-dividends?&t=vcit
>
> They added USD in the front and of course that will mess up the lookup
> formatting.
>
> I have played around trying to get it to format in the correct $ format.
> No luck so far.
>
> Any ideas? I tried to use: RIGHT(RCHGetTableCe
> quotes.morningstar.
> Indicated Dividend Amount"
>
> That removes the USD part but does not treat it as an actual number. Still
> text based. Formatting the result does not help.
>
Thu Nov 16, 2017 11:51 pm (PST) . Posted by:
nelsonmuntz1000
HI Randy
smfGetBarchartPortfolioView and smfGetYahooPortfolioView are both working great.
I believe someone already asked about second pass if duplicate tickers exist in a smfGetYahooPortfolioView array.
Have you given this any further consideration? I would find this useful in both smfGetBarchartPortfolioView and smfGetYahooPortfolioView.
Thanks so much for your work.
smfGetBarchartPortf
I believe someone already asked about second pass if duplicate tickers exist in a smfGetYahooPortfoli
Have you given this any further consideration? I would find this useful in both smfGetBarchartPortf
Thanks so much for your work.
Thu Nov 16, 2017 11:54 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Still pondering on it. So many other things that could be done... :(
On Thu, Nov 16, 2017 at 8:51 AM, ccoupe300@
...
wrote:
>
> smfGetBarchartPortfolioView and smfGetYahooPortfolioView are both working
> great.
>
> I believe someone already asked about second pass if duplicate tickers
> exist in a smfGetYahooPortfolioView array.
>
> Have you given this any further consideration? I would find this useful in
> both smfGetBarchartPortfolioView and smfGetYahooPortfolioView.
>
>
On Thu, Nov 16, 2017 at 8:51 AM, ccoupe300@
...
wrote:
>
> smfGetBarchartPortf
> great.
>
> I believe someone already asked about second pass if duplicate tickers
> exist in a smfGetYahooPortfoli
>
> Have you given this any further consideration? I would find this useful in
> both smfGetBarchartPortf
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar