2 New Messages
Digest #2804
Messages
Thu Oct 10, 2013 6:52 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Those functions don't exist in version 2.0 of the add-in...
On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@yahoo.com> wrote:
>
> I'd really appreciate anyone telling me why these don't work in Excel 2007:
>
> =smfGetOptionQuotes( "AMT Oct 2013 $75 Call", "a",1)
>
> =smfGetYahooOptionQuote( "AMT","C",DATE(2013,10,19),75,"l")
>
> They both return #NAME?. Using smf version 2.0j
>
On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@yahoo.
>
> I'd really appreciate anyone telling me why these don't work in Excel 2007:
>
> =smfGetOptionQuotes
>
> =smfGetYahooOptionQ
>
> They both return #NAME?. Using smf version 2.0j
>
Thu Oct 10, 2013 6:55 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Sorry, but I don't have/do WebEx.
The calculation of 15012:'
Case "Rule #1 MOS Price"
n1 = RCHGetElementNumber(pTicker, 99) ' 5-Year High P/E
n2 = RCHGetElementNumber(pTicker, 102) ' 5-Year Low P/E
n3 = RCHGetElementNumber(pTicker, 44) ' Current EPS
n4 = RCHGetElementNumber(pTicker, 442) ' 5-Year Projected
Growth Rate
If n1 > 50 Then n1 = 50
n5 = FV(n4, 10, 0, -n3)
n6 = PV(0.15, 10, 0, -n5 * (n1 + n2) / 2) / 2
RCHSpecialExtraction = n6
On Thu, Oct 10, 2013 at 5:46 PM, <freefaller6@yahoo.com> wrote:
> Cool, I'll check it out, but your knowledge of code far exceeds mine. Are
> you open to a 10 minute webex next week? It may make more sense if I show
> you what I am doing. Basically, I built a sheet based on P. Town's Rule
> Number 1 to identify stocks that are currently undervalued. It's worked
> really well since March. I see Element 15012 is also set up to calculate
> the Rule Number 1 price too; I am curious where that is pulled from?
>
> I'll understand if that's a bit too much support, but let me know if
> you're interested in the webex and we can coordinate a good time.
>
The calculation of 15012:'
Case "Rule #1 MOS Price"
n1 = RCHGetElementNumber
n2 = RCHGetElementNumber
n3 = RCHGetElementNumber
n4 = RCHGetElementNumber
Growth Rate
If n1 > 50 Then n1 = 50
n5 = FV(n4, 10, 0, -n3)
n6 = PV(0.15, 10, 0, -n5 * (n1 + n2) / 2) / 2
RCHSpecialExtractio
On Thu, Oct 10, 2013 at 5:46 PM, <freefaller6@
> Cool, I'll check it out, but your knowledge of code far exceeds mine. Are
> you open to a 10 minute webex next week? It may make more sense if I show
> you what I am doing. Basically, I built a sheet based on P. Town's Rule
> Number 1 to identify stocks that are currently undervalued. It's worked
> really well since March. I see Element 15012 is also set up to calculate
> the Rule Number 1 price too; I am curious where that is pulled from?
>
> I'll understand if that's a bit too much support, but let me know if
> you're interested in the webex and we can coordinate a good time.
>
Tidak ada komentar:
Posting Komentar