[smf_addin] Digest Number 2166

EXCEL Stock Market Functions Add-in

Messages In This Digest (12 Messages)

1a.

Re: How do I attach an excel file to my message? From: navin_agrawal_1

1b.

Re: How do I attach an excel file to my message? From: dguillett1

1c.

Re: How do I attach an excel file to my message? From: Sudhir Agarwal

1d.

Re: How do I attach an excel file to my message? From: Randy Harmelink

2a.

Problems with 10 year historical ROC From: another_investor

2b.

Re: Problems with 10 year historical ROC From: Randy Harmelink

2c.

Re: Problems with 10 year historical ROC From: another_investor

3a.

"Earnings" source not working? From: mahluwa

3b.

Re: "Earnings" source not working? From: Randy Harmelink

3c.

Re: "Earnings" source not working? From: mahluwa

4a.

Enquiry of smfGetTagContent() function From: ericckyuen

4b.

Re: Enquiry of smfGetTagContent() function From: Randy Harmelink

View All Topics | Create New Topic

Messages

1a.

Re: How do I attach an excel file to my message?

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

Tue Apr 3, 2012 5:24 am (PDT)

Thanks Randy..... The tone of your message says a lot...

How do people in this group exchange attachments.... Maybe your group isn't equipped to exchange posts with attachments....

I am exchanging (both receiving & uploading for others) attachments with posts on other forums.... with a lot of positive results....

Thanks again....

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The only time I've attached files is when sending mail from my GMail
> account. I don't know how to do it elsewhere.
>
> On Mon, Apr 2, 2012 at 11:26 PM, navin_agrawal_1
> <navin_agrawal_1@...>wrote:
>
> > Not clear what an e-mail client means....
> >
> > I want to attach an excel sheet to my post for a query...
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

1b.

Re: How do I attach an excel file to my message?

Posted by: "dguillett1" dguillett1@gmail.com   donaldb36

Tue Apr 3, 2012 5:40 am (PDT)

How are you reading this forum. Most of us use email to send/rec msgs and files. You can either post a file in the files area or simply attach to an email for all to see.

Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@gmail.com

From: navin_agrawal_1
Sent: Tuesday, April 03, 2012 7:24 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: How do I attach an excel file to my message?

Thanks Randy..... The tone of your message says a lot...

How do people in this group exchange attachments.... Maybe your group isn't equipped to exchange posts with attachments....

I am exchanging (both receiving & uploading for others) attachments with posts on other forums.... with a lot of positive results....

Thanks again....

--- In mailto:smf_addin%40yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The only time I've attached files is when sending mail from my GMail
> account. I don't know how to do it elsewhere.
>
> On Mon, Apr 2, 2012 at 11:26 PM, navin_agrawal_1
> <navin_agrawal_1@...>wrote:
>
> > Not clear what an e-mail client means....
> >
> > I want to attach an excel sheet to my post for a query...
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

1c.

Re: How do I attach an excel file to my message?

Posted by: "Sudhir Agarwal" Agarwal.sudhir@gmail.com   sudhir_agarwal1

Tue Apr 3, 2012 6:21 am (PDT)

If you are doing through Gmail or Yahoo or Hotmail (Any Webmail service, you
have to click the attach button and select the file.

If you are doing through Outlook, you can either follow the above step or
copy and paste the file in the message body.

Thanks,

Sudhir

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf
Of navin_agrawal_1
Sent: Tuesday, April 03, 2012 8:24 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: How do I attach an excel file to my message?

Thanks Randy..... The tone of your message says a lot...

How do people in this group exchange attachments.... Maybe your group isn't
equipped to exchange posts with attachments....

I am exchanging (both receiving & uploading for others) attachments with
posts on other forums.... with a lot of positive results....

Thanks again....

--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
Randy Harmelink <rharmelink@...> wrote:
>
> The only time I've attached files is when sending mail from my GMail
> account. I don't know how to do it elsewhere.
>
> On Mon, Apr 2, 2012 at 11:26 PM, navin_agrawal_1
> <navin_agrawal_1@...>wrote:
>
> > Not clear what an e-mail client means....
> >
> > I want to attach an excel sheet to my post for a query...
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

1d.

Re: How do I attach an excel file to my message?

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

Tue Apr 3, 2012 7:39 am (PDT)

I find it easy to do an attachment, and others have done it in this Yahoo
group. It's just that the Yahoo group itself doesn't have a mechanism to
attach a file when you post a message there.

You can always upload the file to the files area and refer to it.

On Tue, Apr 3, 2012 at 5:24 AM, navin_agrawal_1
<navin_agrawal_1@yahoo.com>wrote:

>
> I am exchanging (both receiving & uploading for others) attachments with
> posts on other forums.... with a lot of positive results....
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (8)

2a.

Problems with 10 year historical ROC

Posted by: "another_investor" steviejacobs@hotmail.com   another_investor

Tue Apr 3, 2012 7:34 am (PDT)

Hi Randy,

Firstly, thanks for the all your hard work, amazing support and technical skills.
I have been using your plug-in successfully for quite a few years now
(I have the latest version I belive RCH_Stock_Market_Functions-2.1.2012.02.02) but have recently started to have problems with the historic 10-year ROC% from "AdvFN-A" (references 7316 to 7325).

In its simplistic form, for Microsoft, this would be..

=RCHGetElementNumber("MSFT",7325)

No matter which company I choose, the result is always 'Error'.
Is there another source for 10-year historical ROC. ROE is the same I think from "AdvFN-A" (i.e. 7305) but I use MSN (i.e. 222) elements as a workaround.

Any help would be appreciated greatly.

Thanks!

Steve

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

2b.

Re: Problems with 10 year historical ROC

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

Tue Apr 3, 2012 8:47 am (PDT)

I just tried element 7325 and it worked fine here. Check out the AdvFN item
in the "Links" area of the group. It may solve your problem?

Be sure to run smfForceRecalculation after changing your IE settings, to
ensure that you will get a fresh copy of the web page.

On Tue, Apr 3, 2012 at 5:12 AM, another_investor
<steviejacobs@hotmail.com>wrote:

>
> Firstly, thanks for the all your hard work, amazing support and technical
> skills.
> I have been using your plug-in successfully for quite a few years now
> (I have the latest version I belive
> RCH_Stock_Market_Functions-2.1.2012.02.02) but have recently started to
> have problems with the historic 10-year ROC% from "AdvFN-A" (references
> 7316 to 7325).
>
> In its simplistic form, for Microsoft, this would be..
>
> =RCHGetElementNumber("MSFT",7325)
>
> No matter which company I choose, the result is always 'Error'.
> Is there another source for 10-year historical ROC. ROE is the same I
> think from "AdvFN-A" (i.e. 7305) but I use MSN (i.e. 222) elements as a
> workaround.
>
> Any help would be appreciated greatly.
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

2c.

Re: Problems with 10 year historical ROC

Posted by: "another_investor" steviejacobs@hotmail.com   another_investor

Wed Apr 4, 2012 12:43 am (PDT)

Hi Randy,

As you suspected, the issue was the setting within Internet Explorer as outlined in the post by Raver (shown below)

----------------------------------------------------------
In Internet Explorer : Tools, Internet Options, Security, Custom Level button
(for the zone that's currently highlighted); Find the 'Access Data Sources
Across Domains' option and set to 'Enable'. Click OK to save the settings
change.
----------------------------------------------------------

This solution resolved the issue fully so many, many thanks to both of you.
Your excellent plugin is the cornerstone to my investment approach currently returning over 30% per annum for 3.5 years ...

http://www.marketocracy.com/cgi-bin/WebObjects/Portfolio.woa/ps/FundPublicPage/source=MaAiEoClEjCdClNhMaKiAbDe

... so thanks!!!!!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> I just tried element 7325 and it worked fine here. Check out the AdvFN item
> in the "Links" area of the group. It may solve your problem?
>
> Be sure to run smfForceRecalculation after changing your IE settings, to
> ensure that you will get a fresh copy of the web page.
>
> On Tue, Apr 3, 2012 at 5:12 AM, another_investor
> <steviejacobs@...>wrote:
>
> >
> > Firstly, thanks for the all your hard work, amazing support and technical
> > skills.
> > I have been using your plug-in successfully for quite a few years now
> > (I have the latest version I belive
> > RCH_Stock_Market_Functions-2.1.2012.02.02) but have recently started to
> > have problems with the historic 10-year ROC% from "AdvFN-A" (references
> > 7316 to 7325).
> >
> > In its simplistic form, for Microsoft, this would be..
> >
> > =RCHGetElementNumber("MSFT",7325)
> >
> > No matter which company I choose, the result is always 'Error'.
> > Is there another source for 10-year historical ROC. ROE is the same I
> > think from "AdvFN-A" (i.e. 7305) but I use MSN (i.e. 222) elements as a
> > workaround.
> >
> > Any help would be appreciated greatly.
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

3a.

"Earnings" source not working?

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

Tue Apr 3, 2012 3:32 pm (PDT)

Hi,

RCHGetElementNumber is returning "Undefined" for all items from source: Earnings (1286 onwards). Is this broken?

Thanks
Manoj

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

3b.

Re: "Earnings" source not working?

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

Tue Apr 3, 2012 4:24 pm (PDT)

Sounds like you didn't unzip all of the files in the archives along with
the XLA file. The TXT files contain the element definitions. If they aren't
in the same folder as the XLA file, none of the elements will be defined.

On Tue, Apr 3, 2012 at 3:32 PM, mahluwa <mahluwa@yahoo.com> wrote:

>
> RCHGetElementNumber is returning "Undefined" for all items from source:
> Earnings (1286 onwards). Is this broken?
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

3c.

Re: "Earnings" source not working?

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

Tue Apr 3, 2012 4:45 pm (PDT)

Oh yes, that was the problem. A couple of TXT files were not present. Looks like I might have messed up while unzip'ing. Manually copied again and it works now.

Thanks for your help

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Sounds like you didn't unzip all of the files in the archives along with
> the XLA file. The TXT files contain the element definitions. If they aren't
> in the same folder as the XLA file, none of the elements will be defined.
>
> On Tue, Apr 3, 2012 at 3:32 PM, mahluwa <mahluwa@...> wrote:
>
> >
> > RCHGetElementNumber is returning "Undefined" for all items from source:
> > Earnings (1286 onwards). Is this broken?
> >
>

Back to top

Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

4a.

Enquiry of smfGetTagContent() function

Posted by: "ericckyuen" ericckyuen@gmail.com   ericckyuen

Tue Apr 3, 2012 11:48 pm (PDT)

Hi Randy,

I am using smfGetTagContent() function to extract some figures of the following table : http://www.aastocks.com/en/Stock/CompanyFundamental.aspx?CFType=6&symbol=00941

It goes fine for +ve figures with this command. e.g. =0+smfGetTagContent("http://www.aastocks.com/en/Stock/CompanyFundamental.aspx?CFType=6&symbol=00941","td",5,"> Interest Received")

However, it needs to change (td) to (span) for -ve figures, e.g.
=0-SUBSTITUTE(smfGetTagContent("http://www.aastocks.com/en/Stock/CompanyFundamental.aspx?CFType=6&symbol=00941","span",5,"> Interest Paid"),"-","")

How can I cater for both +ve or -ve figures in the command?
I am unable to retrieve the correct figure if I do not use "td" for +ve and "span" for -ve figure correctly.

Grateful if your advice, pls.

Best Regards,

Eric

Back to top

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

4b.

Re: Enquiry of smfGetTagContent() function

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

Wed Apr 4, 2012 12:07 am (PDT)

The easiest solution would be to just use RCHGetTableCell() on both. It
automatically removes HTML tags that are within the table cell.

Otherwise, you'd need to use the "td" version of smfGetTagContent() and
then use SUBSTITUTE() function to remove the <span...> and </span> portions
of the table cell.

On Tue, Apr 3, 2012 at 11:36 PM, ericckyuen <ericckyuen@gmail.com> wrote:

>
> I am using smfGetTagContent() function to extract some figures of the
> following table :
> http://www.aastocks.com/en/Stock/CompanyFundamental.aspx?CFType=6&symbol=00941
>
> It goes fine for +ve figures with this command. e.g. =0+smfGetTagContent("
> http://www.aastocks.com/en/Stock/CompanyFundamental.aspx?CFType=6&symbol=00941","td",5,">
> Interest Received")
>
> However, it needs to change (td) to (span) for -ve figures, e.g.
> =0-SUBSTITUTE(smfGetTagContent("
> http://www.aastocks.com/en/Stock/CompanyFundamental.aspx?CFType=6&symbol=00941","span",5,">
> Interest Paid"),"-","")
>
> How can I cater for both +ve or -ve figures in the command?
> I am unable to retrieve the correct figure if I do not use "td" for +ve
> and "span" for -ve figure correctly.
>
> Grateful if your advice, pls.
>

Back to top

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

Recent Activity

•  125
  New Members

Visit Your Group

Yahoo! News

Get it all here

Breaking news to

entertainment news

New business?

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

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