2 Messages

Digest #4221

smfGetYahooPortfolioView Exchange by sirons1962

Re: smfGetYahooPortfolioView Exchange by "Randy Harmelink" rharmelink

Messages

1a

smfGetYahooPortfolioView Exchange

Wed Nov 8, 2017 2:56 pm (PST) . Posted by:

sirons1962

In a spreadsheet I use to look up a limited number of data points one of the data points is Exchange.

I use the following in a cell: =smfGetYahooPorfolioView(ticker,"04") where ticker is a field name for cell B1.

What is returned in the cell is "--" (no quotes). I've tried putting an actual ticker symbol in =smfGetYahooPorfolioView("MMM","04") and I get the same result.

I thought it may be a formatting issue but it is formatted as General just like the smfGetYahooPorfolioView-Example spreadsheet, which does work correctly btw.

Thanks.

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

1b

Re: smfGetYahooPortfolioView Exchange

Wed Nov 8, 2017 3:13 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Thanks for the heads up. There was an issue if only a default field was
requested. It will be fixed in the next release.

On Wed, Nov 8, 2017 at 3:56 PM, sirons1962@
...
wrote:

> In a spreadsheet I use to look up a limited number of data points one of
> the data points is Exchange.
>
> I use the following in a cell: =smfGetYahooPorfolioView(ticker,"04")
> where ticker is a field name for cell B1.
>
> What is returned in the cell is "--" (no quotes). I've tried putting an
> actual ticker symbol in =smfGetYahooPorfolioView("MMM","04") and I get
> the same result.
>
> I thought it may be a formatting issue but it is formatted as General just
> like the smfGetYahooPorfolioView-Example spreadsheet, which does work
> correctly btw.
>
>
>