15 New Messages
Digest #2687
3b
Re: does the macro security level on MS Excel 2010 affect the way SM by "Randy Harmelink" rharmelink
Messages
Tue Jul 9, 2013 2:56 am (PDT) . Posted by:
"Subu S" mail_to_subu
Hi Kermit
I think you are closest to my problem
I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz...) and a Win 7 Machine
1. I have downloaded SMF_Stock_market...Zip from files section of this group and copied it on to D:\SMF Add-In\
2. How do I get ALL of Randy's utilities to be automatically loaded every time my microsoft XL is open ? I don't see them auto loaded when XL is open
3. as of now I first double click RCH_Stock_Market_Functions.xla , keep it open before starting with Pete's sp sheets... or sample sp sheet .... but I see that opening RCH_Stock_Market_Functions.xla may NOT be the best solution , MAY NOT be loading ALL utilities, so how do I ensure that ALL of Randy's VBA including utils are loaded when XL is open ?
my brief searching on the net did NOT yield any help so posting here
regards
subu
--- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@...> wrote:
>
> I agree with Randy that is I have no clue why it is getting that error. Read my best guest below.
>
> The smfforcecalculate VBA code is in the modUtilities module. You might Verify it is known to VBA
> 1. click the developer task bar and
> 2. select Visual Basics
> 3. Expand the RCH_Stock_Market_Functions
> 4. Expand the Modules
> 5. Select and double click the ModUtilities
> 6. Smfforcecalculate is the first sub in the module.
>
> I’m pretty sure it is there. VBA has rules about calling other projects. I ran into that when I was trying to call smfupdateDownloadTable. I ended up having to write this code. So it could be you will have to do the same for calling the Smfforcecalculate function.
>
> Sub Button1_Click()
> Clear_Form
> Application.Run "'C:\SMFADDIN\RCH_Stock_Market_Functions.xla'!modDownloadTable.smfUpdateDownloadTable"
> End Sub
>
> When I download and try to open the spreadsheet I get this error when changing the links to point to my location for SMF-ADDIN.
> The error the worksheet contains one or more invalid references. Such as an invalid path, etc. Unfortunately, Microsoft Excel fails to give any help as to where the invalid path might be.
> I suspect the error is because the attempt to go across VBA projects.
> I am in no way a VBA expert. I struggle with every error and end up calling my son for help.
>
> I tried changing the VBA code where it called the SMFrecalculate and it took excel down. I ended up having to delete the spreadsheet and start over. Sorry, I can’t resolve your problem.
> For whatever reason it does not like the call.
>
>
>
> From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
> Sent: Monday, July 08, 2013 2:34 PM
> To: smf_addin@yahoogroups.com
> Subject: Re: [smf_addin] Re: is it possible to run RCH functions from a USB drive ?
>
>
>
> You shouldn't get the compile error if you have the SMF add-in set up as a reference within the VBA project. It is an independent setting from the add-in manager of EXCEL.
>
> However, if the location of the SMF add-in is changing because it's on a USB drive (or even because it's located on a dynamic drive), the VBA compiler may have issues with that. I'm not sure, because I never do it.
>
> From your pictures, it looks like it should be working, so I am lost as to what the solution might be.
> On Mon, Jul 8, 2013 at 11:14 AM, Subu S <mail_to_subu@...> wrote:
> 5. I have then downloaded another XL sheet that uses the RCH_Stock_market_funtions
> 7. I need too update this file... meaning run the macros...meaning use the RCH_stock_market_functions
> 8. before I do that update (of portfolio # 1) i open portfolio #1 XL file, open VBA ALT + f11, click on tools - reference and check that RCH_Stock_market_functions IS checked
> 9. It is checked
> 10. when i run the refresh / update on the portfolio tracker file I still get this error http://flic.kr/p/f5hvkz
> 11. it says smfforcecalculate is missing ...
> 12. is smf force calculate supposed to be within the RCH_...bundle ?
> or what am I missing ?
>
I think you are closest to my problem
I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz.
1. I have downloaded SMF_Stock_market.
2. How do I get ALL of Randy's utilities to be automatically loaded every time my microsoft XL is open ? I don't see them auto loaded when XL is open
3. as of now I first double click RCH_Stock_Market_
my brief searching on the net did NOT yield any help so posting here
regards
subu
--- In smf_addin@yahoogrou
>
> I agree with Randy that is I have no clue why it is getting that error. Read my best guest below.
>
> The smfforcecalculate VBA code is in the modUtilities module. You might Verify it is known to VBA
> 1. click the developer task bar and
> 2. select Visual Basics
> 3. Expand the RCH_Stock_Market_
> 4. Expand the Modules
> 5. Select and double click the ModUtilities
> 6. Smfforcecalculate is the first sub in the module.
>
> I’m pretty sure it is there. VBA has rules about calling other projects. I ran into that when I was trying to call smfupdateDownloadTa
>
> Sub Button1_Click(
> Clear_Form
> Application.
> End Sub
>
> When I download and try to open the spreadsheet I get this error when changing the links to point to my location for SMF-ADDIN.
> The error the worksheet contains one or more invalid references. Such as an invalid path, etc. Unfortunately, Microsoft Excel fails to give any help as to where the invalid path might be.
> I suspect the error is because the attempt to go across VBA projects.
> I am in no way a VBA expert. I struggle with every error and end up calling my son for help.
>
> I tried changing the VBA code where it called the SMFrecalculate and it took excel down. I ended up having to delete the spreadsheet and start over. Sorry, I can’t resolve your problem.
> For whatever reason it does not like the call.
>
>
>
> From: smf_addin@yahoogrou
> Sent: Monday, July 08, 2013 2:34 PM
> To: smf_addin@yahoogrou
> Subject: Re: [smf_addin] Re: is it possible to run RCH functions from a USB drive ?
>
>
>
> You shouldn'
>
> However, if the location of the SMF add-in is changing because it's on a USB drive (or even because it's located on a dynamic drive), the VBA compiler may have issues with that. I'm not sure, because I never do it.
>
> From your pictures, it looks like it should be working, so I am lost as to what the solution might be.
> On Mon, Jul 8, 2013 at 11:14 AM, Subu S <mail_to_
> 5. I have then downloaded another XL sheet that uses the RCH_Stock_market_
> 7. I need too update this file... meaning run the macros...meaning use the RCH_stock_market_
> 8. before I do that update (of portfolio # 1) i open portfolio #1 XL file, open VBA ALT + f11, click on tools - reference and check that RCH_Stock_market_
> 9. It is checked
> 10. when i run the refresh / update on the portfolio tracker file I still get this error http://flic.
> 11. it says smfforcecalculate is missing ...
> 12. is smf force calculate supposed to be within the RCH_...bundle ?
> or what am I missing ?
>
Tue Jul 9, 2013 4:38 am (PDT) . Posted by:
"Subu S" mail_to_subu
Hi Kermit
I am NOT sure IF I was clear the last time, so the same post with some basic mods
I think you are closest to my problem
I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz...) and a Win 7 Machine
1. I have downloaded SMF_Stock_market...Zip from files section of this group and copied it on to D:\SMF Add-In\ .... THIS IS IMPORTANT - because now the SMG functions are on a fixed drive. Not USB, same drive letter every time
1.1. In XL I have opened "developer" then "add-ins" and opened the Stock market functions add in, and I can see that as in this example http://flic.kr/p/f6d7Ch or a closer look as in here http://flic.kr/p/f5XN7a
2. Still I do get a VBA error when I start pete's XL sheet
sample here : http://flic.kr/p/f6atN5 and or here http://flic.kr/p/f6atML
2.1. So I am assuming that SOME of the VBA is NOT being loaded !!
2.3. If that assumption is right, How do I get ALL of Randy's utilities to be automatically loaded every time my microsoft XL is open ? I don't see them auto loaded when XL is open
... # 3 ...deleted ....
4. I did check the "modules" as you mentioned and the VBA was there
please see here http://flic.kr/p/f6deru
and here http://flic.kr/p/f5Y2x4
5. my brief searching on the net did NOT yield any help so posting here
regards
subu
--- In smf_addin@yahoogroups.com , "Subu S" <mail_to_subu@...> wrote:
>
> Hi Kermit
>
> I think you are closest to my problem
>
> I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz...) and a Win 7 Machine
>
> 1. I have downloaded SMF_Stock_market...Zip from files section of this group and copied it on to D:\SMF Add-In\
>
> 2. How do I get ALL of Randy's utilities to be automatically loaded every time my microsoft XL is open ? I don't see them auto loaded when XL is open
>
> 3. as of now I first double click RCH_Stock_Market_Functions.xla , keep it open before starting with Pete's sp sheets... or sample sp sheet .... but I see that opening RCH_Stock_Market_Functions.xla may NOT be the best solution , MAY NOT be loading ALL utilities, so how do I ensure that ALL of Randy's VBA including utils are loaded when XL is open ?
>
>
> my brief searching on the net did NOT yield any help so posting here
>
>
>
> regards
>
> subu
>
>
>
>
>
>
> --- In smf_addin@yahoogroups.com , "Kermit W. Prather" <kermitp@> wrote:
> >
> > I agree with Randy that is I have no clue why it is getting that error. Read my best guest below.
> >
> > The smfforcecalculate VBA code is in the modUtilities module. You might Verify it is known to VBA
> > 1. click the developer task bar and
> > 2. select Visual Basics
> > 3. Expand the RCH_Stock_Market_Functions
> > 4. Expand the Modules
> > 5. Select and double click the ModUtilities
> > 6. Smfforcecalculate is the first sub in the module.
> >
> > I’m pretty sure it is there. VBA has rules about calling other projects. I ran into that when I was trying to call smfupdateDownloadTable. I ended up having to write this code. So it could be you will have to do the same for calling the Smfforcecalculate function.
> >
> > Sub Button1_Click()
> > Clear_Form
> > Application.Run "'C:\SMFADDIN\RCH_Stock_Market_Functions.xla'!modDownloadTable.smfUpdateDownloadTable"
> > End Sub
> >
> > When I download and try to open the spreadsheet I get this error when changing the links to point to my location for SMF-ADDIN.
> > The error the worksheet contains one or more invalid references. Such as an invalid path, etc. Unfortunately, Microsoft Excel fails to give any help as to where the invalid path might be.
> > I suspect the error is because the attempt to go across VBA projects.
> > I am in no way a VBA expert. I struggle with every error and end up calling my son for help.
> >
> > I tried changing the VBA code where it called the SMFrecalculate and it took excel down. I ended up having to delete the spreadsheet and start over. Sorry, I can’t resolve your problem.
> > For whatever reason it does not like the call.
> >
> >
> >
> > From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
> > Sent: Monday, July 08, 2013 2:34 PM
> > To: smf_addin@yahoogroups.com
> > Subject: Re: [smf_addin] Re: is it possible to run RCH functions from a USB drive ?
> >
> >
> >
> > You shouldn't get the compile error if you have the SMF add-in set up as a reference within the VBA project. It is an independent setting from the add-in manager of EXCEL.
> >
> > However, if the location of the SMF add-in is changing because it's on a USB drive (or even because it's located on a dynamic drive), the VBA compiler may have issues with that. I'm not sure, because I never do it.
> >
> > From your pictures, it looks like it should be working, so I am lost as to what the solution might be.
> > On Mon, Jul 8, 2013 at 11:14 AM, Subu S <mail_to_subu@> wrote:
> > 5. I have then downloaded another XL sheet that uses the RCH_Stock_market_funtions
> > 7. I need too update this file... meaning run the macros...meaning use the RCH_stock_market_functions
> > 8. before I do that update (of portfolio # 1) i open portfolio #1 XL file, open VBA ALT + f11, click on tools - reference and check that RCH_Stock_market_functions IS checked
> > 9. It is checked
> > 10. when i run the refresh / update on the portfolio tracker file I still get this error http://flic.kr/p/f5hvkz
> > 11. it says smfforcecalculate is missing ...
> > 12. is smf force calculate supposed to be within the RCH_...bundle ?
> > or what am I missing ?
> >
>
I am NOT sure IF I was clear the last time, so the same post with some basic mods
I think you are closest to my problem
I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz.
1. I have downloaded SMF_Stock_market.
1.1. In XL I have opened "developer&quo
2. Still I do get a VBA error when I start pete's XL sheet
sample here : http://flic.
2.1. So I am assuming that SOME of the VBA is NOT being loaded !!
2.3. If that assumption is right, How do I get ALL of Randy's utilities to be automatically loaded every time my microsoft XL is open ? I don't see them auto loaded when XL is open
... # 3 ...deleted ....
4. I did check the "modules" as you mentioned and the VBA was there
please see here http://flic.
and here http://flic.
5. my brief searching on the net did NOT yield any help so posting here
regards
subu
--- In smf_addin@yahoogrou
>
> Hi Kermit
>
> I think you are closest to my problem
>
> I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz.
>
> 1. I have downloaded SMF_Stock_market.
>
> 2. How do I get ALL of Randy's utilities to be automatically loaded every time my microsoft XL is open ? I don't see them auto loaded when XL is open
>
> 3. as of now I first double click RCH_Stock_Market_
>
>
> my brief searching on the net did NOT yield any help so posting here
>
>
>
> regards
>
> subu
>
>
>
>
>
>
> --- In smf_addin@yahoogrou
> >
> > I agree with Randy that is I have no clue why it is getting that error. Read my best guest below.
> >
> > The smfforcecalculate VBA code is in the modUtilities module. You might Verify it is known to VBA
> > 1. click the developer task bar and
> > 2. select Visual Basics
> > 3. Expand the RCH_Stock_Market_
> > 4. Expand the Modules
> > 5. Select and double click the ModUtilities
> > 6. Smfforcecalculate is the first sub in the module.
> >
> > I’m pretty sure it is there. VBA has rules about calling other projects. I ran into that when I was trying to call smfupdateDownloadTa
> >
> > Sub Button1_Click(
> > Clear_Form
> > Application.
> > End Sub
> >
> > When I download and try to open the spreadsheet I get this error when changing the links to point to my location for SMF-ADDIN.
> > The error the worksheet contains one or more invalid references. Such as an invalid path, etc. Unfortunately, Microsoft Excel fails to give any help as to where the invalid path might be.
> > I suspect the error is because the attempt to go across VBA projects.
> > I am in no way a VBA expert. I struggle with every error and end up calling my son for help.
> >
> > I tried changing the VBA code where it called the SMFrecalculate and it took excel down. I ended up having to delete the spreadsheet and start over. Sorry, I can’t resolve your problem.
> > For whatever reason it does not like the call.
> >
> >
> >
> > From: smf_addin@yahoogrou
> > Sent: Monday, July 08, 2013 2:34 PM
> > To: smf_addin@yahoogrou
> > Subject: Re: [smf_addin] Re: is it possible to run RCH functions from a USB drive ?
> >
> >
> >
> > You shouldn'
> >
> > However, if the location of the SMF add-in is changing because it's on a USB drive (or even because it's located on a dynamic drive), the VBA compiler may have issues with that. I'm not sure, because I never do it.
> >
> > From your pictures, it looks like it should be working, so I am lost as to what the solution might be.
> > On Mon, Jul 8, 2013 at 11:14 AM, Subu S <mail_to_
> > 5. I have then downloaded another XL sheet that uses the RCH_Stock_market_
> > 7. I need too update this file... meaning run the macros...meaning use the RCH_stock_market_
> > 8. before I do that update (of portfolio # 1) i open portfolio #1 XL file, open VBA ALT + f11, click on tools - reference and check that RCH_Stock_market_
> > 9. It is checked
> > 10. when i run the refresh / update on the portfolio tracker file I still get this error http://flic.
> > 11. it says smfforcecalculate is missing ...
> > 12. is smf force calculate supposed to be within the RCH_...bundle ?
> > or what am I missing ?
> >
>
Tue Jul 9, 2013 8:04 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Add-in are loaded when EXCEL is opened. But the EXCEL and VBA environments
are separate as far as the add-in file usage goes. Neither knows or cares
about the other.
It could be that pete's XL sheet had the add-in in a different location
when it was saved, so that is where it is looking for the library and not
finding it. So you get the compile error, because the library doesn't
exist? It doesn't care that it can be found somewhere else, because it's
not going to go looking for it other than where it was told it would be.
On Tue, Jul 9, 2013 at 4:38 AM, Subu S <mail_to_subu@yahoo.com > wrote:
>
> I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz...) and
> a Win 7 Machine
>
> 1. I have downloaded SMF_Stock_market...Zip from files section of this
> group and copied it on to D:\SMF Add-In\ .... THIS IS IMPORTANT - because
> now the SMG functions are on a fixed drive. Not USB, same drive letter
> every time
>
> 1.1. In XL I have opened "developer" then "add-ins" and opened the Stock
> market functions add in, and I can see that as in this example
> http://flic.kr/p/f6d7Ch or a closer look as in here
> http://flic.kr/p/f5XN7a
>
> 2. Still I do get a VBA error when I start pete's XL sheet
> sample here : http://flic.kr/p/f6atN5 and or here http://flic.kr/p/f6atML
>
> 2.1. So I am assuming that SOME of the VBA is NOT being loaded !!
>
> 2.3. If that assumption is right, How do I get ALL of Randy's utilities to
> be automatically loaded every time my microsoft XL is open ? I don't see
> them auto loaded when XL is open
>
> ... # 3 ...deleted ....
>
> 4. I did check the "modules" as you mentioned and the VBA was there
> please see here http://flic.kr/p/f6deru
> and here http://flic.kr/p/f5Y2x4
>
> 5. my brief searching on the net did NOT yield any help so posting here
>
are separate as far as the add-in file usage goes. Neither knows or cares
about the other.
It could be that pete's XL sheet had the add-in in a different location
when it was saved, so that is where it is looking for the library and not
finding it. So you get the compile error, because the library doesn't
exist? It doesn't care that it can be found somewhere else, because it's
not going to go looking for it other than where it was told it would be.
On Tue, Jul 9, 2013 at 4:38 AM, Subu S <mail_to_subu@
>
> I'm using MS Excel, MS Office Professional 2010 (Ver 14.0.6129.xyz.
> a Win 7 Machine
>
> 1. I have downloaded SMF_Stock_market.
> group and copied it on to D:\SMF Add-In\ .... THIS IS IMPORTANT - because
> now the SMG functions are on a fixed drive. Not USB, same drive letter
> every time
>
> 1.1. In XL I have opened "developer&quo
> market functions add in, and I can see that as in this example
> http://flic.
> http://flic.
>
> 2. Still I do get a VBA error when I start pete's XL sheet
> sample here : http://flic.
>
> 2.1. So I am assuming that SOME of the VBA is NOT being loaded !!
>
> 2.3. If that assumption is right, How do I get ALL of Randy's utilities to
> be automatically loaded every time my microsoft XL is open ? I don't see
> them auto loaded when XL is open
>
> ... # 3 ...deleted ....
>
> 4. I did check the "modules" as you mentioned and the VBA was there
> please see here http://flic.
> and here http://flic.
>
> 5. my brief searching on the net did NOT yield any help so posting here
>
Tue Jul 9, 2013 6:40 am (PDT) . Posted by:
"timbabear" timbabear
I have a field which has the following instruction set:
=RCHGetElementNumber(Ticker,13862)
It has stopped printing the company name, which used to be the result of element number 13862. What is the new element number which would give me the company name.
Remember, a rock is smarter than I am with this stuff.
Tim
=RCHGetElementNumbe
It has stopped printing the company name, which used to be the result of element number 13862. What is the new element number which would give me the company name.
Remember, a rock is smarter than I am with this stuff.
Tim
Tue Jul 9, 2013 8:05 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You need the new element definitions for MSN from the "Works in Progress"
folder. They changed the format of their web page in mid June.
See: http://finance.groups.yahoo.com/group/smf_addin/message/22683
On Tue, Jul 9, 2013 at 6:40 AM, timbabear <ddoyle3@tampabay.rr.com > wrote:
> I have a field which has the following instruction set:
> =RCHGetElementNumber(Ticker,13862)
>
> It has stopped printing the company name, which used to be the result of
> element number 13862. What is the new element number which would give me
> the company name.
>
folder. They changed the format of their web page in mid June.
See: http://finance.
On Tue, Jul 9, 2013 at 6:40 AM, timbabear <ddoyle3@tampabay.
> I have a field which has the following instruction set:
> =RCHGetElementNumbe
>
> It has stopped printing the company name, which used to be the result of
> element number 13862. What is the new element number which would give me
> the company name.
>
Tue Jul 9, 2013 7:17 am (PDT) . Posted by:
"Subu S" mail_to_subu
Hi
these are my current macro security levels / settings. does this affect the way RCH functions work ? http://flic.
IF so what is the ideal setting ?
Regards
subu
Tue Jul 9, 2013 8:09 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Those macro settings are irrelevant to an add-in. The fact that you added
the add-in means you've given it access/security (or it may be the VBA
setting?).
Disable with notification is proper. You don't want to allow every macro of
every workbook you open to be enabled. There are ways to indicate which
workbooks DON'T need notification. That is, workbooks you trust. But the
process is not an easy one to do, so I usually just enable them as I need
them.
It's one reason I have a personal add-in as well. I can more easily control
my macro security that way.
On Tue, Jul 9, 2013 at 7:17 AM, Subu S <mail_to_subu@yahoo.com > wrote:
>
> these are my current macro security levels / settings. does this affect
> the way RCH functions work ? http://flic.kr/p/f6hHqC
>
> IF so what is the ideal setting ?
>
the add-in means you've given it access/security (or it may be the VBA
setting?).
Disable with notification is proper. You don't want to allow every macro of
every workbook you open to be enabled. There are ways to indicate which
workbooks DON'T need notification. That is, workbooks you trust. But the
process is not an easy one to do, so I usually just enable them as I need
them.
It's one reason I have a personal add-in as well. I can more easily control
my macro security that way.
On Tue, Jul 9, 2013 at 7:17 AM, Subu S <mail_to_subu@
>
> these are my current macro security levels / settings. does this affect
> the way RCH functions work ? http://flic.
>
> IF so what is the ideal setting ?
>
Tue Jul 9, 2013 7:38 am (PDT) . Posted by:
"gshell422" gshell422
Does the smfGetMSNOptionQuote function work? I haven't been able to get it to work at all. I tried to use MSN Option quotes, as the Yahoo site does not list all the strike prices available (i.e. TQQQ Aug 81 and 82 calls are not listed on Yahoo, but are available at MSN and other sites).
I also tried to look at smfGetOXOptionQuote and smfGetGoogleOptionQuote documentation. Neither file was available.
Thanks
I also tried to look at smfGetOXOptionQuote and smfGetGoogleOptionQ
Thanks
Tue Jul 9, 2013 8:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
MSN changed their option symbol usage, so I haven't gone back and fixed it
for them. It seemed to be a little different each time I looked at them and
I wasn't willing to shoot for a moving target. Plus, given their obsession
to change things annually isn't a big incentive to update things.
Both of the documentation files you mention are available right now, so it
must have been a temporary Yahoo thing.
I typically use OptionsXPress these days, since the others have all had
noticeable gaps in either strike prices or expiration dates. Since OX
actually had customers trading the options, they have more incentive to
make sure things are accurate. However, they are a bit slower than the
others.
On Tue, Jul 9, 2013 at 7:38 AM, gshell422 <gshell422@yahoo.com > wrote:
> Does the smfGetMSNOptionQuote function work? I haven't been able to get it
> to work at all. I tried to use MSN Option quotes, as the Yahoo site does
> not list all the strike prices available (i.e. TQQQ Aug 81 and 82 calls are
> not listed on Yahoo, but are available at MSN and other sites).
>
> I also tried to look at smfGetOXOptionQuote and smfGetGoogleOptionQuote
> documentation. Neither file was available.
>
for them. It seemed to be a little different each time I looked at them and
I wasn't willing to shoot for a moving target. Plus, given their obsession
to change things annually isn't a big incentive to update things.
Both of the documentation files you mention are available right now, so it
must have been a temporary Yahoo thing.
I typically use OptionsXPress these days, since the others have all had
noticeable gaps in either strike prices or expiration dates. Since OX
actually had customers trading the options, they have more incentive to
make sure things are accurate. However, they are a bit slower than the
others.
On Tue, Jul 9, 2013 at 7:38 AM, gshell422 <gshell422@yahoo.
> Does the smfGetMSNOptionQuot
> to work at all. I tried to use MSN Option quotes, as the Yahoo site does
> not list all the strike prices available (i.e. TQQQ Aug 81 and 82 calls are
> not listed on Yahoo, but are available at MSN and other sites).
>
> I also tried to look at smfGetOXOptionQuote and smfGetGoogleOptionQ
> documentation. Neither file was available.
>
Tue Jul 9, 2013 8:38 am (PDT) . Posted by:
"gshell422" gshell422
Thanks,
The documentation for GetGoogle and GetOX showed up now. However, neither of them support prices for puts, calls only. GetMSN does not seem to work, and Yahoo doesn't list all available strike prices.
Any suggestions?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> MSN changed their option symbol usage, so I haven't gone back and fixed it
> for them. It seemed to be a little different each time I looked at them and
> I wasn't willing to shoot for a moving target. Plus, given their obsession
> to change things annually isn't a big incentive to update things.
>
> Both of the documentation files you mention are available right now, so it
> must have been a temporary Yahoo thing.
>
> I typically use OptionsXPress these days, since the others have all had
> noticeable gaps in either strike prices or expiration dates. Since OX
> actually had customers trading the options, they have more incentive to
> make sure things are accurate. However, they are a bit slower than the
> others.
>
> On Tue, Jul 9, 2013 at 7:38 AM, gshell422 <gshell422@...> wrote:
>
> > Does the smfGetMSNOptionQuote function work? I haven't been able to get it
> > to work at all. I tried to use MSN Option quotes, as the Yahoo site does
> > not list all the strike prices available (i.e. TQQQ Aug 81 and 82 calls are
> > not listed on Yahoo, but are available at MSN and other sites).
> >
> > I also tried to look at smfGetOXOptionQuote and smfGetGoogleOptionQuote
> > documentation. Neither file was available.
> >
>
The documentation for GetGoogle and GetOX showed up now. However, neither of them support prices for puts, calls only. GetMSN does not seem to work, and Yahoo doesn't list all available strike prices.
Any suggestions?
--- In smf_addin@yahoogrou
>
> MSN changed their option symbol usage, so I haven't gone back and fixed it
> for them. It seemed to be a little different each time I looked at them and
> I wasn't willing to shoot for a moving target. Plus, given their obsession
> to change things annually isn't a big incentive to update things.
>
> Both of the documentation files you mention are available right now, so it
> must have been a temporary Yahoo thing.
>
> I typically use OptionsXPress these days, since the others have all had
> noticeable gaps in either strike prices or expiration dates. Since OX
> actually had customers trading the options, they have more incentive to
> make sure things are accurate. However, they are a bit slower than the
> others.
>
> On Tue, Jul 9, 2013 at 7:38 AM, gshell422 <gshell422@
>
> > Does the smfGetMSNOptionQuot
> > to work at all. I tried to use MSN Option quotes, as the Yahoo site does
> > not list all the strike prices available (i.e. TQQQ Aug 81 and 82 calls are
> > not listed on Yahoo, but are available at MSN and other sites).
> >
> > I also tried to look at smfGetOXOptionQuote and smfGetGoogleOptionQ
> > documentation. Neither file was available.
> >
>
Tue Jul 9, 2013 8:53 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
There is an undocumented smfGetOX2OptionQuote() function, which does allow
access to put prices, but not the Greeks. It gets the data from a different
web page from OptionsXPress that doesn't need one to be logged in to access.
I almost always use the smfGetOptionQuotes() function, and let it decide
which of those "building block" functions to use. The documentation for
that function tells you what has been available for each in the past. I
typically use OX or OX2 as my data source, depending on what I'm going
after.
Have you gone over the option quotes item in the LINKS area of the group?
It has an overview of a number of utility functions for options. And they
can make using smfGetOptionQuotes() quite easy to use.
On Tue, Jul 9, 2013 at 8:38 AM, gshell422 <gshell422@yahoo.com > wrote:
>
> The documentation for GetGoogle and GetOX showed up now. However, neither
> of them support prices for puts, calls only. GetMSN does not seem to work,
> and Yahoo doesn't list all available strike prices.
>
> Any suggestions?
>
access to put prices, but not the Greeks. It gets the data from a different
web page from OptionsXPress that doesn't need one to be logged in to access.
I almost always use the smfGetOptionQuotes(
which of those "building block" functions to use. The documentation for
that function tells you what has been available for each in the past. I
typically use OX or OX2 as my data source, depending on what I'm going
after.
Have you gone over the option quotes item in the LINKS area of the group?
It has an overview of a number of utility functions for options. And they
can make using smfGetOptionQuotes(
On Tue, Jul 9, 2013 at 8:38 AM, gshell422 <gshell422@yahoo.
>
> The documentation for GetGoogle and GetOX showed up now. However, neither
> of them support prices for puts, calls only. GetMSN does not seem to work,
> and Yahoo doesn't list all available strike prices.
>
> Any suggestions?
>
Tue Jul 9, 2013 7:42 am (PDT) . Posted by:
"Lawrence" lawleesh
Hi
I am able to download data for =RCHGetElementNumber("AA",5601) but not =RCHGetElementNumber("AACC",5601), which returns an Error message. When I go to www.advfn.com, I see that AACC does have the data on the page. Could you pls advise?
Thanks
I am able to download data for =RCHGetElementNumbe
Thanks
Tue Jul 9, 2013 8:20 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
That's because AACC is a financial institution and uses different labels
for its line items. The elements aren't set up for the labels of financial
institutions.
A workaround would be:
=smfGetAdvFNElement("AACC";,"A",6,"net income from continuing operations")
...which for ticker symbol "AA" has an element definition of:
=smfGetAdvFNElement("AA","A",6,">net income (continuing operations)")
So you can see the labels are different...
On Tue, Jul 9, 2013 at 7:42 AM, Lawrence <lawrence.leesh@gmail.com > wrote:
>
> I am able to download data for =RCHGetElementNumber("AA",5601) but not
> =RCHGetElementNumber("AACC",5601), which returns an Error message. When I
> go to www.advfn.com, I see that AACC does have the data on the page.
> Could you pls advise?
>
for its line items. The elements aren't set up for the labels of financial
institutions.
A workaround would be:
=smfGetAdvFNElement
...which for ticker symbol "AA" has an element definition of:
=smfGetAdvFNElement
So you can see the labels are different...
On Tue, Jul 9, 2013 at 7:42 AM, Lawrence <lawrence.leesh@
>
> I am able to download data for =RCHGetElementNumbe
> =RCHGetElementNumbe
> go to www.advfn.com, I see that AACC does have the data on the page.
> Could you pls advise?
>
Tue Jul 9, 2013 8:29 am (PDT) . Posted by:
"Lawrence" lawleesh
Thanks Randy. I will try that. Besides financial institutions are there other types of companies that will have yet another set of labels that need to use this method to get results?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That's because AACC is a financial institution and uses different labels
> for its line items. The elements aren't set up for the labels of financial
> institutions.
>
> A workaround would be:
>
> =smfGetAdvFNElement("AACC";,"A",6,"net income from continuing operations")
>
> ...which for ticker symbol "AA" has an element definition of:
>
> =smfGetAdvFNElement("AA","A",6,">net income (continuing operations)")
>
> So you can see the labels are different...
>
> On Tue, Jul 9, 2013 at 7:42 AM, Lawrence <lawrence.leesh@...> wrote:
>
> >
> > I am able to download data for =RCHGetElementNumber("AA",5601) but not
> > =RCHGetElementNumber("AACC",5601), which returns an Error message. When I
> > go to www.advfn.com, I see that AACC does have the data on the page.
> > Could you pls advise?
> >
>
--- In smf_addin@yahoogrou
>
> That's because AACC is a financial institution and uses different labels
> for its line items. The elements aren't set up for the labels of financial
> institutions.
>
> A workaround would be:
>
> =smfGetAdvFNElement
>
> ...which for ticker symbol "AA" has an element definition of:
>
> =smfGetAdvFNElement
>
> So you can see the labels are different...
>
> On Tue, Jul 9, 2013 at 7:42 AM, Lawrence <lawrence.
>
> >
> > I am able to download data for =RCHGetElementNumbe
> > =RCHGetElementNumbe
> > go to www.advfn.com, I see that AACC does have the data on the page.
> > Could you pls advise?
> >
>
Tue Jul 9, 2013 8:47 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
It wouldn't surprise me if there are, but financial institutions are a big
group and the only one that comes to mind right off.
On Tue, Jul 9, 2013 at 8:29 AM, Lawrence <lawrence.leesh@gmail.com > wrote:
> Thanks Randy. I will try that. Besides financial institutions are there
> other types of companies that will have yet another set of labels that need
> to use this method to get results?
>
group and the only one that comes to mind right off.
On Tue, Jul 9, 2013 at 8:29 AM, Lawrence <lawrence.leesh@
> Thanks Randy. I will try that. Besides financial institutions are there
> other types of companies that will have yet another set of labels that need
> to use this method to get results?
>
Tidak ada komentar:
Posting Komentar