Minggu, 22 Februari 2015

[smf_addin] Digest Number 3333

11 Messages

Digest #3333

Messages

Sat Feb 21, 2015 9:08 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Not a good source for extraction. You'll need to examine web page source
code for ways to do each item, since things vary. For example, something
like this for Key Stock data:

=smfConvertData(smfstrExtr(smfGetTagContent("http://quotes.wsj.com/GOOGL","span",1,">P/E
Ratio",">P/E Ratio"),"~","<"))

Latest news was such a hodge podge of coding, I wouldn't even attempt it.

"Research and Ratings" is too vague, since there are so many things on the
web page. Each may require completely different methods. Again, based on
the source code of the web page.

If there's something unique, I'll give it a try, but I'm not going to spend
time getting something that can be gotten elsewhere more easily.

On Sat, Feb 21, 2015 at 1:31 AM, tysongayada@... wrote:

>
> is there any method to extract data from http://quotes.wsj.com/GOOGL
>
> for
>
> 1) Key Stock Data
>
> 2) Latest News
>
> 3) Research and Ratings
>

Sat Feb 21, 2015 6:53 pm (PST) . Posted by:

tysongayada

hi randy,

as usual, thanks for the amazing coding.


ironically i find that WSJ is not a bad source of information.


you are mentioning that there are better sources of information.


what are some examples that you know of?

Sat Feb 21, 2015 7:49 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It all depends on the type of information. I don't find news all that
valuable, especially on the large cap stocks, because they get mentioned in
every little bit of news.

I used to say AdvFN was the best, but they've gone downhill in the past
year or so. Now, GuruFocus looks good. I even subscribed when they had
their 20% off special this past December.

Otherwise, I can usually find what I need between Yahoo, MorningStar, and
Reuters.

On Sat, Feb 21, 2015 at 7:53 PM, tysongayada@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> as usual, thanks for the amazing coding.
>
> ironically i find that WSJ is not a bad source of information.
>
> you are mentioning that there are better sources of information.
>
> what are some examples that you know of?
>

Sat Feb 21, 2015 9:49 am (PST) . Posted by:

hashky

Randy -

I used the functions you recommended. One thing I could not do was build a series of monthly Expirations. However, the old way you told me to do it on Yahoo still works.

E2=RCHGetWebData(E3,"m=2")
E3=IF(OR(Ticker="",Ticker="None"),"--","http://finance.yahoo.com/q/os?s="&UPPER(Ticker))
E5=RCHGetTableCell($E$3,1,"Options Expiring","Symbol&quot;,,,1,"</table",,"")
E6=IF(E5>"",DATEVALUE(MID(E5,LEN(E5)-12,2)&"/"&MID(E5,LEN(E5)-10,2)&"/"&MID(E5,LEN(E5)-14,2)),"")

I use this for the horizontal axis and
=smfGetOptionStrikes(Ticker,Expiry1,"Call",$C$29,,10,1)

For Expiry 1 through 10.

I was then able to build a table of Expiration dates and strike prices and give the a label of ITM5 through OTM5.


Then I could use Vlookup() to find the appropriate strike price. (I also had to rebuid the structure of the options, e.g. CAT 4/17 2015 $85.00 Call.)


Bottom line. I got it working, but it ain't pretty. I am sure it needs a few tweaks.


Ron

Sat Feb 21, 2015 12:07 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

You shouldn't need the VLOOKUP() table.

ITM1 should always be:

=smfGetOptionStrikes(Ticker,Expiry1,"Call",$C$29,,2,1)

OTM1 should always be:

=smfGetOptionStrikes(Ticker,Expiry1,"Call",$C$29,,1,1)

You could even have those return the applicable options ticker symbol for
the strike/expiration date with:

=smfGetOptionStrikes(Ticker,Expiry1,"Call",$C$29,1,2,1)
=smfGetOptionStrikes(Ticker,Expiry1,"Call",$C$29,1,1,1)

On Sat, Feb 21, 2015 at 10:49 AM, hashky@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> I used the functions you recommended. One thing I could not do was build
> a series of monthly Expirations. However, the old way you told me to do it
> on Yahoo still works.
>
> E2=RCHGetWebData(E3,"m=2")
> E3=IF(OR(Ticker="",Ticker="None"),"--","http://finance.yahoo.com/q/os?s=
> "&UPPER(Ticker))
> E5=RCHGetTableCell($E$3,1,"Options Expiring","Symbol&quot;,,,1,"</table",,"")
>
> E6=IF(E5>"",DATEVALUE(MID(E5,LEN(E5)-12,2)&"/"&MID(E5,LEN(E5)-10,2)&"/"&MID(E5,LEN(E5)-14,2)),"")
>
> I use this for the horizontal axis and
> =smfGetOptionStrikes(Ticker,Expiry1,"Call",$C$29,,10,1)
>
> For Expiry 1 through 10.
>
> I was then able to build a table of Expiration dates and strike prices and
> give the a label of ITM5 through OTM5.
>
> Then I could use Vlookup() to find the appropriate strike price. (I also
> had to rebuid the structure of the options, e.g. CAT 4/17 2015 $85.00 Call.)
>
> Bottom line. I got it working, but it ain't pretty. I am sure it needs a
> few tweaks.
>
>

Sat Feb 21, 2015 4:19 pm (PST) . Posted by:

hashky

I thought that the Vlookup() might be faster. Overall it's pretty slow. Ten seconds to 1 minute to calculate. It averages about 25 seconds.

Would that speed it up very much?

I generally have one ITM and 5 OTM for most Expirations.

Sat Feb 21, 2015 10:20 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

When I release the next beta version, you can find out where the time is
being spent. It has an option to keep a log of Internet calls. I've found
it interesting to see how long various websites are, as well as when some
will suddenly take 10 to 20 seconds for a response where it's typically
been under a second.

On Sat, Feb 21, 2015 at 5:19 PM, hashky@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I thought that the Vlookup() might be faster. Overall it's pretty slow.
> Ten seconds to 1 minute to calculate. It averages about 25 seconds.
>
> Would that speed it up very much?
>
> I generally have one ITM and 5 OTM for most Expirations.
>

Sat Feb 21, 2015 12:08 pm (PST) . Posted by:

cruel_toad

GuruFocus has a LOT of metrics available, but I do not see it in the list of sources that SMF's built-in templates have info for. Are there any plans to add GuruFocus?

Sat Feb 21, 2015 12:11 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Another user of the add-in has uploaded a template to the "Uploads by Forum
Members" folder of the FILES area of the Yahoo group.

If you find the metrics useful, I'd suggest subscribing. Then you can
download an XLS file with up to 15 years of annual and quarterly data.

On Sat, Feb 21, 2015 at 12:35 PM, baseball@reverenddave.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> GuruFocus has a LOT of metrics available, but I do not see it in the
> list of sources that SMF's built-in templates have info for. Are there any
> plans to add GuruFocus?
>
>

Sat Feb 21, 2015 10:33 pm (PST) . Posted by:

jmaccks

Hello,
I am new to this group and I am trying to figure out how to get smf to work in excel 2010. I am basing my understanding of the add-in from the following article: http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel


I joined the group, downloaded the zip-file to c drive, activated add-in (at least it shows when I go options,
add-ins in excel) In the article the author uses a simple example to get things started. In this case he suggested looking for 5 year dividend growth rate indicator from MSN. The following steps were taken:
1. Labeled spreed sheet with appropriate indicators
2. Opened RCHGetElementNumber Definitions from the file located in c drive.
3. Located the 5 year dividend growth rate indicator from MSN
63 S MSN % Growth Rate -- Dividends (5-Year Annual Average) -- Company
4. Went back to the dividend growth spread sheet and typed JNJ into cell A2
5. Then under the dividend growth rate (5yr annualized), in cell B2 I typed the following formula:
=rchgetelementnumber(a2,63) and received the following error message inside B2 > ERROR.


Anyhow, not sure you can figure out where I am, but if you have any suggestions I would greatly appreciate it. Moreover, I am just trying to figure out if I have everything configured correctly and the add-in is working correctly. Thank you.


James






Sat Feb 21, 2015 10:43 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Sorry about that. All MSN elements are now obsolete. MSN did a massive
change of their website several months ago and dropped almost every data
items that was defined as an element. They really did a hatchet job. To
make it even worse, their financial pages render differently on different
browsers.

An easy check to see if the add-in is installed properly is to check which
version you have, with:

=RCHGetElementNumber("Version")

On Sat, Feb 21, 2015 at 11:17 PM, jmaccks@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> I am new to this group and I am trying to figure out how to get smf to
> work in excel 2010. I am basing my understanding of the add-in from the
> following article:
> http://seekingalpha.com/instablog/326478-derek-a-barrett/1414481-automating-alpha-getting-started-with-stock-market-functions-smf-add-in-for-excel
>
>
> I joined the group, downloaded the zip-file to c drive, activated add-in
> (at least it shows when I go options,
>
> add-ins in excel) In the article the author uses a simple example to get
> things started. In this case he suggested looking for 5 year dividend
> growth rate indicator from MSN. The following steps were taken:
>
> 1. Labeled spreed sheet with appropriate indicators
>
> 2. Opened RCHGetElementNumber Definitions from the file located in c drive.
>
> 3. Located the 5 year dividend growth rate indicator from MSN
> 63 S MSN % Growth Rate -- Dividends (5-Year Annual Average) -- Company
>
> 4. Went back to the dividend growth spread sheet and typed JNJ into cell
> A2
>
> 5. Then under the dividend growth rate (5yr annualized), in cell B2 I
> typed the following formula:
>
> =rchgetelementnumber(a2,63) and received the following error message
> inside B2 > ERROR.
>
> Anyhow, not sure you can figure out where I am, but if you have any
> suggestions I would greatly appreciate it. Moreover, I am just trying to
> figure out if I have everything configured correctly and the add-in is
> working correctly. Thank you.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar