15 New Messages
Digest #2421
1d
Re: Not able to get any of the templates to work - #name? query resp by "Randy Harmelink" rharmelink
Messages
Sun Dec 2, 2012 2:15 pm (PST) . Posted by:
"ddbohrer" ddbohrer
This is really strange. I seem to have to remove the added-in then re-establish it if I close the file
I then can get manual messages like =RCHGetElementNumber("Version")to work but I have the #Name? on everything that I don't retype in.
So the =RCHGetElementNumber("Version") will no longer work unless I cut and paste it back.
I'm using Microsoft 2003
It has to be something with the linking but not sure what.
Thanks
Daryll
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Tell me more about the error message?
>
> On Sun, Dec 2, 2012 at 2:24 PM, ddbohrer <ddbohrer@...> wrote:
>
> >
> > Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\smf add-in; 1)
> >
> > is the message that I get back
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > I'm confused as well. What do you get with:
> > >
> > > =RCHGetElementNumber("Version")
> > >
> > > On Sun, Dec 2, 2012 at 10:55 AM, ddbohrer <ddbohrer@> wrote:
> > >
> > > > I got it to partially work. If I follow your instructions. I still
> > get
> > > > the error message. However, if I go into each cell copy and repaste
> > it
> > > > back into the cell it works. confused
> >
>
I then can get manual messages like =RCHGetElementNumbe
So the =RCHGetElementNumbe
I'm using Microsoft 2003
It has to be something with the linking but not sure what.
Thanks
Daryll
--- In smf_addin@yahoogrou
>
> Tell me more about the error message?
>
> On Sun, Dec 2, 2012 at 2:24 PM, ddbohrer <ddbohrer@..
>
> >
> > Stock Market Functions add-in, Version 2.1.2012.02.
> >
> > is the message that I get back
> >
> > --- In smf_addin@yahoogrou
> > >
> > > I'm confused as well. What do you get with:
> > >
> > > =RCHGetElementNumbe
> > >
> > > On Sun, Dec 2, 2012 at 10:55 AM, ddbohrer <ddbohrer@> wrote:
> > >
> > > > I got it to partially work. If I follow your instructions. I still
> > get
> > > > the error message. However, if I go into each cell copy and repaste
> > it
> > > > back into the cell it works. confused
> >
>
Sun Dec 2, 2012 2:18 pm (PST) . Posted by:
"ddbohrer" ddbohrer
Also real strange that I can copy paste the same item like: =smfGetADVFNElement('Valuation '!$D$7,"A",10,">cost of sales<") and it will start working again. Seems like once I get the "NAME? error it is looked in this state until I recopy and past.
thanks
--- In smf_addin@yahoogroups.com , "ddbohrer" <ddbohrer@...> wrote:
>
> This is really strange. I seem to have to remove the added-in then re-establish it if I close the file
>
> I then can get manual messages like =RCHGetElementNumber("Version")to work but I have the #Name? on everything that I don't retype in.
>
> So the =RCHGetElementNumber("Version") will no longer work unless I cut and paste it back.
>
> I'm using Microsoft 2003
>
> It has to be something with the linking but not sure what.
>
> Thanks
> Daryll
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Tell me more about the error message?
> >
> > On Sun, Dec 2, 2012 at 2:24 PM, ddbohrer <ddbohrer@> wrote:
> >
> > >
> > > Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\smf add-in; 1)
> > >
> > > is the message that I get back
> > >
> > > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > > >
> > > > I'm confused as well. What do you get with:
> > > >
> > > > =RCHGetElementNumber("Version")
> > > >
> > > > On Sun, Dec 2, 2012 at 10:55 AM, ddbohrer <ddbohrer@> wrote:
> > > >
> > > > > I got it to partially work. If I follow your instructions. I still
> > > get
> > > > > the error message. However, if I go into each cell copy and repaste
> > > it
> > > > > back into the cell it works. confused
> > >
> >
>
thanks
--- In smf_addin@yahoogrou
>
> This is really strange. I seem to have to remove the added-in then re-establish it if I close the file
>
> I then can get manual messages like =RCHGetElementNumbe
>
> So the =RCHGetElementNumbe
>
> I'm using Microsoft 2003
>
> It has to be something with the linking but not sure what.
>
> Thanks
> Daryll
>
> --- In smf_addin@yahoogrou
> >
> > Tell me more about the error message?
> >
> > On Sun, Dec 2, 2012 at 2:24 PM, ddbohrer <ddbohrer@> wrote:
> >
> > >
> > > Stock Market Functions add-in, Version 2.1.2012.02.
> > >
> > > is the message that I get back
> > >
> > > --- In smf_addin@yahoogrou
> > > >
> > > > I'm confused as well. What do you get with:
> > > >
> > > > =RCHGetElementNumbe
> > > >
> > > > On Sun, Dec 2, 2012 at 10:55 AM, ddbohrer <ddbohrer@> wrote:
> > > >
> > > > > I got it to partially work. If I follow your instructions. I still
> > > get
> > > > > the error message. However, if I go into each cell copy and repaste
> > > it
> > > > > back into the cell it works. confused
> > >
> >
>
Sun Dec 2, 2012 2:41 pm (PST) . Posted by:
"ddbohrer" ddbohrer
I found a way to repeat the problem and fix it.
Everytime I start excel I need to go through the addin process again. Excel seems lose the link everytime I close it. Any ideas?
--- In smf_addin@yahoogroups.com , "ddbohrer" <ddbohrer@...> wrote:
>
> Also real strange that I can copy paste the same item like: =smfGetADVFNElement('Valuation '!$D$7,"A",10,">cost of sales<") and it will start working again. Seems like once I get the "NAME? error it is looked in this state until I recopy and past.
>
> thanks
>
> --- In smf_addin@yahoogroups.com , "ddbohrer" <ddbohrer@> wrote:
> >
> > This is really strange. I seem to have to remove the added-in then re-establish it if I close the file
> >
> > I then can get manual messages like =RCHGetElementNumber("Version")to work but I have the #Name? on everything that I don't retype in.
> >
> > So the =RCHGetElementNumber("Version") will no longer work unless I cut and paste it back.
> >
> > I'm using Microsoft 2003
> >
> > It has to be something with the linking but not sure what.
> >
> > Thanks
> > Daryll
> >
> > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > >
> > > Tell me more about the error message?
> > >
> > > On Sun, Dec 2, 2012 at 2:24 PM, ddbohrer <ddbohrer@> wrote:
> > >
> > > >
> > > > Stock Market Functions add-in, Version 2.1.2012.02.02 (C:\smf add-in; 1)
> > > >
> > > > is the message that I get back
> > > >
> > > > --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> > > > >
> > > > > I'm confused as well. What do you get with:
> > > > >
> > > > > =RCHGetElementNumber("Version")
> > > > >
> > > > > On Sun, Dec 2, 2012 at 10:55 AM, ddbohrer <ddbohrer@> wrote:
> > > > >
> > > > > > I got it to partially work. If I follow your instructions. I still
> > > > get
> > > > > > the error message. However, if I go into each cell copy and repaste
> > > > it
> > > > > > back into the cell it works. confused
> > > >
> > >
> >
>
Everytime I start excel I need to go through the addin process again. Excel seems lose the link everytime I close it. Any ideas?
--- In smf_addin@yahoogrou
>
> Also real strange that I can copy paste the same item like: =smfGetADVFNElement
>
> thanks
>
> --- In smf_addin@yahoogrou
> >
> > This is really strange. I seem to have to remove the added-in then re-establish it if I close the file
> >
> > I then can get manual messages like =RCHGetElementNumbe
> >
> > So the =RCHGetElementNumbe
> >
> > I'm using Microsoft 2003
> >
> > It has to be something with the linking but not sure what.
> >
> > Thanks
> > Daryll
> >
> > --- In smf_addin@yahoogrou
> > >
> > > Tell me more about the error message?
> > >
> > > On Sun, Dec 2, 2012 at 2:24 PM, ddbohrer <ddbohrer@> wrote:
> > >
> > > >
> > > > Stock Market Functions add-in, Version 2.1.2012.02.
> > > >
> > > > is the message that I get back
> > > >
> > > > --- In smf_addin@yahoogrou
> > > > >
> > > > > I'm confused as well. What do you get with:
> > > > >
> > > > > =RCHGetElementNumbe
> > > > >
> > > > > On Sun, Dec 2, 2012 at 10:55 AM, ddbohrer <ddbohrer@> wrote:
> > > > >
> > > > > > I got it to partially work. If I follow your instructions. I still
> > > > get
> > > > > > the error message. However, if I go into each cell copy and repaste
> > > > it
> > > > > > back into the cell it works. confused
> > > >
> > >
> >
>
Sun Dec 2, 2012 2:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
- Go in to the add-in manager and uncheck the add-in
- Exit EXCEL (hopefully this will remove any hanging registry pointers
related to the add-in)
- Restart EXCEL
- Go in to the add-in manager and re-add the add-in
- Exit EXCEL (to get a fresh start)
- Restart EXCEL
- Try some of the templates again...
In any case, I'm still confused...
BTW, you will always have unresolved links if you open up a workbook that
had the add-in in a different location. However, once you fix the
unresolved links and save the file, everything should be working when you
re-open the workbook you saved, because the add-in should be in the same
location as when the workbook was saved.
However, it will NOT fix unresolved links you get from opening the same
template again from the FILES area of the Yahoo group. Once you get them
from there, you will always get them from there -- because that workbook
was saved with the add-in in a different location than yours.
On Sun, Dec 2, 2012 at 3:40 PM, ddbohrer <ddbohrer@gmail.com > wrote:
> I found a way to repeat the problem and fix it.
>
> Everytime I start excel I need to go through the addin process again.
> Excel seems lose the link everytime I close it. Any ideas?
>
- Go in to the add-in manager and uncheck the add-in
- Exit EXCEL (hopefully this will remove any hanging registry pointers
related to the add-in)
- Restart EXCEL
- Go in to the add-in manager and re-add the add-in
- Exit EXCEL (to get a fresh start)
- Restart EXCEL
- Try some of the templates again...
In any case, I'm still confused...
BTW, you will always have unresolved links if you open up a workbook that
had the add-in in a different location. However, once you fix the
unresolved links and save the file, everything should be working when you
re-open the workbook you saved, because the add-in should be in the same
location as when the workbook was saved.
However, it will NOT fix unresolved links you get from opening the same
template again from the FILES area of the Yahoo group. Once you get them
from there, you will always get them from there -- because that workbook
was saved with the add-in in a different location than yours.
On Sun, Dec 2, 2012 at 3:40 PM, ddbohrer <ddbohrer@gmail.
> I found a way to repeat the problem and fix it.
>
> Everytime I start excel I need to go through the addin process again.
> Excel seems lose the link everytime I close it. Any ideas?
>
Sun Dec 2, 2012 3:10 pm (PST) . Posted by:
"bozo" calhandon
Thank you for the update Randy.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ]
Sent: Sunday, December 02, 2012 3:01 PM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] New file uploaded to smf_addin
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Works-In-Progress/smf-elements-6.txt
Uploaded by : rharmelink <rharmelink@gmail.com
<mailto:rharmelink%40gmail.com> >
Description : Contains updates to Zacks data element definitions, which had
to be redefined because of URL and page layout changes made by Zacks. These
definitions are used by the RCHGetElementNumber() function.
You can access this file at the URL:
http://groups.yahoo.com/group/smf_addin/files/Works-In-Progress/smf-elements
-6.txt
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/l/us/yahoo/groups/original/members/web/index.html
Regards,
rharmelink <rharmelink@gmail.com <mailto:rharmelink%40gmail.com> >
From: smf_addin@yahoogrou
Sent: Sunday, December 02, 2012 3:01 PM
To: smf_addin@yahoogrou
Subject: [smf_addin] New file uploaded to smf_addin
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Works-In-Progress/
Uploaded by : rharmelink <rharmelink@gmail.
<mailto:rharmelink%
Description : Contains updates to Zacks data element definitions, which had
to be redefined because of URL and page layout changes made by Zacks. These
definitions are used by the RCHGetElementNumber
You can access this file at the URL:
http://groups.
-6.txt
To learn more about file sharing for your group, please visit:
http://help.
Regards,
rharmelink <rharmelink@gmail.
Sun Dec 2, 2012 3:15 pm (PST) . Posted by:
"bozo" calhandon
> But why would they not include these individuals (with stakes > 5%) if
they are insiders?
If a person is not actually employed by the company, they would not be
classified as an "insider". Rather, they are simply shareholders like you
and me, with large holdings. When a person is both an employee AND a > 5%
shareholder, they fall into both categories. How each data provider
actually tallies their numbers may be different from others.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of oryxius
Sent: Sunday, December 02, 2012 1:53 AM
To: smf_addin@yahoogroups.com
Subject: [smf_addin] Re: Historical info on insider ownership
Thank you for the suggestions and the warning on large individual
stakeholders. I did notice that some sites have different numbers for the
insiders which puzzled me, and I think your note could explain the
disparity. But why would they not include these individuals (with stakes >
5%) if they are insiders?
Best,
Moe
--- In smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ,
"bozo" <bozo@...> wrote:
>
> > Does anyone know where one could get the insider ownership
>
> percentages for the past four quarters?
>
>
>
> Watch your numbers, as they may or may not include large individual
> stakeholders (> 5%). I would suggest you start at the company's Investor
> Relations web page, or email the Investor Relations contact.
>
>
>
> You might also try ...
>
>
>
> http://www.insider-monitor.com/search.html
>
>
>
> http://www.insidermonkey.com/
>
>
>
>
>
> ... or a Google search, something like ...
>
> "insider ownership" mcd (with the quotes)
>
>
>
>
>
> ... or the regular Financial sites ...
>
>
>
> http://finance.yahoo.com/q/ir?s=MCD+Insider+Roster (replace "MCD")
>
>
>
> http://www.nasdaq.com/symbol/mcd/insider-trades (replace "mcd")
>
>
>
>
>
http://investing.money.msn.com/investments/institutional-ownership?symbol=mc
> d (replace "mcd")
>
>
>
>
>
http://investing.businessweek.com/research/stocks/ownership/ownership.asp?ti
> cker=MCD (replace "MCD")
>
>
>
> http://research.scottrade.com/qnr/Public/Stocks/Insiders?symbol=MCD
> (replace "MCD")
>
>
>
> etc.
>
>
>
>
>
> As a last resort, look up the "Form 4" filings with the SEC, or at an
> EdgarOnline data distributor such as ...
>
>
>
> http://google.brand.edgar-online.com/?sym=MCD (replace "MCD")
>
>
>
> http://research.scottrade.com/qnr/Public/Stocks/SECFilings?symbol=MCD
> (replace "MCD")
>
>
>
> ... but you will need to figure out the totals manually.
>
>
>
> From: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
[mailto:smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com> ] On
Behalf
> Of oryxius
> Sent: Saturday, December 01, 2012 8:35 AM
> To: smf_addin@yahoogroups.com <mailto:smf_addin%40yahoogroups.com>
> Subject: [smf_addin] Historical info on insider ownership
>
>
>
>
>
> Does any one know where one could get the insider ownership percentages
for
> the past four quarters?
>
they are insiders?
If a person is not actually employed by the company, they would not be
classified as an "insider". Rather, they are simply shareholders like you
and me, with large holdings. When a person is both an employee AND a > 5%
shareholder, they fall into both categories. How each data provider
actually tallies their numbers may be different from others.
From: smf_addin@yahoogrou
Of oryxius
Sent: Sunday, December 02, 2012 1:53 AM
To: smf_addin@yahoogrou
Subject: [smf_addin] Re: Historical info on insider ownership
Thank you for the suggestions and the warning on large individual
stakeholders. I did notice that some sites have different numbers for the
insiders which puzzled me, and I think your note could explain the
disparity. But why would they not include these individuals (with stakes >
5%) if they are insiders?
Best,
Moe
--- In smf_addin@yahoogrou
"bozo" <bozo@...> wrote:
>
> > Does anyone know where one could get the insider ownership
>
> percentages for the past four quarters?
>
>
>
> Watch your numbers, as they may or may not include large individual
> stakeholders (> 5%). I would suggest you start at the company's Investor
> Relations web page, or email the Investor Relations contact.
>
>
>
> You might also try ...
>
>
>
> http://www.insider-
>
>
>
> http://www.insiderm
>
>
>
>
>
> ... or a Google search, something like ...
>
> "insider ownership" mcd (with the quotes)
>
>
>
>
>
> ... or the regular Financial sites ...
>
>
>
> http://finance.
>
>
>
> http://www.nasdaq.
>
>
>
>
>
http://investing.
> d (replace "mcd")
>
>
>
>
>
http://investing.
> cker=MCD (replace "MCD")
>
>
>
> http://research.
> (replace "MCD")
>
>
>
> etc.
>
>
>
>
>
> As a last resort, look up the "Form 4" filings with the SEC, or at an
> EdgarOnline data distributor such as ...
>
>
>
> http://google.
>
>
>
> http://research.
> (replace "MCD")
>
>
>
> ... but you will need to figure out the totals manually.
>
>
>
> From: smf_addin@yahoogrou
[mailto:smf_addin@yahoogrou
Behalf
> Of oryxius
> Sent: Saturday, December 01, 2012 8:35 AM
> To: smf_addin@yahoogrou
> Subject: [smf_addin] Historical info on insider ownership
>
>
>
>
>
> Does any one know where one could get the insider ownership percentages
for
> the past four quarters?
>
Sun Dec 2, 2012 4:02 pm (PST) . Posted by:
"José Azevedo" jma_resende
Hello!
It is possible to extract the value "*Your estimated value per share*"
in:
http://www.smartmoney.com/pricecheck/?story=worksheet&symbol=PNC
?
Some one know the formula's to calculate?
I think sometime there are a delay to calculate. It is possible to wait for
this delay and only after get the value?
If some one want to calculate the "Intrisic value", I already have this, if
there are interesting:
I share this:
B4= Stock symbol
=(RCHGetTableCell("http://www.zacks.com/stock/quote/ "&B4;1;"EPS Last
Year")*(8.5+2*RCHGetTableCell("http://www.zacks.com/stock/quote/ "&B4&"/detailed-estimate";1;"Next
5 Years"))*4.4)/RCHGetTableCell("
http://finance.yahoo.com/bonds/composite_bond_rates ";1;"Corporate
Bonds";"20yr AAA")
And this, using other fonts, but the formula are the same:
=(RCHGetTableCell("http://www.zacks.com/stock/quote/ "&B4;1;"EPS Last
Year")*(8.5+2*0+smfGetTagContent("
http://money.cnn.com/quote/forecast/forecast.html?symb=
"&B4;"span";1;">Annually";">Annually")*100)*4.4)/RCHGetTableCell("
http://finance.yahoo.com/bonds/composite_bond_rates ";1;"Corporate
Bonds";"20yr AAA")
This calculates are based in Graham's Formula: Intrinsic Value = EPS x (8.5
+ 2 G) x 4.4 / Y
But I search for other formula's to calculate the fair value, if someone
know others... but with all formulas...
I try to implement this:
Fair Value Calculator do www.gurufocus.com
http://www.gurufocus.com/fair_value_dcf.php
But I do not yet be able.
Thanks
Jose
It is possible to extract the value "*Your estimated value per share*"
in:
http://www.smartmon
?
Some one know the formula's to calculate?
I think sometime there are a delay to calculate. It is possible to wait for
this delay and only after get the value?
If some one want to calculate the "Intrisic value", I already have this, if
there are interesting:
I share this:
B4= Stock symbol
=(RCHGetTableCell(
Year")*(8.5+
5 Years"))*4.4)
http://finance.
Bonds";"20yr AAA")
And this, using other fonts, but the formula are the same:
=(RCHGetTableCell(
Year")*(8.5+
http://money.
"&B4;"span";
http://finance.
Bonds";"20yr AAA")
This calculates are based in Graham's Formula: Intrinsic Value = EPS x (8.5
+ 2 G) x 4.4 / Y
But I search for other formula's to calculate the fair value, if someone
know others... but with all formulas...
I try to implement this:
Fair Value Calculator do www.gurufocus.
http://www.gurufocu
But I do not yet be able.
Thanks
Jose
Sun Dec 2, 2012 4:33 pm (PST) . Posted by:
"Randy H" rharmelink
As you noted, it calculates after the page is displayed, so the data is
not on the page to be extracted. Your best bet would be to reverse
engineer their calculation. Based on the JavaScript, I think this is it:
function ValuationModel()
{
function geomSeries(rate, b, numPeriods)
{
var amount = 0;
if (rate == 1.0)
amount = numPeriods + 1;
else
amount = (Math.pow(rate, numPeriods + 1) - 1) / (rate - 1);
if (b >= 1)
amount -= geomSeries(rate, 0, b - 1);
return amount;
}
function futureValue(presentValue, rate, numPeriods)
{
return presentValue * Math.pow(1 + rate, numPeriods);
}
function presentValue(futureValue, discountRate, numPeriods)
{
return futureValue / Math.pow(1 + discountRate, numPeriods);
}
this.calcStockPrice = function(eps, short_term_growth_rate,
short_term, long_term_growth_rate, discount_rate)
{
if (long_term_growth_rate > discount_rate)
{
return "perpetual";
}
var short_term_value = eps * geomSeries((1 +
short_term_growth_rate) / (1 + discount_rate), 1, short_term);
var long_term_value = futureValue(eps, short_term_growth_rate,
short_term) * (1 + long_term_growth_rate) / (discount_rate -
long_term_growth_rate);
return short_term_value + presentValue(long_term_value,
discount_rate, short_term);
};
this.calcRiskAdjustedRate = function(beta, riskFreeRate,
benchmarkRate)
{
return (riskFreeRate / 100 + Math.max(.8, Math.abs(beta)) *
(benchmarkRate / 100 - riskFreeRate / 100)) * 100;
};
}
On Sun, Dec 2, 2012 at 5:02 PM, José Azevedo <jmazevedo@gmail.com
<mailto:jmazevedo@gmail.com > > wrote:
It is possible to extract the value "Your estimated value per share"
in:http://www.smartmoney.com/pricecheck/?story=worksheet&symbol=PNC
<http://www.smartmoney.com/pricecheck/?story=worksheet&symbol=PNC >
?Some one know the formula's to calculate?I think sometime there are a
delay to calculate. It is possible to wait for this delay and only after
get the value?
not on the page to be extracted. Your best bet would be to reverse
engineer their calculation. Based on the JavaScript, I think this is it:
function ValuationModel(
{
function geomSeries(rate, b, numPeriods)
{
var amount = 0;
if (rate == 1.0)
amount = numPeriods + 1;
else
amount = (Math.pow(rate, numPeriods + 1) - 1) / (rate - 1);
if (b >= 1)
amount -= geomSeries(rate, 0, b - 1);
return amount;
}
function futureValue(
{
return presentValue * Math.pow(1 + rate, numPeriods);
}
function presentValue(
{
return futureValue / Math.pow(1 + discountRate, numPeriods);
}
this.calcStockPrice = function(eps, short_term_growth_
short_term, long_term_growth_
{
if (long_term_growth_
{
return "perpetual";
}
var short_term_value = eps * geomSeries((
short_term_growth_
var long_term_value = futureValue(
short_term) * (1 + long_term_growth_
long_term_growth_
return short_term_value + presentValue(
discount_rate, short_term);
};
this.calcRiskAdjust
benchmarkRate)
{
return (riskFreeRate / 100 + Math.max(.8, Math.abs(beta)
(benchmarkRate / 100 - riskFreeRate / 100)) * 100;
};
}
On Sun, Dec 2, 2012 at 5:02 PM, José Azevedo <jmazevedo@gmail.
<mailto:jmazevedo@gmail.
It is possible to extract the value "Your estimated value per share"
in:http://www.smartmon
<http://www.smartmon
?Some one know the formula's to calculate?I think sometime there are a
delay to calculate. It is possible to wait for this delay and only after
get the value?
Sun Dec 2, 2012 4:26 pm (PST) . Posted by:
"kabrod77" mustang66.7599
Hi Randy
Downloaded the 12/2 smf-elements-6 file and replaced the old one and it
still does not work. I exited Excel twice and still no luck
Any ideas?
Downloaded the 12/2 smf-elements-
still does not work. I exited Excel twice and still no luck
Any ideas?
Sun Dec 2, 2012 4:37 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
What do you get for:
=RCHGetElementNumber("Version")
=smfGetAParms(849)
On Sun, Dec 2, 2012 at 5:26 PM, kabrod77 <kabrod77@verizon.net > wrote:
> *
> *
>
> *Downloaded the 12/2 smf-elements-6 file and replaced the old one and it
> still does not work. I exited Excel twice and still no luck*
>
> * *
>
> *Any ideas?*
>
=RCHGetElementNumbe
=smfGetAParms(
On Sun, Dec 2, 2012 at 5:26 PM, kabrod77 <kabrod77@verizon.
> *
> *
>
> *Downloaded the 12/2 smf-elements-
> still does not work. I exited Excel twice and still no luck*
>
> * *
>
> *Any ideas?*
>
Sun Dec 2, 2012 4:42 pm (PST) . Posted by:
"kabrod77" mustang66.7599
Stock Market Functions add-in, Version 2.1.2011.04.03
(C:\Users\KenB\AppData\Roaming\Microsoft\AddIns; 1)
Zacks;Target Price
Consensus;=RCHGetTableCell("http://www.zacks.com/stock/quote/~~~~~ ",1,">Aver
age Target Price")
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Randy Harmelink
Sent: Sunday, December 02, 2012 7:38 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] ZACK's
What do you get for:
=RCHGetElementNumber("Version")
=smfGetAParms(849)
On Sun, Dec 2, 2012 at 5:26 PM, kabrod77 <kabrod77@verizon.net > wrote:
B
Downloaded the 12/2 smf-elements-6 file and replaced the old one and it
still does not work. I exited Excel twice and still no luck
B
Any ideas?
(C:\Users\KenB\
Zacks;Target Price
Consensus;=RCHGetTa
age Target Price")
_____
From: smf_addin@yahoogrou
Of Randy Harmelink
Sent: Sunday, December 02, 2012 7:38 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] ZACK's
What do you get for:
=RCHGetElementNumbe
=smfGetAParms(
On Sun, Dec 2, 2012 at 5:26 PM, kabrod77 <kabrod77@verizon.
B
Downloaded the 12/2 smf-elements-
still does not work. I exited Excel twice and still no luck
B
Any ideas?
Sun Dec 2, 2012 4:47 pm (PST) . Posted by:
"kabrod77" mustang66.7599
Stock Market Functions add-in, Version 2.1.2011.04.03
(C:\Users\KenB\AppData\Roaming\Microsoft\AddIns; 1)
Zacks;Target Price
Consensus;=RCHGetTableCell("http://www.zacks.com/stock/quote/~~~~~ ",1,">Aver
age Target Price")
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Randy Harmelink
Sent: Sunday, December 02, 2012 7:38 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] ZACK's
What do you get for:
=RCHGetElementNumber("Version")
=smfGetAParms(849)
On Sun, Dec 2, 2012 at 5:26 PM, kabrod77 <kabrod77@verizon.net > wrote:
B
Downloaded the 12/2 smf-elements-6 file and replaced the old one and it
still does not work. I exited Excel twice and still no luck
B
Any ideas?
(C:\Users\KenB\
Zacks;Target Price
Consensus;=RCHGetTa
age Target Price")
_____
From: smf_addin@yahoogrou
Of Randy Harmelink
Sent: Sunday, December 02, 2012 7:38 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] ZACK's
What do you get for:
=RCHGetElementNumbe
=smfGetAParms(
On Sun, Dec 2, 2012 at 5:26 PM, kabrod77 <kabrod77@verizon.
B
Downloaded the 12/2 smf-elements-
still does not work. I exited Excel twice and still no luck
B
Any ideas?
Sun Dec 2, 2012 4:58 pm (PST) . Posted by:
"kabrod77" mustang66.7599
Nevermind!
When I saw the version number of the RCHGetElementNumber file I was using
compared to the one in the WIP folder I put the newer one in my add-in and
it works perfectly now
Thanks!
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Randy Harmelink
Sent: Sunday, December 02, 2012 7:38 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] ZACK's
What do you get for:
=RCHGetElementNumber("Version")
=smfGetAParms(849)
On Sun, Dec 2, 2012 at 5:26 PM, kabrod77 <kabrod77@verizon.net > wrote:
B
Downloaded the 12/2 smf-elements-6 file and replaced the old one and it
still does not work. I exited Excel twice and still no luck
B
Any ideas?
When I saw the version number of the RCHGetElementNumber file I was using
compared to the one in the WIP folder I put the newer one in my add-in and
it works perfectly now
Thanks!
_____
From: smf_addin@yahoogrou
Of Randy Harmelink
Sent: Sunday, December 02, 2012 7:38 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] ZACK's
What do you get for:
=RCHGetElementNumbe
=smfGetAParms(
On Sun, Dec 2, 2012 at 5:26 PM, kabrod77 <kabrod77@verizon.
B
Downloaded the 12/2 smf-elements-
still does not work. I exited Excel twice and still no luck
B
Any ideas?
Sun Dec 2, 2012 5:22 pm (PST) . Posted by:
"fredwwright" fredwwright
Can anyone advise me on how to update the Zacks elements. The ones I use mostly are:
848 - Zacks Rank
13873 - Zacks Recommendation
13885 - Average Broker Recommendation
13886 - Avg Brkr recc 1 week ago
13887 - number of anaylsts
850 - Industry Group name
851 - Ind Gr. Rank
852 - Rank in Industry
Finally, I was also pulling the next earnings date with
RCHGetTableCell("http://www.zacks.com/research/report.php?type=estimates&t= "&TICKER,1,"Next Report Date")
But that is no longer working as well.
Thanks for any advice.
Fred
848 - Zacks Rank
13873 - Zacks Recommendation
13885 - Average Broker Recommendation
13886 - Avg Brkr recc 1 week ago
13887 - number of anaylsts
850 - Industry Group name
851 - Ind Gr. Rank
852 - Rank in Industry
Finally, I was also pulling the next earnings date with
RCHGetTableCell(
But that is no longer working as well.
Thanks for any advice.
Fred
Sun Dec 2, 2012 5:30 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
For the element definitions, take a look at earlier messages today...
For the next earnings date:
=RCHGetTableCell("http://www.zacks.com/stock/quote/MMM ",1,"Next Earnings
Report Date")
On Sun, Dec 2, 2012 at 6:22 PM, fredwwright <fredwwright@yahoo.com > wrote:
> Can anyone advise me on how to update the Zacks elements. The ones I use
> mostly are:
>
> 848 - Zacks Rank
> 13873 - Zacks Recommendation
> 13885 - Average Broker Recommendation
> 13886 - Avg Brkr recc 1 week ago
> 13887 - number of anaylsts
> 850 - Industry Group name
> 851 - Ind Gr. Rank
> 852 - Rank in Industry
> Finally, I was also pulling the next earnings date with
>
> RCHGetTableCell("
> http://www.zacks.com/research/report.php?type=estimates&t= "&TICKER,1,"Next
> Report Date")
>
> But that is no longer working as well.
>
> Thanks for any advice.
>
For the next earnings date:
=RCHGetTableCell(
Report Date")
On Sun, Dec 2, 2012 at 6:22 PM, fredwwright <fredwwright@
> Can anyone advise me on how to update the Zacks elements. The ones I use
> mostly are:
>
> 848 - Zacks Rank
> 13873 - Zacks Recommendation
> 13885 - Average Broker Recommendation
> 13886 - Avg Brkr recc 1 week ago
> 13887 - number of anaylsts
> 850 - Industry Group name
> 851 - Ind Gr. Rank
> 852 - Rank in Industry
> Finally, I was also pulling the next earnings date with
>
> RCHGetTableCell(
> http://www.zacks.
> Report Date")
>
> But that is no longer working as well.
>
> Thanks for any advice.
>
Tidak ada komentar:
Posting Komentar