1 Message
Digest #4393
1a
Re: Example of SMFGetPortfolioView formula for filling duplicate sto by "Randy Harmelink" rharmelink
Message
Thu Sep 6, 2018 6:18 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need to add a third parameter with a value of "Y" if you want to have a
ticker returned multiple times.
On Thu, Sep 6, 2018 at 6:14 PM dcrapo@
....
wrote:
> Can any of you wizards provide a working example of the formula you use to
> fill duplicate stock entries in the same spreadsheet?
>
> I have only been able to fill the first stock entry using
> =smfGetYahooPortfolioView(A6:A107,DO2:DY2) but I have a few duplicate stock
> entries that I would love to fill at the same time. This would permit a
> quick calculation of total net present value.
>
>
>
ticker returned multiple times.
On Thu, Sep 6, 2018 at 6:14 PM dcrapo@
....
wrote:
> Can any of you wizards provide a working example of the formula you use to
> fill duplicate stock entries in the same spreadsheet?
>
> I have only been able to fill the first stock entry using
> =smfGetYahooPortfol
> entries that I would love to fill at the same time. This would permit a
> quick calculation of total net present value.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar