2 Messages

Digest #4399

Re: Example of SMFGetPortfolioView formula for filling duplicate sto by dcrapo

Re: Example of SMFGetPortfolioView formula for filling duplicate sto by "Randy Harmelink" rharmelink

Messages

1a

Re: Example of SMFGetPortfolioView formula for filling duplicate sto

Sat Sep 15, 2018 8:14 am (PDT) . Posted by:

dcrapo

Thanks, Randy! I have tried (with my limited Excel knowledge) many times to add the third parameter to my formula, as you have suggested. I have not been successful.

Would you be so kind as to provide an example of a formula with the third parameter added?

The one I am currently using is =smfGetYahooPortfolioView(A123:A143,DO2:DY2)

Thanks in advance!

Reply to sender . Reply to group . Reply via Web Post . All Messages (4) . Top ^

1b

Re: Example of SMFGetPortfolioView formula for filling duplicate sto

Sat Sep 15, 2018 8:08 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I just opened the template from the website, added a second line with
ticker "MMM", and then changed the formula to:

=smfGetYahooPortfolioView($B$4:$B$411,$C$2:$AJ$2,"Y",1)

....and the second "MMM" then showed up in the returned data.

Be sure you select the entire range of the formula before trying to edit
it, and then array-enter it over that range (Ctrl+Shift+Enter).

On Sat, Sep 15, 2018 at 7:24 PM dcrapo@... wrote:

>
> Thanks, Randy! I have tried (with my limited Excel knowledge) many times
> to add the third parameter to my formula, as you have suggested. I have not
> been successful.
>
> Would you be so kind as to provide an example of a formula with the third
> parameter added?
>
> The one I am currently using
> is =smfGetYahooPortfolioView(A123:A143,DO2:DY2)
>
>
>