3 Messages
Digest #4265
Messages
Thu Dec 14, 2017 2:13 am (PST) . Posted by:
a.bereziuk
Thanks, but at GuruFocus I cannot access any values even after I have registered with Google... They require 7 day trial.
I have found dividend frequency at tmxmoney.com. Hope I can extract it from there.
I have found dividend frequency at tmxmoney.com. Hope I can extract it from there.
Thu Dec 14, 2017 2:32 am (PST) . Posted by:
a.bereziuk
If I put in every cell a function with reference to one cell, then it works like you have written:
=smfGetYahooPortfolioView($A1;"15") (A1=>MMM)
=smfGetYahooPortfolioView($A2;"15") (A2=>IBM)
=smfGetYahooPortfolioView($A3;"15") (A3=>SPY)
But if I put a range in every cell:
=smfGetYahooPortfolioView(A1:A3;"15") then I get a quote for A1 in all 3 cells.
=smfGetYahooPortfol
=smfGetYahooPortfol
=smfGetYahooPortfol
But if I put a range in every cell:
=smfGetYahooPortfol
Thu Dec 14, 2017 4:09 am (PST) . Posted by:
"Randy Harmelink" rharmelink
It has to be array-entered over the 3-row by 1-column range.
You don't want to do the three individual functions, as each would need to
go to the Internet to get the data.
On Thu, Dec 14, 2017 at 3:32 AM, a.bereziuk@yahoo.de [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> If I put in every cell a function with reference to one cell, then it
> works like you have written:
>
> =smfGetYahooPortfolioView($A1;"15") (A1=>MMM)
> =smfGetYahooPortfolioView($A2;
> <https://maps.google.com/?q=A2;%2215%22)+%C2%A0+(A2&entry=gmail&source=g>"
> 15
> <https://maps.google.com/?q=A2;%2215%22)+%C2%A0+(A2&entry=gmail&source=g>")
> <https://maps.google.com/?q=A2;%2215%22)+%C2%A0+(A2&entry=gmail&source=g>
> (A2
> <https://maps.google.com/?q=A2;%2215%22)+%C2%A0+(A2&entry=gmail&source=g>
> =>IBM)
> =smfGetYahooPortfolioView($A3;
> <https://maps.google.com/?q=A3;%2215%22)+%C2%A0+(A3&entry=gmail&source=g>"
> 15
> <https://maps.google.com/?q=A3;%2215%22)+%C2%A0+(A3&entry=gmail&source=g>")
> <https://maps.google.com/?q=A3;%2215%22)+%C2%A0+(A3&entry=gmail&source=g>
> (A3
> <https://maps.google.com/?q=A3;%2215%22)+%C2%A0+(A3&entry=gmail&source=g>
> =>SPY)
>
> But if I put a range in every cell:
>
>
> =smfGetYahooPortfolioView(A1:A3;"15") then I get a quote for A1 in all 3
> cells.
>
You don't want to do the three individual functions, as each would need to
go to the Internet to get the data.
On Thu, Dec 14, 2017 at 3:32 AM, a.bereziuk@yahoo.de [smf_addin] <
smf_addin@yahoogroups.com> wrote:
>
> If I put in every cell a function with reference to one cell, then it
> works like you have written:
>
> =smfGetYahooPortfolioView($A1;"15") (A1=>MMM)
> =smfGetYahooPortfolioView($A2;
> <https://maps.google.com/?q=A2;%2215%22)+%C2%A0+(A2&entry=gmail&source=g>"
> 15
> <https://maps.google.com/?q=A2;%2215%22)+%C2%A0+(A2&entry=gmail&source=g>")
> <https://maps.google.com/?q=A2;%2215%22)+%C2%A0+(A2&entry=gmail&source=g>
> (A2
> <https://maps.google.com/?q=A2;%2215%22)+%C2%A0+(A2&entry=gmail&source=g>
> =>IBM)
> =smfGetYahooPortfolioView($A3;
> <https://maps.google.com/?q=A3;%2215%22)+%C2%A0+(A3&entry=gmail&source=g>"
> 15
> <https://maps.google.com/?q=A3;%2215%22)+%C2%A0+(A3&entry=gmail&source=g>")
> <https://maps.google.com/?q=A3;%2215%22)+%C2%A0+(A3&entry=gmail&source=g>
> (A3
> <https://maps.google.com/?q=A3;%2215%22)+%C2%A0+(A3&entry=
> =>SPY)
>
> But if I put a range in every cell:
>
>
> =smfGetYahooPortfol
> cells.
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar