4 New Messages
Digest #2377
Messages
Wed Oct 17, 2012 8:40 am (PDT) . Posted by:
"Ron Spruell" hashky
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
>>>
>>>
>>>
>
>
>
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:
>>>=RCHGetElementNu
>>>=RCHGetElementNu
>>>
>>>
>>>In the document pdf there are many command that not work
>>>
>>>
>>>Regards
>>>Jose
>>>
>>>
>>>
>
>
>
Wed Oct 17, 2012 9:45 am (PDT) . Posted by:
"Chris Ball" peggysue281
Randy-
Again thanks for all of your help and patience. I was able to correct the
issues and make the formula updates you suggested and model is running fine
now.
On Tue, Oct 16, 2012 at 12:04 PM, Randy Harmelink <rharmelink@gmail.com >wrote:
> **
>
>
> If you can't update the file, you're not going to be able to update the
> element definition.
>
> Can you delete the file first, before placing the new download file in the
> folder?
>
>
> On Tue, Oct 16, 2012 at 8:58 AM, Chris Ball <crball02@gmail.com > wrote:
>
>>
>> Thanks for your help Randy I appreciate it. In regards to updating the
>> element definition which was created on 5/12/12, I click save target as and
>> go to SMF folder I created and tell it to replace the file that already
>> exists and click ok. However for some reason it does not showing the
>> element as being updated afterward and therefore I still recieve the error
>> when running the model. I tried to copy the element and pasting directly
>> but I keep getting a message as that I do not have permission to update the
>> file. How do I update the element correctly?
>>
>
>
>
--
Thanks,
Chris Ball
Again thanks for all of your help and patience. I was able to correct the
issues and make the formula updates you suggested and model is running fine
now.
On Tue, Oct 16, 2012 at 12:04 PM, Randy Harmelink <rharmelink@gmail.
> **
>
>
> If you can't update the file, you're not going to be able to update the
> element definition.
>
> Can you delete the file first, before placing the new download file in the
> folder?
>
>
> On Tue, Oct 16, 2012 at 8:58 AM, Chris Ball <crball02@gmail.
>
>>
>> Thanks for your help Randy I appreciate it. In regards to updating the
>> element definition which was created on 5/12/12, I click save target as and
>> go to SMF folder I created and tell it to replace the file that already
>> exists and click ok. However for some reason it does not showing the
>> element as being updated afterward and therefore I still recieve the error
>> when running the model. I tried to copy the element and pasting directly
>> but I keep getting a message as that I do not have permission to update the
>> file. How do I update the element correctly?
>>
>
>
>
--
Thanks,
Chris Ball
Wed Oct 17, 2012 2:29 pm (PDT) . Posted by:
"oryxius" oryxius
Element 14052 which is the industry's Forward P/E does not seem to be working. It comes from Morningstar. Other Morningstar data points are coming through, but this element is always 0. Any fixes or alternative sites to get this ratio?
Thank you,
Moe
Thank you,
Moe
Wed Oct 17, 2012 2:34 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It appears Morningstar is no longer posting the Industry values:
http://quicktake.morningstar.com/Stock/ForwardValuation.asp?Symbol=MMM
I'm not aware of an alternative.
On Wed, Oct 17, 2012 at 2:29 PM, oryxius <oryxius@yahoo.com > wrote:
> Element 14052 which is the industry's Forward P/E does not seem to be
> working. It comes from Morningstar. Other Morningstar data points are
> coming through, but this element is always 0. Any fixes or alternative
> sites to get this ratio?
>
http://quicktake.
I'm not aware of an alternative.
On Wed, Oct 17, 2012 at 2:29 PM, oryxius <oryxius@yahoo.
> Element 14052 which is the industry's Forward P/E does not seem to be
> working. It comes from Morningstar. Other Morningstar data points are
> coming through, but this element is always 0. Any fixes or alternative
> sites to get this ratio?
>
Tidak ada komentar:
Posting Komentar