Sabtu, 11 Juli 2015

[smf_addin] Digest Number 3454

5 Messages

Digest #3454

Messages

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.


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.

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?



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?
>

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?
>>
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar