2 Messages

Digest #4392

Re: smfGetYahooPortfolioView Broken? by wiscobez

Example of SMFGetPortfolioView formula for filling duplicate stock e by dcrapo

Messages

1a

Re: smfGetYahooPortfolioView Broken?

Wed Sep 5, 2018 7:19 am (PDT) . Posted by:

wiscobez

I didn't have the opportunity to look at my spreadsheet again until this morning. I initiated a smfForceRecalculation, and everything worked perfectly.

I made no changes, and there were no bad symbols in my list. It simply started working again. Excel gremlins? I'm just happy to be up & running again without the need to overhaul my workbook.

Thanks so much for your ongoing support and generosity to this user community, Randy!

Dave

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

2 Example of SMFGetPortfolioView formula for filling duplicate stock e

Wed Sep 5, 2018 12:11 pm (PDT) . Posted by:

dcrapo

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.

Thanks for any help (and thanks Randy for your amazing contributions).