[smf_addin] Digest Number 3454

EXCEL Stock Market Functions Add-in Group

5 Messages

Digest #3454

1a

option info not cooperating for weeklies by trendsekr

1b

Re: option info not cooperating for weeklies by trendsekr

2a

earningswhisper redesigned their website by marco.deen

2b

Re: earningswhisper redesigned their website by "Randy Harmelink" rharmelink

2c

Re: earningswhisper redesigned their website by "Marco Deen" marco.deen

Messages

1a

option info not cooperating for weeklies

Fri Jul 10, 2015 9:45 am (PDT) . Posted by:

trendsekr

I seem to have this problem periodically, wonder if it's the yahoo data source. I even hard code the date in the format 7/31 2015. It gives me an error instead of the Last Price. Currently the problem is with FEYE July5 $54 calls and $48.5 puts.

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

1b

Re: option info not cooperating for weeklies

Fri Jul 10, 2015 10:00 am (PDT) . Posted by:

trendsekr

Changed the data source to google and everything works fine. The answer to the % Change question effectively fixed two of my problems. Thanks.

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

2a

earningswhisper redesigned their website

Fri Jul 10, 2015 3:21 pm (PDT) . Posted by:

marco.deen

Randy,


Earningswhispers.com recently redesigned their website. I used to grab earnings dates with the following formula:
=RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol="&A1,1,"Release Date:")
but this now returns an error. On the website I can still see the date but I don't know if it is possible to pull that into excel?

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

2b

Re: earningswhisper redesigned their website

Fri Jul 10, 2015 4:52 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfGetTagContent("https://www.earningswhispers.com/stocks/
"&C6,"div",-1,"/calendar?d=")

...or maybe:

=smfStrExtr(smfGetTagContent("https://www.earningswhispers.com/stocks/"&C7,"head",1,""),"reports
earnings on "," ")

On Fri, Jul 10, 2015 at 3:21 PM, marco.deen@... wrote:

> Earningswhispers.com recently redesigned their website. I used to grab
> earnings dates with the following formula:
>
> =RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol="&A1,1,"Release
> Date:")
>
> but this now returns an error. On the website I can still see the date but
> I don't know if it is possible to pull that into excel?
>

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

2c

Re: earningswhisper redesigned their website

Fri Jul 10, 2015 5:29 pm (PDT) . Posted by:

"Marco Deen" marco.deen

Yes, they both work! Thanks once again.

[URL=
http://www.sherv.net/][IMG]http://www.sherv.net/cm/emoticons/hello/hat-off-salute-smiley-emoticon.gif[/IMG][/URL
]

On Fri, Jul 10, 2015 at 7:52 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Try:
>
> =smfGetTagContent("https://www.earningswhispers.com/stocks/
> "&C6,"div",-1,"/calendar?d=")
>
> ...or maybe:
>
> =smfStrExtr(smfGetTagContent("https://www.earningswhispers.com/stocks/"&C7,"head",1,""),"reports
> earnings on "," ")
>
> On Fri, Jul 10, 2015 at 3:21 PM, marco.deen@... wrote:
>
>> Earningswhispers.com recently redesigned their website. I used to grab
>> earnings dates with the following formula:
>>
>> =RCHGetTableCell("http://www.earningswhispers.com/stocks.asp?symbol="&A1,1,"Release
>> Date:")
>>
>> but this now returns an error. On the website I can still see the date
>> but I don't know if it is possible to pull that into excel?
>>
>
>
>

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

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 12

• Privacy • Unsubscribe • Terms of Use