5 New Messages
Digest #2378
Messages
Thu Oct 18, 2012 5:41 am (PDT) . Posted by:
"Ron Spruell" hashky
Randy -
I can do Morningstar "Library Premium" Stock Screens and I get a webpage that I can copy and paste into Excel. As you can imagine "Library Premium" is not the same as "Premium" ($). The problem is that "Library Premium" does not return Ticker Symbols. It returns the Company Name. I wrote some Excel equations to extract the symbol, but they were only about 60% successful. It is easier just to manually extract time wise.
As you know "3M Co" is different than "3M Co." If I match the left 5 characters, I get an answer. The left 6 characters do not match. This is only one example.
Is there any charade like function (Sounds Like) in Excel that you know? Is there another way to extract the symbol?
I could always sign up for M* Premium.
Ron Spruell
I can do Morningstar "Library Premium" Stock Screens and I get a webpage that I can copy and paste into Excel. As you can imagine "Library Premium" is not the same as "Premium" ($). The problem is that "Library Premium" does not return Ticker Symbols. It returns the Company Name. I wrote some Excel equations to extract the symbol, but they were only about 60% successful. It is easier just to manually extract time wise.
As you know "3M Co" is different than "3M Co." If I match the left 5 characters, I get an answer. The left 6 characters do not match. This is only one example.
Is there any charade like function (Sounds Like) in Excel that you know? Is there another way to extract the symbol?
I could always sign up for M* Premium.
Ron Spruell
Thu Oct 18, 2012 5:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
On a similar listing, I suggested pulling the ticker symbol from the link
in the table cell with the name -- see:
http://finance.groups.yahoo.com/group/smf_addin/message/8961
On Thu, Oct 18, 2012 at 5:41 AM, Ron Spruell <hashky@yahoo.com > wrote:
>
> I can do Morningstar "Library Premium" Stock Screens and I get a webpage
> that I can copy and paste into Excel. As you can imagine "Library Premium"
> is not the same as "Premium" ($). The problem is that "Library Premium"
> does not return Ticker Symbols. It returns the Company Name. I wrote some
> Excel equations to extract the symbol, but they were only about 60%
> successful. It is easier just to manually extract time wise.
> As you know "3M Co" is different than "3M Co." If I match the left 5
> characters, I get an answer. The left 6 characters do not match. This is
> only one example.
>
> Is there any charade like function (Sounds Like) in Excel that you know?
> Is there another way to extract the symbol?
>
> I could always sign up for M* Premium.
>
>
in the table cell with the name -- see:
http://finance.
On Thu, Oct 18, 2012 at 5:41 AM, Ron Spruell <hashky@yahoo.
>
> I can do Morningstar "Library Premium" Stock Screens and I get a webpage
> that I can copy and paste into Excel. As you can imagine "Library Premium"
> is not the same as "Premium" ($). The problem is that "Library Premium"
> does not return Ticker Symbols. It returns the Company Name. I wrote some
> Excel equations to extract the symbol, but they were only about 60%
> successful. It is easier just to manually extract time wise.
> As you know "3M Co" is different than "3M Co." If I match the left 5
> characters, I get an answer. The left 6 characters do not match. This is
> only one example.
>
> Is there any charade like function (Sounds Like) in Excel that you know?
> Is there another way to extract the symbol?
>
> I could always sign up for M* Premium.
>
>
Thu Oct 18, 2012 1:08 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Ron, I got this window when I tried to open the file. Can you recheck it. At least my virus software thinks it is unsafe as does Microsoft office.
Kermit
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Ron Spruell
Sent: Wednesday, October 17, 2012 11:40 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Some suggest who have problems ...
The one I wrote is here:
http://bribg.pbworks.com/w/file/50396066/Step-by-Step SMF Add-In.doc
It is not referred to in Links, and it does not contain any sample equations. So, I take it back. I didn't write it.
Ron Spruell
_____
From: José Azevedo <jmazevedo@gmail.com >
To: Ron Spruell <hashky@yahoo.com >
Cc: "smf_addin@yahoogroups.com " <smf_addin@yahoogroups.com >
Sent: Monday, October 15, 2012 4:11 AM
Subject: Re: [smf_addin] Some suggest who have problems ...
Hi!
I find this doc by google.
I think it is well construct for Excel 2010. This doc should be in file group. But this is only a suggest.
In next 2 months I am going to try get some fundamental analysis. I hope make some experiences with stock market. Only start very slowly.
Many thanks
Obrigado
Jose
On 15 October 2012 01:52, Ron Spruell <hashky@yahoo.com > wrote:
Jose -
I wrote the Step-by-Step SMF Add-In.doc. I am glad you found it useful. I wrote it when I taught a small class of investors who thought they were interested in learning how to use Excel for getting stock data. I documented my experiences in my upgrade from Excel 2003 to Excel 2010. It took me a couple of days to get Excel 2010 not "locked down" and working with the Add-In. My target audience didn't have the regional problems.
Did you get the Step-by-Step from this group? I don't think that I ever uploaded it here.
Ron Spruell
_____
From: José Azevedo <jmazevedo@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, October 14, 2012 9:28 AM
Subject: [smf_addin] Some suggest who have problems ...
Hi!
Finally I have some success with Excel 2010.
Some suggest who start with Excel 2010.
1º I follow this doc: Step-by-Step SMF Add-In.doc Very good.
But... when I try... problems... and what are my problem???
2º Regional configuration.
In my country I have to change the "," by ";" and ... voilá... problem solved!
Ufa!!
Example: In this file: SMF-Addin-Combined-Documentation-010212_N.pdf
If I put this:
=RCHGetElementNumber("IBM", 941) I have a error, but if I put:
=RCHGetElementNumber("IBM"; 941) solved.
In the document pdf there are many command that not work
Regards
Jose
Kermit
From: smf_addin@yahoogrou
Sent: Wednesday, October 17, 2012 11:40 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Some suggest who have problems ...
The one I wrote is here:
http://bribg.
It is not referred to in Links, and it does not contain any sample equations. So, I take it back. I didn't write it.
Ron Spruell
_____
From: José Azevedo <jmazevedo@gmail.
To: Ron Spruell <hashky@yahoo.
Cc: "smf_addin@yahoogrou
Sent: Monday, October 15, 2012 4:11 AM
Subject: Re: [smf_addin] Some suggest who have problems ...
Hi!
I find this doc by google.
I think it is well construct for Excel 2010. This doc should be in file group. But this is only a suggest.
In next 2 months I am going to try get some fundamental analysis. I hope make some experiences with stock market. Only start very slowly.
Many thanks
Obrigado
Jose
On 15 October 2012 01:52, Ron Spruell <hashky@yahoo.
Jose -
I wrote the Step-by-Step SMF Add-In.doc. I am glad you found it useful. I wrote it when I taught a small class of investors who thought they were interested in learning how to use Excel for getting stock data. I documented my experiences in my upgrade from Excel 2003 to Excel 2010. It took me a couple of days to get Excel 2010 not "locked down" and working with the Add-In. My target audience didn't have the regional problems.
Did you get the Step-by-Step from this group? I don't think that I ever uploaded it here.
Ron Spruell
_____
From: José Azevedo <jmazevedo@gmail.
To: smf_addin@yahoogrou
Sent: Sunday, October 14, 2012 9:28 AM
Subject: [smf_addin] Some suggest who have problems ...
Hi!
Finally I have some success with Excel 2010.
Some suggest who start with Excel 2010.
1º I follow this doc: Step-by-Step SMF Add-In.doc Very good.
But... when I try... problems... and what are my problem???
2º Regional configuration.
In my country I have to change the "," by ";" and ... voilá... problem solved!
Ufa!!
Example: In this file: SMF-Addin-Combined-
If I put this:
=RCHGetElementNumbe
=RCHGetElementNumbe
In the document pdf there are many command that not work
Regards
Jose
Thu Oct 18, 2012 5:00 pm (PDT) . Posted by:
"Ron Spruell" hashky
I wrote it and saved it using Libre Office. I just checked it with Avast Virus Scan. I am sure that M$ is just trying to protect it's territory.
I have attached a .pdf file if that makes you more comfortable.
>________________________________
> From: Kermit W. Prather <kermitp@tampabay.rr.com >
>To: smf_addin@yahoogroups.com
>Sent: Thursday, October 18, 2012 3:08 PM
>Subject: RE: [smf_addin] Some suggest who have problems ...
>
>
>
>Ron, I got this window when I tried to open the file. Can you recheck it. At least my virus software thinks it is unsafe as does Microsoft office.
>
>Kermit
>
>
>From:smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Ron Spruell
>Sent: Wednesday, October 17, 2012 11:40 AM
>To: smf_addin@yahoogroups.com
>Subject: Re: [smf_addin] Some suggest who have problems ...
>
>
>
>
>
>The one I wrote is here:
>
>http://bribg.pbworks.com/w/file/50396066/Step-by-Step SMF Add-In.doc
>
>It is not referred to in Links, and it does not contain any sample equations. So, I take it back. I didn't write it.
>
>Ron Spruell
>
>>
>>________________________________
>>
>>From:José Azevedo <jmazevedo@gmail.com >
>>To: Ron Spruell <hashky@yahoo.com >
>>Cc: "smf_addin@yahoogroups.com " <smf_addin@yahoogroups.com >
>>Sent: Monday, October 15, 2012 4:11 AM
>>Subject: Re: [smf_addin] Some suggest who have problems ...
>>
>>Hi!
>>
>>I find this doc by google.
>>I think it is well construct for Excel 2010. This doc should be in file group. But this is only a suggest.
>>
>>In next 2 months I am going to try get some fundamental analysis. I hope make some experiences with stock market. Only start very slowly.
>>
>>Many thanks
>>Obrigado
>>Jose
>>
>>On 15 October 2012 01:52, Ron Spruell <hashky@yahoo.com > wrote:
>>Jose -
>>
>>I wrote the Step-by-Step SMF Add-In.doc. I am glad you found it useful. I wrote it when I taught a small class of investors who thought they were interested in learning how to use Excel for getting stock data. I documented my experiences in my upgrade from Excel 2003 to Excel 2010. It took me a couple of days to get Excel 2010 not "locked down" and working with the Add-In. My target audience didn't have the regional problems.
>>
>>Did you get the Step-by-Step from this group? I don't think that I ever uploaded it here.
>>
>>Ron Spruell
>>
>>
>>________________________________
>>
>>From:José Azevedo <jmazevedo@gmail.com >
>>To: smf_addin@yahoogroups.com
>>Sent: Sunday, October 14, 2012 9:28 AM
>>Subject: [smf_addin] Some suggest who have problems ...
>>
>>
>>Hi!
>>
>>Finally I have some success with Excel 2010.
>>
>>Some suggest who start with Excel 2010.
>>
>>1º I follow this doc: Step-by-Step SMF Add-In.doc Very good.
>>
>>But... when I try... problems... and what are my problem???
>>
>>2º Regional configuration.
>>In my country I have to change the "," by ";" and ... voilá... problem solved!
>>Ufa!!
>>Example: In this file: SMF-Addin-Combined-Documentation-010212_N.pdf
>>If I put this:
>>=RCHGetElementNumber("IBM", 941) I have a error, but if I put:
>>=RCHGetElementNumber("IBM"; 941) solved.
>>
>>In the document pdf there are many command that not work
>>
>>Regards
>>Jose
>>
>>
>>
>
>
>
>
>
>
>
I have attached a .pdf file if that makes you more comfortable.
>___________
> From: Kermit W. Prather <kermitp@tampabay.
>To: smf_addin@yahoogrou
>Sent: Thursday, October 18, 2012 3:08 PM
>Subject: RE: [smf_addin] Some suggest who have problems ...
>
>
>
>Ron, I got this window when I tried to open the file. Can you recheck it. At least my virus software thinks it is unsafe as does Microsoft office.
>
>Kermit
>
>
>From:smf_addin@yahoogrou
>Sent: Wednesday, October 17, 2012 11:40 AM
>To: smf_addin@yahoogrou
>Subject: Re: [smf_addin] Some suggest who have problems ...
>
>
>
>
>
>The one I wrote is here:
>
>http://bribg.
>
>It is not referred to in Links, and it does not contain any sample equations. So, I take it back. I didn't write it.
>
>Ron Spruell
>
>>
>>__________
>>
>>From:José Azevedo <jmazevedo@gmail.
>>To: Ron Spruell <hashky@yahoo.
>>Cc: "smf_addin@yahoogrou
>>Sent: Monday, October 15, 2012 4:11 AM
>>Subject: Re: [smf_addin] Some suggest who have problems ...
>>
>>Hi!
>>
>>I find this doc by google.
>>I think it is well construct for Excel 2010. This doc should be in file group. But this is only a suggest.
>>
>>In next 2 months I am going to try get some fundamental analysis. I hope make some experiences with stock market. Only start very slowly.
>>
>>Many thanks
>>Obrigado
>>Jose
>>
>>On 15 October 2012 01:52, Ron Spruell <hashky@yahoo.
>>Jose -
>>
>>I wrote the Step-by-Step SMF Add-In.doc. I am glad you found it useful. I wrote it when I taught a small class of investors who thought they were interested in learning how to use Excel for getting stock data. I documented my experiences in my upgrade from Excel 2003 to Excel 2010. It took me a couple of days to get Excel 2010 not "locked down" and working with the Add-In. My target audience didn't have the regional problems.
>>
>>Did you get the Step-by-Step from this group? I don't think that I ever uploaded it here.
>>
>>Ron Spruell
>>
>>
>>__________
>>
>>From:José Azevedo <jmazevedo@gmail.
>>To: smf_addin@yahoogrou
>>Sent: Sunday, October 14, 2012 9:28 AM
>>Subject: [smf_addin] Some suggest who have problems ...
>>
>>
>>Hi!
>>
>>Finally I have some success with Excel 2010.
>>
>>Some suggest who start with Excel 2010.
>>
>>1º I follow this doc: Step-by-
>>
>>But... when I try... problems... and what are my problem???
>>
>>2º Regional configuration.
>>In my country I have to change the "," by ";" and ... voilá... problem solved!
>>Ufa!!
>>Example: In this file: SMF-Addin-
>>If I put this:
>>=RCHGetElementNum
>>=RCHGetElementNum
>>
>>In the document pdf there are many command that not work
>>
>>Regards
>>Jose
>>
>>
>>
>
>
>
>
>
>
>
Thu Oct 18, 2012 9:19 pm (PDT) . Posted by:
"Randy H" rharmelink
Take a look at the "Quickly Find All External Links In Your Worksheet" section of this newsletter:
http://www.theexcel
It may uncover some rogue links in one of your worksheets.
--- In smf_addin@yahoogrou
>
> so, there must bee something about that file. i has about 20-30
> sheets, most of which were copied from templates.
Tidak ada komentar:
Posting Komentar