Senin, 10 April 2017

[smf_addin] Digest Number 3959

15 Messages

Digest #3959
1d
Re: Did Yahoo make some massive change within past day by "Andrew Hills" andrew.hills@hunterfield.com.au
2a
4b
Re: Getting the Sector and Industry from Yahoo by "Randy Harmelink" rharmelink
5a
Option Calls by bob_15861586
5b
Re: Option Calls by "Randy Harmelink" rharmelink
6b
Re: Trying to update my version of SMF by "Randy Harmelink" rharmelink

Messages

Mon Apr 10, 2017 8:05 am (PDT) . Posted by:

john_hoel

Another extraction from Yahoo that no longer works:

=smfGetTagContent("http://finance.yahoo.com/q?s="&A3,"td",1,"Prev Close:",,,,1)

Mon Apr 10, 2017 8:26 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

I can't test it, but it looks like the new URL is:

http://finance.yahoo.com/quote/AAPL

...and the label is now "Previous Close"...

On Mon, Apr 10, 2017 at 8:05 AM, john@
​...wrote:

>
> Another extraction from Yahoo that no longer works:
>
> =smfGetTagContent("http://finance.yahoo.com/q?s="&A3,"td",1,"Prev
> Close:",,,,1)
>
>

Mon Apr 10, 2017 11:36 am (PDT) . Posted by:

john_hoel

I tried some variations on that but they did not work. I decided to download the previous day's close from MarketWatch, which is a lot more stable than Yahoo.

Mon Apr 10, 2017 12:50 pm (PDT) . Posted by:

"Andrew Hills" andrew.hills@hunterfield.com.au

I noticed this extraction doesn't work as well. Any help would be much appreciated.

='RCHGetTableCell(("http://finance.yahoo.com/q/ce?s="&R3),1,">Event",,,,1)

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com]
Sent: Tuesday, April 11, 2017 1:06 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Did Yahoo make some massive change within past day

Another extraction from Yahoo that no longer works:

=smfGetTagContent("http://finance.yahoo.com/q?s="&A3,"td",1,"Prev Close:",,,,1)

Mon Apr 10, 2017 1:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The JSON data used to populate the page is here:

https://query1.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=assetProfile,secFilings,calendarEvents

On Mon, Apr 10, 2017 at 12:49 PM, 'Andrew Hills' andrew.hills@
​...wrote:

>
> I noticed this extraction doesn't work as well. Any help would be much
> appreciated.
>
>
>
> ='RCHGetTableCell(("http://finance.yahoo.com/q/ce?s="&R3),1,">Event",,,,1)
>
>
>

Mon Apr 10, 2017 11:18 am (PDT) . Posted by:

zacharycal

Randy,

That did the trick. Thank you for your help on this and all you do with this ad-on in general.


Really amazing stuff.


Zach

Mon Apr 10, 2017 11:55 am (PDT) . Posted by:

norton1717

Is it possible to pull data items for this morningstar page? Looking for a new source for fund data after the changes at Yahoo.


http://quicktake.morningstar.com/FundNet/PrintReport.aspx?Symbol=SAAAX http://quicktake.morningstar.com/FundNet/PrintReport.aspx?Symbol=SAAAX



Thanks

Mon Apr 10, 2017 12:15 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You should be able to use RCHGetTableCell() to pull data from those web
pages, but I think M* will probably dump the "print report" pages in the
near future.

On Mon, Apr 10, 2017 at 11:55 AM, rnorton@
​... wrote:

> Is it possible to pull data items for this morningstar page? Looking for
> a new source for fund data after the changes at Yahoo.
>
> http://quicktake.morningstar.com/FundNet/PrintReport.aspx?Symbol=SAAAX
>
>

Mon Apr 10, 2017 2:14 pm (PDT) . Posted by:

"Robbie Geary" rgearyiii

Thanks Randy. Would you happen to have a similar URL that gets the list of
all industries, as was available at
https://biz.yahoo.com/ic/ind_index_alpha.html until recently, and also a
list of stocks within a given industry?

On Sun, Apr 9, 2017 at 7:40 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> It looks like everything is being moved to JSON calls:
>
> https://query2.finance.yahoo.com/v10/finance/quoteSummary/
> AAPL?modules=assetProfile
>
> ​I have no access to EXCEL in the near future...​
>
> On Sun, Apr 9, 2017 at 12:38 AM, Robbie Geary rgearyiii@gmail.com
> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
>>
>>
>> Has Yahoo! broken the industry lookups in the course of getting rid of
>> the Industry Browser? All I get are errors now.
>>
>>
>> On Fri, Feb 3, 2017 at 12:34 PM, Randy Harmelink rharmelink@gmail.com
>> [smf_addin] <smf_addin@yahoogroups.com> wrote:
>>
>>>
>>>
>>> Works fine here. Could be Yahoo or communication issues?
>>>
>>> When you get an error on a ticker, do all of the items from that page
>>> return Error?
>>>
>>> *#* *Element*
>>> 13864 Sector Number
>>> 13865 Sector Name
>>> 13866 Industry Number
>>> 13867 Industry Name
>>> 13868 Industry Symbol
>>>
>>> On Thu, Feb 2, 2017 at 5:15 PM, Sundeep Chadha sundeep_chadha@
>>> ​...wrote:
>>>
>>>>
>>>> Any idea why this would return an error ?
>>>> =RCHGetElementNumber("YHOO&quot;,13867)
>>>>
>>>> Even though I see correct value on the actual page.
>>>> Lot of other symbols return correct value but some of then return with
>>>> error even when there is good value on the page
>>>>
>>>
>>
>
>

--
Robbie Geary

Mon Apr 10, 2017 4:11 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

For stocks within a given sector or industry group, this appears to be the
JSON call format:

https://query2.finance.yahoo.com/v1/finance/screener/predefined/saved?scrIds=technology&start=0&count=1000

https://query2.finance.yahoo.com/v1/finance/screener/predefined/saved?scrIds=semiconductor_equipment_materials&start=0&count=1000

As for the sector and industry group names, I don't see a good list
anywhere. The best I can find is within the Javascript code for starting a
new screen:

http://finance.yahoo.com/screener/new

On Mon, Apr 10, 2017 at 2:07 PM, Robbie Geary rgearyiii@
​...wrote:

>
> Thanks Randy. Would you happen to have a similar URL that gets the list
> of all industries, as was available at https://biz.yahoo.com/ic/ind_
> index_alpha.html until recently, and also a list of stocks within a given
> industry?
>

Mon Apr 10, 2017 4:43 pm (PDT) . Posted by:

climbermel

Not sure if this helps... On page: https://finance.yahoo.com/quote/AAPL/profile https://finance.yahoo.com/quote/AAPL/profile


I find sector and industry in:
<p class="D(ib) Va(t)"><span>Sector</span><!-- react-text: 3426 -->: <!-- /react-text --><strong>;Consumer Goods</strong>;<br><span>Industry</span><!-- react-text: 3430 -->: <!-- /react-text --><strong>;Electronic Equipment</strong><br><span>Full Time Employees</span><!-- react-text: 3434 -->: <!-- /react-text --><strong>;<span>116,000</span></strong></p>



I did notice that 878 and 877 work to get them from Morningstar which helps in the interim.


Mel

Mon Apr 10, 2017 2:43 pm (PDT) . Posted by:

bob_15861586

I am not getting pricing on most of my option positions. For example:
=smfGetGoogleOptionQuote("AMD","C",DATE(2018,1,19),20,"a")
this does not work. Could somebody offer a work around or an alternative?


Thanks
Bob

Mon Apr 10, 2017 3:56 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Google doesn't carry that contract. They are usually pretty spotty. I've
been using Barchart lately, at least before when I still had EXCEL running
on my now defunct desktop.

On Mon, Apr 10, 2017 at 2:43 PM, bob_15861586@
​...wrote:

> I am not getting pricing on most of my option positions. For example:
>
> =smfGetGoogleOptionQuote("AMD","C",DATE(2018,1,19),20,"a")
>
> this does not work. Could somebody offer a work around or an alternative?
>
>

Mon Apr 10, 2017 4:23 pm (PDT) . Posted by:

bob_15861586

The version of SMF that I am using goes back to July of 2015. Therefore, I thought it was a good time to update my version of SMF. I downloaded the files from here:
http://ogres-crypt.com/SMF/ http://ogres-crypt.com/SMF/


I then unzipped them into a local directory. From inside Excel, I brought up the add-on manager and unchecked SMF so it was no longer active. I then put SMF back, getting a message saying you do you want to overwrite the old one. I said yes. After updating the spread sheet, it still shows that I am using the old one. What did I do wrong?


Bob

Mon Apr 10, 2017 4:52 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

You should exit EXCEL when updating the SMF files...

On Mon, Apr 10, 2017 at 4:23 PM, bob_15861586@
​...wrote:

> The version of SMF that I am using goes back to July of 2015. Therefore, I
> thought it was a good time to update my version of SMF. I downloaded the
> files from here:
>
> http://ogres-crypt.com/SMF/
>
> I then unzipped them into a local directory. From inside Excel, I brought
> up the add-on manager and unchecked SMF so it was no longer active. I then
> put SMF back, getting a message saying you do you want to overwrite the old
> one. I said yes. After updating the spread sheet, it still shows that I am
> using the old one. What did I do wrong?
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 16.52

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)