15 New Messages
Digest #2805
Messages
Fri Oct 11, 2013 4:27 am (PDT) . Posted by:
"Brent" freefaller6
Thanks Randy. And just so you know, desktop sharing can be done without actually having the WebEx (or similar) software. I would simply send a link for you to click on, so as long as you have internet, you could see my screen. Not sure if that changes your mind, but thanks again.
Brent
On Thursday, October 10, 2013 9:55 PM, Randy Harmelink <rharmelink@gmail.com> wrote:
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.
>
Brent
On Thursday, October 10, 2013 9:55 PM, Randy Harmelink <rharmelink@gmail.
Sorry, but I don't have/do WebEx.
The calculation of 15012:'
Case "Rule #1 MOS Price"
n1 = RCHGetElementNumber
n2 = RCHGetElementNumber
n3 = RCHGetElementNumber
n4 = RCHGetElementNumber
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.
>
Fri Oct 11, 2013 7:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
AdvFN has been an issue the last few months. They are changing things, and
not doing it very well. I'm not really doing much with them until I'm sure
things have finalized.
On Thu, Oct 10, 2013 at 2:31 PM, <freefaller6@yahoo.com> wrote:
>
> Hi Randy, first, thanks for your help. I haven't ran through a
> spreadsheet since May 2013. At that time, I had no issues. I just pulled
> it up to check on the thing and it's full of errors. So I see now those
> values relying on the AdvFN have a new document defining how to set up
> formulas for this source.
>
> Is this new since May 2013?
>
not doing it very well. I'm not really doing much with them until I'm sure
things have finalized.
On Thu, Oct 10, 2013 at 2:31 PM, <freefaller6@
>
> Hi Randy, first, thanks for your help. I haven't ran through a
> spreadsheet since May 2013. At that time, I had no issues. I just pulled
> it up to check on the thing and it's full of errors. So I see now those
> values relying on the AdvFN have a new document defining how to set up
> formulas for this source.
>
> Is this new since May 2013?
>
Fri Oct 11, 2013 7:58 am (PDT) . Posted by:
dbltapp00
Bummer - they would be SO usefull.
Uhm... is there a version where they do?
Thanks.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
Those functions don't exist in version 2.0 of the add-in...
On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@... mailto:dbltapp00@...> 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
Uhm... is there a version where they do?
Thanks.
---In smf_addin@yahoogrou
Those functions don't exist in version 2.0 of the add-in...
On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@
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
Fri Oct 11, 2013 8:25 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Either the most recent official release in the FILES area of the group, or
the beta version (in the "Works in Progress" folder).
On Fri, Oct 11, 2013 at 7:58 AM, <dbltapp00@yahoo.com> wrote:
> Uhm... is there a version where they do?
>
> ---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
>
> Those functions don't exist in version 2.0 of the add-in...
>
> On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@...> 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
>
>
the beta version (in the "Works in Progress" folder).
On Fri, Oct 11, 2013 at 7:58 AM, <dbltapp00@yahoo.
> Uhm... is there a version where they do?
>
> ---In smf_addin@yahoogrou
>
> Those functions don't exist in version 2.0 of the add-in...
>
> On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@
>
>
> 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
>
>
Fri Oct 11, 2013 9:33 am (PDT) . Posted by:
dbltapp00
I'm using 2.0j, downloaded yesterday. Is it the entire 2.0 version that doesn't support the options functions? Were they ever functioning, and if so in which release?
Thanks
---In smf_addin@yahoogrou
Either the most recent official release in the FILES area of the group, or the beta version (in the "Works in Progress" folder).
On Fri, Oct 11, 2013 at 7:58 AM, <dbltapp00@
Uhm... is there a version where they do?
---In smf_addin@yahoogrou
Those functions don't exist in version 2.0 of the add-in...
On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@
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
Fri Oct 11, 2013 10:53 am (PDT) . Posted by:
dbltapp00
Never mind, I hadn't seen the 2.1 versions. Plugged it in and it's working for most input values. The only problem is when the strike price isn't a whole number ($7.5). Then it throws an error.
---In smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com> wrote:
Either the most recent official release in the FILES area of the group, or the beta version (in the "Works in Progress" folder).
On Fri, Oct 11, 2013 at 7:58 AM, <dbltapp00@... mailto:dbltapp00@...> wrote:
Uhm... is there a version where they do?
---In smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com, <smf_addin@yahoogroups.com mailto:smf_addin@yahoogroups.com> wrote:
Those functions don't exist in version 2.0 of the add-in...
On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@... mailto:dbltapp00@...> 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
---In smf_addin@yahoogrou
Either the most recent official release in the FILES area of the group, or the beta version (in the "Works in Progress" folder).
On Fri, Oct 11, 2013 at 7:58 AM, <dbltapp00@
Uhm... is there a version where they do?
---In smf_addin@yahoogrou
Those functions don't exist in version 2.0 of the add-in...
On Thu, Oct 10, 2013 at 5:55 PM, <dbltapp00@
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
Fri Oct 11, 2013 10:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you downloaded 2.0j from the Yahoo group yesterday, you got it from the
folder of archived/obsolete versions of the add-in.
On Fri, Oct 11, 2013 at 9:33 AM, <dbltapp00@yahoo.com> wrote:
> I'm using 2.0j, downloaded yesterday. Is it the entire 2.0 version that
> doesn't support the options functions? Were they ever functioning, and if
> so in which release?
>
folder of archived/obsolete versions of the add-in.
On Fri, Oct 11, 2013 at 9:33 AM, <dbltapp00@yahoo.
> I'm using 2.0j, downloaded yesterday. Is it the entire 2.0 version that
> doesn't support the options functions? Were they ever functioning, and if
> so in which release?
>
Fri Oct 11, 2013 10:57 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Details/example please. This works fine here:
=smfGetOptionQuotes("SPY 10/11 2013 $170.50 Call","b")
On Fri, Oct 11, 2013 at 10:53 AM, <dbltapp00@yahoo.com> wrote:
>
> Never mind, I hadn't seen the 2.1 versions. Plugged it in and it's working
> for most input values. The only problem is when the strike price isn't a
> whole number ($7.5). Then it throws an error.
>
=smfGetOptionQuotes
On Fri, Oct 11, 2013 at 10:53 AM, <dbltapp00@yahoo.
>
> Never mind, I hadn't seen the 2.1 versions. Plugged it in and it's working
> for most input values. The only problem is when the strike price isn't a
> whole number ($7.5). Then it throws an error.
>
Fri Oct 11, 2013 11:51 am (PDT) . Posted by:
dbltapp00
This works, including using b for bid and l for last: =smfGetOptionQuotes( "AAPL Oct 2013 $500 Call", "a"). Problem is, the values returned are wrong. Getting $2.70 to $2.80 values that never change when I update them, should be getting $3.20s.
Thanks for any help you can provide.
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
Details/example please. This works fine here:
=smfGetOptionQuotes("SPY 10/11 2013 $170.50 Call","b")
On Fri, Oct 11, 2013 at 10:53 AM, <dbltapp00@... mailto:dbltapp00@...> wrote:
Never mind, I hadn't seen the 2.1 versions. Plugged it in and it's working for most input values. The only problem is when the strike price isn't a whole number ($7.5). Then it throws an error.
Thanks for any help you can provide.
---In smf_addin@yahoogrou
Details/example please. This works fine here:
=smfGetOptionQuotes
On Fri, Oct 11, 2013 at 10:53 AM, <dbltapp00@
Never mind, I hadn't seen the 2.1 versions. Plugged it in and it's working for most input values. The only problem is when the strike price isn't a whole number ($7.5). Then it throws an error.
Fri Oct 11, 2013 9:10 am (PDT) . Posted by:
himanshuseth@ymail.com
I am new to this group and was working with the RCHGetElementNumber() spreadsheet. When I am populating the sheet I have trouble getting the values from 27-32, 547-550..so on so forth. I see these datas are pulled from MSN websites. I am able to get some other data from the MSN meanwhile like 41, 42.
Am I doing something wrong or is there any other way to pull those data. Any help in this regard would be appreciated
Thanks
Am I doing something wrong or is there any other way to pull those data. Any help in this regard would be appreciated
Thanks
Fri Oct 11, 2013 10:49 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
When MSN last redid their stock print page (which they do about once a
year), they dropped the performance (i.e. elements 27-32) and grading (i.e.
elements 547-550) sections from the web page, so that's why they no longer
work.
On Fri, Oct 11, 2013 at 9:10 AM, <himanshuseth@ymail.com> wrote:
> I am new to this group and was working with the RCHGetElementNumber()
> spreadsheet. When I am populating the sheet I have trouble getting the
> values from 27-32, 547-550..so on so forth. I see these datas are pulled
> from MSN websites. I am able to get some other data from the MSN meanwhile
> like 41, 42.
>
> Am I doing something wrong or is there any other way to pull those data.
> Any help in this regard would be appreciated
>
year), they dropped the performance (i.e. elements 27-32) and grading (i.e.
elements 547-550) sections from the web page, so that's why they no longer
work.
On Fri, Oct 11, 2013 at 9:10 AM, <himanshuseth@
> I am new to this group and was working with the RCHGetElementNumber
> spreadsheet. When I am populating the sheet I have trouble getting the
> values from 27-32, 547-550..so on so forth. I see these datas are pulled
> from MSN websites. I am able to get some other data from the MSN meanwhile
> like 41, 42.
>
> Am I doing something wrong or is there any other way to pull those data.
> Any help in this regard would be appreciated
>
Fri Oct 11, 2013 10:56 am (PDT) . Posted by:
himanshuseth@ymail.com
Appreciated !
---In smf_addin@yahoogroups.com, <rharmelink@...> wrote:
When MSN last redid their stock print page (which they do about once a year), they dropped the performance (i.e. elements 27-32) and grading (i.e. elements 547-550) sections from the web page, so that's why they no longer work.
On Fri, Oct 11, 2013 at 9:10 AM, <himanshuseth@... mailto:himanshuseth@...> wrote:
I am new to this group and was working with the RCHGetElementNumber() spreadsheet. When I am populating the sheet I have trouble getting the values from 27-32, 547-550..so on so forth. I see these datas are pulled from MSN websites. I am able to get some other data from the MSN meanwhile like 41, 42.
Am I doing something wrong or is there any other way to pull those data. Any help in this regard would be appreciated
---In smf_addin@yahoogrou
When MSN last redid their stock print page (which they do about once a year), they dropped the performance (i.e. elements 27-32) and grading (i.e. elements 547-550) sections from the web page, so that's why they no longer work.
On Fri, Oct 11, 2013 at 9:10 AM, <himanshuseth@
I am new to this group and was working with the RCHGetElementNumber
Am I doing something wrong or is there any other way to pull those data. Any help in this regard would be appreciated
Fri Oct 11, 2013 10:37 am (PDT) . Posted by:
"Craig" c1sander
This morning I'm getting "Error" messages when trying to update my option
quotes. Some options update just fine. Other do not. For example: SPY
options update fine, FB options do not. Anyone else having similar
problems.
Craig
quotes. Some options update just fine. Other do not. For example: SPY
options update fine, FB options do not. Anyone else having similar
problems.
Craig
Fri Oct 11, 2013 10:51 am (PDT) . Posted by:
"c1sander" c1sander
I should have been more specific. I'm using smf_GetOptionQuotes and having problems when I use ox2 or ox3 as the source. It does seem to work fine when I use Y as the source.
Craig
--- In smf_addin@yahoogroups.com, "Craig" <craig.sander@...> wrote:
>
> This morning I'm getting "Error" messages when trying to update my option
> quotes. Some options update just fine. Other do not. For example: SPY
> options update fine, FB options do not. Anyone else having similar
> problems.
>
>
>
> Craig
>
Craig
--- In smf_addin@yahoogrou
>
> This morning I'm getting "Error" messages when trying to update my option
> quotes. Some options update just fine. Other do not. For example: SPY
> options update fine, FB options do not. Anyone else having similar
> problems.
>
>
>
> Craig
>
Fri Oct 11, 2013 11:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Without specific examples, I don't have much to look at.
However, after fumbling around, I did note that there were no October or
November options listed on OptionsXPress for FB. So they may have a
temporary problem?
On Fri, Oct 11, 2013 at 10:37 AM, Craig <craig.sander@comcast.net> wrote:
>
> This morning I'm getting "Error" messages when trying to update my option
> quotes. Some options update just fine. Other do not. For example: SPY
> options update fine, FB options do not. Anyone else having similar
> problems.
>
However, after fumbling around, I did note that there were no October or
November options listed on OptionsXPress for FB. So they may have a
temporary problem?
On Fri, Oct 11, 2013 at 10:37 AM, Craig <craig.sander@
>
> This morning I'm getting "Error" messages when trying to update my option
> quotes. Some options update just fine. Other do not. For example: SPY
> options update fine, FB options do not. Anyone else having similar
> problems.
>
Tidak ada komentar:
Posting Komentar