Messages In This Digest (19 Messages)

1a.: Re: download/update the earings release date From: millerd1_smf
1b.: Re: download/update the earings release date From: Randy Harmelink

2a.: Re: Composite Moving Average From: millerd1_smf
2b.: Re: Composite Moving Average From: Randy Harmelink

3a.: Get Table Cell From: Steven
3b.: Re: Get Table Cell From: Randy Harmelink

4a.: Warrant Price Issue From: creditarbguy
4b.: Re: Warrant Price Issue From: Randy Harmelink

5a.: I get "Error" message for some formulas From: bmshah77
5b.: Re: I get "Error" message for some formulas From: Randy H

6a.: How i can extract data from this website ... From: back
6b.: smfGetTagContent From: PY & Associates
6c.: Re: How i can extract data from this website ... From: Randy Harmelink
6d.: Re: smfGetTagContent From: Randy Harmelink
6e.: Re: smfGetTagContent From: PY & Associates

7a.: Re: Retrieving S&P Information From: rjemery7

8.1.: RCHGetYahooQuotes() From: villamozart75016
8.2.: Re: RCHGetYahooQuotes() From: Randy H
8.3.: Re: RCHGetYahooQuotes() From: villamozart75016

View All Topics | Create New Topic

Messages

1a.: Re: download/update the earings release date

Posted by: "millerd1_smf" millerd1_airmail_net@yahoo.com millerd1_smf

Wed Feb 15, 2012 2:04 pm (PST)

Randy,

Have you ever prepared an earnings report data macro?

I see a Yahoo webpage where one can get expected earnings reports by incrementing weeks. You seem pretty proficient with yahoo pages have you seen this one? http://biz.yahoo.com/research/earncal/20120402.html

Millerd1

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Do a search of the message archives and you'll find a number of discussions
> on the topic. At this point, I would suggest either Zacks or FinViz, since
> they allow grabbing the data by individual ticker symbol or a group of
> ticker symbols.
>
> Check out the "Links" area of the group for getting data via the FinViz
> screener.
>
> On Sat, Aug 20, 2011 at 1:51 AM, wongchun72 <wangchuncn@...> wrote:
>
> >
> > Does someone know whether there is an Excel add-in to download/update the
> > earings release date for a selected stock symbol? Just as we can download
> > the day-close-price for a selected stock symbol.
> >
> > On Yahoo earnings calendar, we can find the companies that are going to
> > release or have rleased their results in the recent period. This is
> > calenard-day driven.
> >
> > We can also find on each individual stock page, the release date for that
> > company. This is company-name-drive, but we need to go web-page by web-page
> > to manually collect the info.
> >
> > If we want to easily get an overview of the stocks on our radar-screen that
> > are going to rlease their financial result, is there any software tool
> > helping us to do so?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
1b.: Re: download/update the earings release date

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 3:18 pm (PST)

What would you want to extract from the page? I've not found them
particularly useful.

On Wed, Feb 15, 2012 at 3:04 PM, millerd1_smf <
millerd1_airmail_net@yahoo.com> wrote:

>
> Have you ever prepared an earnings report data macro?
>
> I see a Yahoo webpage where one can get expected earnings reports by
> incrementing weeks. You seem pretty proficient with yahoo pages have you
> seen this one? http://biz.yahoo.com/research/earncal/20120402.html
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

2a.: Re: Composite Moving Average

Posted by: "millerd1_smf" millerd1_airmail_net@yahoo.com millerd1_smf

Wed Feb 15, 2012 2:16 pm (PST)

Randy,

There are candle stick pattern search routines that can locate trending patterns in say the last 3 months worth of price quotes. With spreadsheet price and live price data a buy and sell stop limits can be set by the prior OHLC. To be effective one would need live price ticks.

I can supply on published authors pattern recognition equations.

Did I happen to see you attending a Steve Bigalow's CandleStickForum or Hit&RunCandlesticks presentation last week?

Bigalow methods have made me a modest fortune in the last 45 days.

Millerd1

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Half of what you're saying there is going way over my head.
>
> The "Longest Cycle" would just, I think, be a matter of using the MAX()
> function on the various items you mention.
>
> All my add-in is going to do for you is to retrieve the historical data.
> Everything else is just regular EXCEL functions and charting. It's been
> years since I did a candlestick chart in EXCEL -- I've just not seen the
> need for so long, with all of the online charting tools available.
>
> For technical functions, I currently use the TA-Lib add-in:
>
> http://ta-lib.org/hdr_dw.html
>
> I started adding technical functions to my add-in, but figured why reinvent
> the wheel when the TA-Lib add-in is free?
>
>
> On Sun, Jun 14, 2009 at 4:43 PM, frater_spqr <frater_spqr@...> wrote:
>
> >
> > How would I write the equation to offset the longest cycle before making
> > the composite only after multipling said number by a) the square root of 252
> > and then fractionalize the annualized volatility-like measure by the periods
> > I want to offest? Otherwise the offset is arbritrary. Or am I
> > misunderstanding? Basically I'm selectively borrowing from a linear
> > regression formula and historical volatility. Too, if you're feeling
> > particulary generous and patient I, and maybe perhaps a few others here,
> > would love knowing how to plot an exponential moving average of the
> > composite average on a chart.
> >
> > I still am unsure how to plot the average on a candlestick chart using your
> > add-on.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2b.: Re: Composite Moving Average

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 3:25 pm (PST)

I've not found candlesticks to be particularly predictive, but maybe I've
looked at them wrong. I've done pattern recognition in the past and applied
it to data. But I'm willing to listen...

I didn't attend a presentation. :)

On Wed, Feb 15, 2012 at 3:16 PM, millerd1_smf <
millerd1_airmail_net@yahoo.com> wrote:

>
> There are candle stick pattern search routines that can locate trending
> patterns in say the last 3 months worth of price quotes. With spreadsheet
> price and live price data a buy and sell stop limits can be set by the
> prior OHLC. To be effective one would need live price ticks.
>
> I can supply on published authors pattern recognition equations.
>
> Did I happen to see you attending a Steve Bigalow's CandleStickForum or
> Hit&RunCandlesticks presentation last week?
>
> Bigalow methods have made me a modest fortune in the last 45 days.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)

3a.: Get Table Cell

Posted by: "Steven" stevenletzer@yahoo.com stevenletzer

Wed Feb 15, 2012 3:14 pm (PST)

I am trying to capture the name of a bond at emma.msrb.org For example:

http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=838736UV6
The words Security Details are at the top line of the description page.
The next line is what I want to capture:
SOUTH LYON MICH CMNTY SCHS REF (MI)*

any ideas?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
3b.: Re: Get Table Cell

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 3:42 pm (PST)

How about:

=smfGetTagContent("
http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=838736UV6
","a",-1,"/IssueDetails.")

On Wed, Feb 15, 2012 at 4:14 PM, Steven <stevenletzer@yahoo.com> wrote:

> I am trying to capture the name of a bond at emma.msrb.org For example:
>
> http://emma.msrb.org/SecurityView/SecurityDetails.aspx?cusip=838736UV6
> The words Security Details are at the top line of the description page.
> The next line is what I want to capture:
> SOUTH LYON MICH CMNTY SCHS REF (MI)*
>
> any ideas?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

4a.: Warrant Price Issue

Posted by: "creditarbguy" nicholas.morello@gmail.com creditarbguy

Wed Feb 15, 2012 6:40 pm (PST)

Hi All,

I'm using the following line in excel
=RCHGetElementNumber("c-wta",25)

Basically just trying to retrieve the price of the Citigroup Warrants Series A. When using yahoo finance webquote page I simply enter C-WTA into the box and the price shows up.

However, for some reason it doesn't work with my excel line.

Any help/advice would be appreciated thanks!

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.: Re: Warrant Price Issue

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 6:43 pm (PST)

Element #25 comes from an MSN stock page, so there's no reason to expect it
to get the data.

Instead, try the quotes function:

=RCHGetYahooQuotes("C-WTA","l1")

On Wed, Feb 15, 2012 at 7:36 PM, creditarbguy <nicholas.morello@gmail.com>wrote:

>
> I'm using the following line in excel
> =RCHGetElementNumber("c-wta",25)
>
> Basically just trying to retrieve the price of the Citigroup Warrants
> Series A. When using yahoo finance webquote page I simply enter C-WTA into
> the box and the price shows up.
>
> However, for some reason it doesn't work with my excel line.
>
> Any help/advice would be appreciated thanks!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

5a.: I get "Error" message for some formulas

Posted by: "bmshah77" bmshah77@yahoo.com bmshah77

Wed Feb 15, 2012 11:03 pm (PST)

I am getting an "Error" message for some forumlas. I installed the zip files in the C:\Program Files\SMF Add-In as per the instructions. Now when I open my excel file I notice that all the fields with formulas do have their respective values (meaning the formulas are working). But in order for me to do anything I need to click on Enable Content as my version is Office 2010. As soon as I do that I get the "Error" message for some formulas whereas others seems to be working fine. The "Error" message is seen especially in cells that are trying to pull data from investors.com. I do have the addin installed in excel. Any ideas why I'm seeing this issue.

Thanks.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5b.: Re: I get "Error" message for some formulas

Posted by: "Randy H" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 11:08 pm (PST)

Without knowing the specific formulas that are giving you "Error", it's
difficult to help.

For the enable content issue, you should take a look at the "Location
Error" entry of the "Links" area of the group, as well as take a quick
look around at the other entries there.

As far as "Error" returns from investors.com -- they just changed their
URL structure, so data is now a lot more difficult to get. You need more
than just a ticker symbol to create the URL. See:

http://finance.groups.yahoo.com/group/smf_addin/message/17330

On Wed, Feb 15, 2012 at 11:39 PM, bmshah77 <bmshah77@yahoo.com> wrote:
I am getting an "Error" message for some forumlas. I installed the zip
files in the C:\Program Files\SMF Add-In as per the instructions. Now
when I open my excel file I notice that all the fields with formulas do
have their respective values (meaning the formulas are working). But in
order for me to do anything I need to click on Enable Content as my
version is Office 2010. As soon as I do that I get the "Error" message
for some formulas whereas others seems to be working fine. The "Error"
message is seen especially in cells that are trying to pull data from
investors.com <http://investors.com/> . I do have the addin installed in
excel. Any ideas why I'm seeing this issue.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)

6a.: How i can extract data from this website ...

Posted by: "back" backmehl@yahoo.de backmehl

Thu Feb 16, 2012 12:22 am (PST)

Hi Randy,

i hope you can help me ...

How can i extract the data table from the following site?

http://www.ariva.de/jd_1_spec.value-fonds/historische_kurse

Than you very much !!

Regards

BM

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
6b.: smfGetTagContent

Posted by: "PY & Associates" pynasocas@yahoo.com.sg pynasocas

Thu Feb 16, 2012 12:43 am (PST)

Hi Randy

Would you be kind enough to advise why "instr" is preferred instead of "getElementByTagName" in the function please?

Regards
KC

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
6c.: Re: How i can extract data from this website ...

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu Feb 16, 2012 12:43 am (PST)

How about:

=RCHGetHTMLTable("
http://www.ariva.de/jd_1_spec.value-fonds/historische_kurse
","Datum",-1,"",1)

On Thu, Feb 16, 2012 at 1:22 AM, back <backmehl@yahoo.de> wrote:

>
> i hope you can help me ...
>
> How can i extract the data table from the following site?
>
> http://www.ariva.de/jd_1_spec.value-fonds/historische_kurse
>
> Than you very much !!
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
6d.: Re: smfGetTagContent

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu Feb 16, 2012 12:49 am (PST)

Because getElementByTagName wouldn't work -- I'm using the text response of
the XMLHTTP protocol instead of the XML response.

That's because I found HTML objects worked inconsistently over the various
permutations of IE and EXCEL versions that can be combined. Some of the
HTML object code I had working in EXCEL 2002 totally failed when I upgraded
to EXCEL 2007. I don't even know what versions of IE I was using in each.

On Thu, Feb 16, 2012 at 1:43 AM, PY & Associates <pynasocas@yahoo.com.sg>wrote:

>
> Would you be kind enough to advise why "instr" is preferred instead of
> "getElementByTagName" in the function please?
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)
6e.: Re: smfGetTagContent

Posted by: "PY & Associates" pynasocas@yahoo.com.sg pynasocas

Thu Feb 16, 2012 1:07 am (PST)

inconsistent is the keyword.
No wonder I always get bombed out in the least expected moment.
Maybe I should stick to xmlhttp then

Regards
KC

________________________________
From: Randy Harmelink <rharmelink@gmail.com>
To: smf_addin@yahoogroups.com
Sent: Thursday, 16 February 2012, 8:49
Subject: Re: [smf_addin] smfGetTagContent

Because getElementByTagName wouldn't work -- I'm using the text response of the XMLHTTP protocol instead of the XML response.

That's because I found HTML objects worked inconsistently over the various permutations of IE and EXCEL versions that can be combined. Some of the HTML object code I had working in EXCEL 2002 totally failed when I upgraded to EXCEL 2007. I don't even know what versions of IE I was using in each.

On Thu, Feb 16, 2012 at 1:43 AM, PY & Associates <pynasocas@yahoo.com.sg> wrote:

>
>Would you be kind enough to advise why "instr" is preferred instead of "getElementByTagName" in the function please?
>
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

7a.: Re: Retrieving S&P Information

Posted by: "rjemery7" rjemery@gmail.com rjemery7

Thu Feb 16, 2012 12:43 am (PST)

As it is not ticker based, it is cumbersome to setup and export a CSV file for eventual inclusion into a master spreadsheet. If I wish to add a ticker or two, it would be far simpler to make direct use of the SMF add-in utility. I seek the easiest way, not a convoluted one.

--- In smf_addin@yahoogroups.com, Martin Topper <mtopper@...> wrote:
>
> If you already have a CSV file what would you use the addin to do?
>
>
>
> ________________________________
> From: rjemery7 <rjemery@...>
> To: smf_addin@yahoogroups.com
> Sent: Wednesday, February 15, 2012 2:50 PM
> Subject: [smf_addin] Re: Retrieving S&P Information
>
>
> Â
> I can obtain that information behind password protected brokerage accounts, then export it as a CSV file. From there I think I can use the smfGetCSVFile function to retrieve the necessary data.
>
> If there is a easier way, please advise.
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@> wrote:
> >
> > First, you'd need a source of the data items. Those are proprietary, so I
> > don't have a source that I can use.
> >
> > And you'd need to define Beta -- different data sources compute different
> > values of Beta.
> >
> > On Wed, Feb 15, 2012 at 6:10 AM, rjemery7 <rjemery@> wrote:
> >
> > > For a given ticker symbol, how would I obtain the following S&P
> > > information, if at all possible:
> > >
> > > S&P Sector
> > > S&P Industry
> > > S&P Sub-Industry
> > > S&P STARS Rating
> > > S&P Earnings & Dividend Ranking (a letter grade, sometimes with a +/-
> > > suffix, such as A, B+, C- or NR)
> > >
> > > Additionally, how would I retrieve
> > > Beta
> > >
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (5)

8.1.: RCHGetYahooQuotes()

Posted by: "villamozart75016" villamozart75016@yahoo.com villamozart75016

Thu Feb 16, 2012 1:01 am (PST)

Hello,

I discovered you fantastic tool, many thanks for this sweet add-on.
I am having a small issue with my array-entered formula sheet.
How can I preform data filtering and sorting while using a array-entered formula?
For example: I want to track which stock had the most significant day's change. Normally I would select the corresponding column and sort by values + to -. When i attempt this I get the "cannot change part of an array" error. I tried creating a mirror of the data contained in the spreadsheet but that did not work either.
Any ideas on a work around?

Many thanks

TM

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (42)
8.2.: Re: RCHGetYahooQuotes()

Posted by: "Randy H" rharmelink@gmail.com rharmelink

Thu Feb 16, 2012 1:07 am (PST)

Keep in mind that all you really need to sort are the ticker symbols.
Once they are in the order you want, the array-entered range will
automatically update. And it updates quickly since the entire range is
just a single Internet access.

What I've done in some cases is just create a "Sort" column next to the
ticker symbols, and then just sort those two columns. Then you don't
need to mirror all of the data. But you do need to redo the "Sort"
column if you want a different sort sequence. Or you could create
multiple sort columns if you do a number of different sorts regularly.

On Thu, Feb 16, 2012 at 1:52 AM, villamozart75016
<villamozart75016@yahoo.com> wrote:

I discovered you fantastic tool, many thanks for this sweet add-on.
I am having a small issue with my array-entered formula sheet.
How can I preform data filtering and sorting while using a array-entered
formula?
For example: I want to track which stock had the most significant day's
change. Normally I would select the corresponding column and sort by
values + to -. When i attempt this I get the "cannot change part of an
array" error. I tried creating a mirror of the data contained in the
spreadsheet but that did not work either.
Any ideas on a work around?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (42)
8.3.: Re: RCHGetYahooQuotes()

Posted by: "villamozart75016" villamozart75016@yahoo.com villamozart75016

Thu Feb 16, 2012 2:48 am (PST)

Worked perfectly!!

Thank you

--- In smf_addin@yahoogroups.com, "Randy H" <rharmelink@...> wrote:
>
> Keep in mind that all you really need to sort are the ticker symbols.
> Once they are in the order you want, the array-entered range will
> automatically update. And it updates quickly since the entire range is
> just a single Internet access.
>
> What I've done in some cases is just create a "Sort" column next to the
> ticker symbols, and then just sort those two columns. Then you don't
> need to mirror all of the data. But you do need to redo the "Sort"
> column if you want a different sort sequence. Or you could create
> multiple sort columns if you do a number of different sorts regularly.
>
> On Thu, Feb 16, 2012 at 1:52 AM, villamozart75016
> <villamozart75016@...> wrote:
>
> I discovered you fantastic tool, many thanks for this sweet add-on.
> I am having a small issue with my array-entered formula sheet.
> How can I preform data filtering and sorting while using a array-entered
> formula?
> For example: I want to track which stock had the most significant day's
> change. Normally I would select the corresponding column and sort by
> values + to -. When i attempt this I get the "cannot change part of an
> array" error. I tried creating a mirror of the data contained in the
> spreadsheet but that did not work either.
> Any ideas on a work around?
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (42)

Create New Topic | Visit Your Group on the Web

Messages | Files | Photos | Polls

Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

Kamis, 16 Februari 2012

Messages In This Digest (19 Messages)

Messages

Posted by: "millerd1_smf" millerd1_airmail_net@yahoo.com millerd1_smf

Wed Feb 15, 2012 2:04 pm (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 3:18 pm (PST)

Posted by: "millerd1_smf" millerd1_airmail_net@yahoo.com millerd1_smf

Wed Feb 15, 2012 2:16 pm (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 3:25 pm (PST)

Posted by: "Steven" stevenletzer@yahoo.com stevenletzer

Wed Feb 15, 2012 3:14 pm (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 3:42 pm (PST)

Posted by: "creditarbguy" nicholas.morello@gmail.com creditarbguy

Wed Feb 15, 2012 6:40 pm (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 6:43 pm (PST)

Posted by: "bmshah77" bmshah77@yahoo.com bmshah77

Wed Feb 15, 2012 11:03 pm (PST)

Posted by: "Randy H" rharmelink@gmail.com rharmelink

Wed Feb 15, 2012 11:08 pm (PST)

Posted by: "back" backmehl@yahoo.de backmehl

Thu Feb 16, 2012 12:22 am (PST)

Posted by: "PY & Associates" pynasocas@yahoo.com.sg pynasocas

Thu Feb 16, 2012 12:43 am (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu Feb 16, 2012 12:43 am (PST)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Thu Feb 16, 2012 12:49 am (PST)

Posted by: "PY & Associates" pynasocas@yahoo.com.sg pynasocas

Thu Feb 16, 2012 1:07 am (PST)

Posted by: "rjemery7" rjemery@gmail.com rjemery7

Thu Feb 16, 2012 12:43 am (PST)

Posted by: "villamozart75016" villamozart75016@yahoo.com villamozart75016

Thu Feb 16, 2012 1:01 am (PST)

Posted by: "Randy H" rharmelink@gmail.com rharmelink

Thu Feb 16, 2012 1:07 am (PST)

Posted by: "villamozart75016" villamozart75016@yahoo.com villamozart75016

Thu Feb 16, 2012 2:48 am (PST)

Tidak ada komentar:

Posting Komentar

Followers

Blog Archive

About Me