4 Messages
Digest #4197
Messages
Thu Nov 2, 2017 6:28 pm (PDT) . Posted by:
mark.boogaers
The return text from Yahoo is currently: "It has come to our attention that this service is being used in violation of the Yahoo Terms of Service. As such, the service is being discontinued. For all future markets and equities data research, please refer to finance.yahoo.com."
So looks like we need to find alternative sorces.
So looks like we need to find alternative sorces.
Thu Nov 2, 2017 6:46 pm (PDT) . Posted by:
woodburydance
Thank you Randy for all of your work on the SMF Add-In. I have been using it flawlessly for about 2 years.
I am trying to find the documentation for the smfGetYahooPortfolioView function. The documentation page does not seem to contain it. I have updated to the RCH_Stock_Market_Functions-2.1.2017.11.02 version. I am only trying to pull 3 pieces of data - Last Price, Forward PE and Dividend Yield. I tried to pull just the last price with the following =smfGetYahooPortfolioView($B$4,"15",,1) but all it returns is "Last Price" instead of the value of the last price.
If it is possible to pull just elements 15, 30 and 34 that is all I am hoping for from the workaround.
Sincerely,
Bruce
I am trying to find the documentation for the smfGetYahooPortfoli
If it is possible to pull just elements 15, 30 and 34 that is all I am hoping for from the workaround.
Sincerely,
Bruce
Thu Nov 2, 2017 7:09 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
As I mentioned on the blog entry, the template itself was the only real
documentation.
You'd just need something like:
=smfGetYahooPortfolioView(C5:C6,"01153034",,1)
You should always return the ticker symbol, because the returned data may
not match the order of the passed ticker symbols.
On Thu, Nov 2, 2017 at 6:46 PM, bameyer@
...
wrote:
> I am trying to find the documentation for the smfGetYahooPortfolioView
> function. The documentation page does not seem to contain it. I have
> updated to the RCH_Stock_Market_Functions-2.1.2017.11.02 version. I am
> only trying to pull 3 pieces of data - Last Price, Forward PE and Dividend
> Yield. I tried to pull just the last price with the following
> =smfGetYahooPortfolioView($B$4,"15",,1) but all it returns is "Last
> Price" instead of the value of
> t
> he last price.
>
> If it is possible to pull just elements 15, 30 and 34 that is all I am
> hoping for from the workaround.
>
>
>
documentation.
You'd just need something like:
=smfGetYahooPortfol
You should always return the ticker symbol, because the returned data may
not match the order of the passed ticker symbols.
On Thu, Nov 2, 2017 at 6:46 PM, bameyer@
...
wrote:
> I am trying to find the documentation for the smfGetYahooPortfoli
> function. The documentation page does not seem to contain it. I have
> updated to the RCH_Stock_Market_
> only trying to pull 3 pieces of data - Last Price, Forward PE and Dividend
> Yield. I tried to pull just the last price with the following
> =smfGetYahooPortfol
> Price" instead of the value of
> t
> he last price.
>
> If it is possible to pull just elements 15, 30 and 34 that is all I am
> hoping for from the workaround.
>
>
>
Thu Nov 2, 2017 7:21 pm (PDT) . Posted by:
eadamy
First, thank you for all of the work you do to keep us stocked with quotes.
The Blog looks like a great idea for quick reference and I've bookmarked it. I've looked all over for a way to subscribe to an RSS feed but don't see any?
Yahoo seems to have a goal of preventing downloading without viewing advertising. Visit the website populated with advertising, enter a symbol and download data. That is clearly ok. But downloading without viewing ads is not ok. I assume that this has turned into a cat and mouse game of finding the holes and closing them. How much difficulty will they have in shutting down the JSON based scraping your are doing now?
If all one needs is a current real-time quote, how do you feel about the quality of Google quotes versus Yahoo?
Earl
The Blog looks like a great idea for quick reference and I've bookmarked it. I've looked all over for a way to subscribe to an RSS feed but don't see any?
Yahoo seems to have a goal of preventing downloading without viewing advertising. Visit the website populated with advertising, enter a symbol and download data. That is clearly ok. But downloading without viewing ads is not ok. I assume that this has turned into a cat and mouse game of finding the holes and closing them. How much difficulty will they have in shutting down the JSON based scraping your are doing now?
If all one needs is a current real-time quote, how do you feel about the quality of Google quotes versus Yahoo?
Earl
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar