Minggu, 16 Februari 2014

[smf_addin] Digest Number 2969[1 Attachment]

14 New Messages

Digest #2969
1a
1b
Re: Why Don't Any Files Work? by "Randy Harmelink" rharmelink
1c
Re: Why Don't Any Files Work? by "Marc ." whichwaytobeach
2.1
Re: Want to Make Dividend Histogram by "Marc ." whichwaytobeach
3a
Re: Yahoo Advancers / Decliners by "Kim Blake" kim54blake
5a
Company Names by sbcath
5b
Re: Company Names by "Randy Harmelink" rharmelink
5c
5d
Re: Company Names by "Randy Harmelink" rharmelink

Messages

Sat Feb 15, 2014 2:38 pm (PST) . Posted by:

whichwaytobeach

Hello Randy,

I tried the find and replace all 'C:\User Name\Application Data\Microsoft\AddIns\RCH_Stock_Market_Functions.xla'!with nothing and what I get is the following message:


Microsoft Excel cannot find any data to replace.......


Am I misunderstanding the workaround?


Regards,


Marc

Sat Feb 15, 2014 2:50 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The string you need to find and replace will be dependent on what YOU have
as a prefix to the add-in functions on your worksheet. It's probably not
that string that I used as an example in the LINKS entry.

The smfFixLinks macro actually uses a wildcard character so it doesn't need
to know:

'*\RCH_Stock_Market_Functions.xla'!

On Sat, Feb 15, 2014 at 3:38 PM, <WHICHWAYTOBEACH@hotmail.com> wrote:

>
> I tried the find and replace all 'C:\User Name\Application
> Data\Microsoft&#92;AddIns&#92;RCH_Stock_Market_Functions.xla'!with nothing and
> what I get is the following message:
>
> Microsoft Excel cannot find any data to replace.......
>
> Am I misunderstanding the workaround?
>
>

Sat Feb 15, 2014 2:55 pm (PST) . Posted by:

"Marc ." whichwaytobeach

Bingo! Thanks, Randy. The * did the trick.
Regards,
Marc

To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sat, 15 Feb 2014 15:50:08 -0700
Subject: Re: [smf_addin] Why Don't Any Files Work?

The string you need to find and replace will be dependent on what YOU have as a prefix to the add-in functions on your worksheet. It's probably not that string that I used as an example in the LINKS entry.

The smfFixLinks macro actually uses a wildcard character so it doesn't need to know:

'*\RCH_Stock_Market_Functions.xla'!

On Sat, Feb 15, 2014 at 3:38 PM, <WHICHWAYTOBEACH@hotmail.com> wrote:

I tried the find and replace all 'C:\User
Name\Application Data\Microsoft&#92;AddIns&#92;RCH_Stock_Market_Functions.xla'!with nothing and what I get is the following message:

Microsoft Excel cannot find any data to replace.......
Am I misunderstanding the workaround?

Sat Feb 15, 2014 2:43 pm (PST) . Posted by:

"Marc ." whichwaytobeach

Thanks, Mike.

To: smf_addin@yahoogroups.com
From: mikemcq802@yahoo.com
Date: Sat, 15 Feb 2014 14:32:03 -0800
Subject: RE: [smf_addin] RE: Want to Make Dividend Histogram

A=Annual as opposed to Q=Quarterly.
Do you realize there is documentation for these things?
https://groups.yahoo.com/neo/groups/smf_addin/files

Sat Feb 15, 2014 3:35 pm (PST) . Posted by:

"Kim Blake" kim54blake

For us in Canada this site is more useful;

http://ca.finance.yahoo.com/advances

Sat Feb 15, 2014 3:39 pm (PST) . Posted by:

whichwaytobeach

Hello Randy,

Do you have a current version of the Key Ratio Comparison Table you made in 2006 & 2011?


Regards,


Marc

Sat Feb 15, 2014 5:15 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

What's wrong with the one in the FILES area? Looks like a few more S&P 500
items should be obsoleted. But what else?

On Sat, Feb 15, 2014 at 4:39 PM, <WHICHWAYTOBEACH@hotmail.com> wrote:

>
> Do you have a current version of the Key Ratio Comparison Table you made
> in 2006 & 2011?
>

Sat Feb 15, 2014 5:54 pm (PST) . Posted by:

"Marc ." whichwaytobeach

On my end ALL of the S&P 500 don't work. The Company, Industry & Sector appear to work.

To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sat, 15 Feb 2014 18:15:38 -0700
Subject: Re: [smf_addin] SMF-Template-Key Ratio Comparisons Table - Update File Please?

What's wrong with the one in the FILES area? Looks like a few more S&P 500 items should be obsoleted. But what else?

On Sat, Feb 15, 2014 at 4:39 PM, <WHICHWAYTOBEACH@hotmail.com> wrote:

Do you have a current version of the Key Ratio Comparison Table you made in 2006 & 2011?

Sat Feb 15, 2014 5:56 pm (PST) . Posted by:

"Marc ." whichwaytobeach



To: smf_addin@yahoogroups.com
From: WHICHWAYTOBEACH@HOTMAIL.COM
Date: Sat, 15 Feb 2014 17:54:49 -0800
Subject: RE: [smf_addin] SMF-Template-Key Ratio Comparisons Table - Update File Please?

On my end ALL of the S&P 500 don't work. The Company, Industry & Sector appear to work.

To: smf_addin@yahoogroups.com
From: rharmelink@gmail.com
Date: Sat, 15 Feb 2014 18:15:38 -0700
Subject: Re: [smf_addin] SMF-Template-Key Ratio Comparisons Table - Update File Please?

What's wrong with the one in the FILES area? Looks like a few more S&P 500 items should be obsoleted. But what else?

On Sat, Feb 15, 2014 at 4:39 PM, <WHICHWAYTOBEACH@hotmail.com> wrote:

Do you have a current version of the Key Ratio Comparison Table you made in 2006 & 2011?



Attachments with this message:
1 of 1 Photo(s)

Sat Feb 15, 2014 6:29 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Ahh. Your subject line says KEY ratios comparison, so I looked at the MSN
template:

SMF-Template-MSN-Key-Ratio-Comparisons.xls

You're looking at (no KEY in name):

SMF-Template-Reuters-Ratios-Comparison.xls

In any case, it appears both MSN and Reuters have dropped all of their S&P
500 statistics.

On Sat, Feb 15, 2014 at 6:54 PM, Marc . <WHICHWAYTOBEACH@hotmail.com> wrote:

>
> On my end ALL of the S&P 500 don't work. The Company, Industry & Sector
> appear to work.
>

Sat Feb 15, 2014 10:52 pm (PST) . Posted by:

sbcath

I've been using the RCHGetYahooQuotes(xxx, "n") function to retrieve the company name for a given ("xxx") ticker symbol. Very useful, but the company names retrieved are all truncated at 17 characters. As an alternative, the RCHGetElementNumber(xxx,13862) returns names that are more complete, but many of the returned names (not all) are in ALL CAPS format. That format comes across as shouting, and it's inconsistent (some all caps, some in the more proper title case). Any suggestions? Am I using the functions correctly?

Thanks for any help.

Sat Feb 15, 2014 10:56 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

The add-in is just returning what the data sources are providing. You could
try using EXCEL's PROPER() function to get rid of the upper case:

=PROPER(RCHGetElementNumber("IBM",13862))

On Sat, Feb 15, 2014 at 11:40 PM, <sbcath@comcast.net> wrote:

>
>
> I've been using the RCHGetYahooQuotes(xxx, "n") function to retrieve the
> company name for a given ("xxx") ticker symbol. Very useful, but the
> company names retrieved are all truncated at 17 characters. As an
> alternative, the RCHGetElementNumber(xxx,13862) returns names that are more
> complete, but many of the returned names (not all) are in ALL CAPS format.
> That format comes across as shouting, and it's inconsistent (some all caps,
> some in the more proper title case). Any suggestions? Am I using the
> functions correctly?
>
> Thanks for any help.
>
>
>

Sat Feb 15, 2014 11:10 pm (PST) . Posted by:

sbcath

Thanks, Randy -- that helps.

Do you ever sleep?

Sun Feb 16, 2014 12:37 am (PST) . Posted by:

"Randy Harmelink" rharmelink

No set schedule. I often sleep more during the day than I do at night.

On Sun, Feb 16, 2014 at 12:10 AM, <sbcath@comcast.net> wrote:

>
> Do you ever sleep?
>
Diposting oleh EXCEL FEED LEARNING di 00.39

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)