15 New Messages
Digest #2454
Messages
Tue Jan 1, 2013 4:39 am (PST) . Posted by:
"jcarlosd" jcarlosd
Well, after entering manually in the Web Query dialog, now it works.
But I am not happy with that, because of two problems:
- one regarding your method: I do not want to enter manually the Excel web query, because I want an automatic procedure; how can I do that with VBA? Perhaps this is out of the scope of this forum, but I just wanted to ask
- within my method, the click method works fine, but the problem is with the cache: if one country is selected and the page content is in the cache, when I enter in https://fundlab.credit-suisse.com/?disclaimer=no&change=true it does not show the form disclaimer, but the main page. Is it possible to override the cache to select a different country or to do it with an Excel web query?
Thanks for your help
J. Carlos
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Try using the EXCEL Web Query dialog (atl+d+d+w) to do the disclaimer. When
> you get to the page with the HTML table, then CANCEL out and try the add-in
> function...
>
> That works for me. I'm not sure why your VBA code isn't doing the trick. It
> looks like it should.
>
> Hmmm. For me, the "click" button doesn't show up until AFTER the country
> choice is selected. Is your VBA code trying to click on the button before
> it has appeared?
>
> On Mon, Dec 31, 2012 at 6:36 AM, jcarlosd <jcdelrio@...> wrote:
>
> > There is no other code between those two parts.
> > If I show the IE window ("objIE.Visible = True") when I do the "click", IE
> > accepts the submit and returns to the initial screen (
> > https://fundlab.credit-suisse.com/index.cfm? ).
> > Then I try to get the data (as any other URL without disclaimer) with
> > RCHGetHTMLTable, but it gets stopped at the disclaimer page again.
> >
> > It seems to me that the cookie is never set. I already had problems with
> > other URL, if you remember, and I could not resolve the issue. You told me
> > that once I enter with IE in the disclaimer page, cookie should be set. But
> > it is not working for me. How can I set it?
> >
> >
>
But I am not happy with that, because of two problems:
- one regarding your method: I do not want to enter manually the Excel web query, because I want an automatic procedure; how can I do that with VBA? Perhaps this is out of the scope of this forum, but I just wanted to ask
- within my method, the click method works fine, but the problem is with the cache: if one country is selected and the page content is in the cache, when I enter in https://fundlab.
Thanks for your help
J. Carlos
--- In smf_addin@yahoogrou
>
> Try using the EXCEL Web Query dialog (atl+d+d+w) to do the disclaimer. When
> you get to the page with the HTML table, then CANCEL out and try the add-in
> function...
>
> That works for me. I'm not sure why your VBA code isn't doing the trick. It
> looks like it should.
>
> Hmmm. For me, the "click" button doesn't show up until AFTER the country
> choice is selected. Is your VBA code trying to click on the button before
> it has appeared?
>
> On Mon, Dec 31, 2012 at 6:36 AM, jcarlosd <jcdelrio@..
>
> > There is no other code between those two parts.
> > If I show the IE window ("objIE.Visible = True") when I do the "click", IE
> > accepts the submit and returns to the initial screen (
> > https://fundlab.
> > Then I try to get the data (as any other URL without disclaimer) with
> > RCHGetHTMLTable, but it gets stopped at the disclaimer page again.
> >
> > It seems to me that the cookie is never set. I already had problems with
> > other URL, if you remember, and I could not resolve the issue. You told me
> > that once I enter with IE in the disclaimer page, cookie should be set. But
> > it is not working for me. How can I set it?
> >
> >
>
Tue Jan 1, 2013 5:45 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The Web Query Dialog is just an IE object, so you should be able to do it
with VBA.
As I mentioned in my last reply, I think you may just have a timing issue
with the selection of the country and the click of the button. When the IE
object is visible, you should be able to see the steps being taken, to
duplicate what the Web Query Dialog is doing.
If the cache is the problem, maybe you need to change your IE settings, to
always get new content when a web page is visited?
On Tue, Jan 1, 2013 at 5:39 AM, jcarlosd <jcdelrio@procesando.com > wrote:
> Well, after entering manually in the Web Query dialog, now it works.
>
> But I am not happy with that, because of two problems:
> - one regarding your method: I do not want to enter manually the Excel web
> query, because I want an automatic procedure; how can I do that with VBA?
> Perhaps this is out of the scope of this forum, but I just wanted to ask
> - within my method, the click method works fine, but the problem is with
> the cache: if one country is selected and the page content is in the cache,
> when I enter in
> https://fundlab.credit-suisse.com/?disclaimer=no&change=true it does not
> show the form disclaimer, but the main page. Is it possible to override the
> cache to select a different country or to do it with an Excel web query?
>
with VBA.
As I mentioned in my last reply, I think you may just have a timing issue
with the selection of the country and the click of the button. When the IE
object is visible, you should be able to see the steps being taken, to
duplicate what the Web Query Dialog is doing.
If the cache is the problem, maybe you need to change your IE settings, to
always get new content when a web page is visited?
On Tue, Jan 1, 2013 at 5:39 AM, jcarlosd <jcdelrio@procesando
> Well, after entering manually in the Web Query dialog, now it works.
>
> But I am not happy with that, because of two problems:
> - one regarding your method: I do not want to enter manually the Excel web
> query, because I want an automatic procedure; how can I do that with VBA?
> Perhaps this is out of the scope of this forum, but I just wanted to ask
> - within my method, the click method works fine, but the problem is with
> the cache: if one country is selected and the page content is in the cache,
> when I enter in
> https://fundlab.
> show the form disclaimer, but the main page. Is it possible to override the
> cache to select a different country or to do it with an Excel web query?
>
Tue Jan 1, 2013 9:57 am (PST) . Posted by:
"jcarlosd" jcarlosd
I fix my cache problems setting a different IE configuration (BTW, I did it with VBA inside my macro, reading and writing in Windows registry). As I told you before, there is no problem with the method of sending the click, though is not shown (I tested leaving the IE window visible).
However, SMF method is not affected by the cache settings (nor the disclaimer I tried to set and never got). I have IE version 8 and MS Excel 2003 (I prefer to use mature software)
In the tools-references, I see that the "Microsoft Internet Controls" file used is ieframe.dll with same IE version 8.00.7100.0.
SMF does not use it (am I wrong?) but is using "Microsoft HTML Object Library" mshtml.tlb or "Microsoft XML, v3.0" msxml3.dll.
Why SMF is not affected by the cache settings nor the disclaimer cookie?
Thaks for your patient
J. Carlos
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The Web Query Dialog is just an IE object, so you should be able to do it
> with VBA.
>
> As I mentioned in my last reply, I think you may just have a timing issue
> with the selection of the country and the click of the button. When the IE
> object is visible, you should be able to see the steps being taken, to
> duplicate what the Web Query Dialog is doing.
>
> If the cache is the problem, maybe you need to change your IE settings, to
> always get new content when a web page is visited?
>
> On Tue, Jan 1, 2013 at 5:39 AM, jcarlosd <jcdelrio@...> wrote:
>
> > Well, after entering manually in the Web Query dialog, now it works.
> >
> > But I am not happy with that, because of two problems:
> > - one regarding your method: I do not want to enter manually the Excel web
> > query, because I want an automatic procedure; how can I do that with VBA?
> > Perhaps this is out of the scope of this forum, but I just wanted to ask
> > - within my method, the click method works fine, but the problem is with
> > the cache: if one country is selected and the page content is in the cache,
> > when I enter in
> > https://fundlab.credit-suisse.com/?disclaimer=no&change=true it does not
> > show the form disclaimer, but the main page. Is it possible to override the
> > cache to select a different country or to do it with an Excel web query?
> >
>
However, SMF method is not affected by the cache settings (nor the disclaimer I tried to set and never got). I have IE version 8 and MS Excel 2003 (I prefer to use mature software)
In the tools-references, I see that the "Microsoft Internet Controls" file used is ieframe.dll with same IE version 8.00.7100.0.
SMF does not use it (am I wrong?) but is using "Microsoft HTML Object Library" mshtml.tlb or "Microsoft XML, v3.0" msxml3.dll.
Why SMF is not affected by the cache settings nor the disclaimer cookie?
Thaks for your patient
J. Carlos
--- In smf_addin@yahoogrou
>
> The Web Query Dialog is just an IE object, so you should be able to do it
> with VBA.
>
> As I mentioned in my last reply, I think you may just have a timing issue
> with the selection of the country and the click of the button. When the IE
> object is visible, you should be able to see the steps being taken, to
> duplicate what the Web Query Dialog is doing.
>
> If the cache is the problem, maybe you need to change your IE settings, to
> always get new content when a web page is visited?
>
> On Tue, Jan 1, 2013 at 5:39 AM, jcarlosd <jcdelrio@..
>
> > Well, after entering manually in the Web Query dialog, now it works.
> >
> > But I am not happy with that, because of two problems:
> > - one regarding your method: I do not want to enter manually the Excel web
> > query, because I want an automatic procedure; how can I do that with VBA?
> > Perhaps this is out of the scope of this forum, but I just wanted to ask
> > - within my method, the click method works fine, but the problem is with
> > the cache: if one country is selected and the page content is in the cache,
> > when I enter in
> > https://fundlab.
> > show the form disclaimer, but the main page. Is it possible to override the
> > cache to select a different country or to do it with an Excel web query?
> >
>
Tue Jan 1, 2013 11:10 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The add-in uses the XMLHTTP method from the MicroSoft XML, v3.0 library.
It could be that the IE object of the Web Query Dialog and the XMLHTTP
method are a different version of IE than the IE object you are using to
navigate the web page?
I'm at a loss.
On Tue, Jan 1, 2013 at 10:57 AM, jcarlosd <jcdelrio@procesando.com > wrote:
> I fix my cache problems setting a different IE configuration (BTW, I did
> it with VBA inside my macro, reading and writing in Windows registry). As I
> told you before, there is no problem with the method of sending the click,
> though is not shown (I tested leaving the IE window visible).
>
> However, SMF method is not affected by the cache settings (nor the
> disclaimer I tried to set and never got). I have IE version 8 and MS Excel
> 2003 (I prefer to use mature software)
>
> In the tools-references, I see that the "Microsoft Internet Controls" file
> used is ieframe.dll with same IE version 8.00.7100.0.
> SMF does not use it (am I wrong?) but is using "Microsoft HTML Object
> Library" mshtml.tlb or "Microsoft XML, v3.0" msxml3.dll.
>
> Why SMF is not affected by the cache settings nor the disclaimer cookie?
>
>
It could be that the IE object of the Web Query Dialog and the XMLHTTP
method are a different version of IE than the IE object you are using to
navigate the web page?
I'm at a loss.
On Tue, Jan 1, 2013 at 10:57 AM, jcarlosd <jcdelrio@procesando
> I fix my cache problems setting a different IE configuration (BTW, I did
> it with VBA inside my macro, reading and writing in Windows registry). As I
> told you before, there is no problem with the method of sending the click,
> though is not shown (I tested leaving the IE window visible).
>
> However, SMF method is not affected by the cache settings (nor the
> disclaimer I tried to set and never got). I have IE version 8 and MS Excel
> 2003 (I prefer to use mature software)
>
> In the tools-references, I see that the "Microsoft Internet Controls" file
> used is ieframe.dll with same IE version 8.00.7100.0.
> SMF does not use it (am I wrong?) but is using "Microsoft HTML Object
> Library" mshtml.tlb or "Microsoft XML, v3.0" msxml3.dll.
>
> Why SMF is not affected by the cache settings nor the disclaimer cookie?
>
>
Tue Jan 1, 2013 1:45 pm (PST) . Posted by:
"jcarlosd" jcarlosd
I tried with libraries XMLHTTP 4.0, 5.0 and 6.0 with no luck.
However, I was thinking that since extracting data with IE object works fine, if there was a way to use it instead the XMLHTTP.
And I found that there is an option in RCHGetURLData to use it. I did it that way and finally it seems to work (too late already: I'll check again tomorrow).
SMF really rocks!
What a great tool. Thanks for your development.
J. Carlos
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The add-in uses the XMLHTTP method from the MicroSoft XML, v3.0 library.
>
> It could be that the IE object of the Web Query Dialog and the XMLHTTP
> method are a different version of IE than the IE object you are using to
> navigate the web page?
>
> I'm at a loss.
>
> On Tue, Jan 1, 2013 at 10:57 AM, jcarlosd <jcdelrio@...> wrote:
>
> > I fix my cache problems setting a different IE configuration (BTW, I did
> > it with VBA inside my macro, reading and writing in Windows registry). As I
> > told you before, there is no problem with the method of sending the click,
> > though is not shown (I tested leaving the IE window visible).
> >
> > However, SMF method is not affected by the cache settings (nor the
> > disclaimer I tried to set and never got). I have IE version 8 and MS Excel
> > 2003 (I prefer to use mature software)
> >
> > In the tools-references, I see that the "Microsoft Internet Controls" file
> > used is ieframe.dll with same IE version 8.00.7100.0.
> > SMF does not use it (am I wrong?) but is using "Microsoft HTML Object
> > Library" mshtml.tlb or "Microsoft XML, v3.0" msxml3.dll.
> >
> > Why SMF is not affected by the cache settings nor the disclaimer cookie?
> >
> >
>
However, I was thinking that since extracting data with IE object works fine, if there was a way to use it instead the XMLHTTP.
And I found that there is an option in RCHGetURLData to use it. I did it that way and finally it seems to work (too late already: I'll check again tomorrow).
SMF really rocks!
What a great tool. Thanks for your development.
J. Carlos
--- In smf_addin@yahoogrou
>
> The add-in uses the XMLHTTP method from the MicroSoft XML, v3.0 library.
>
> It could be that the IE object of the Web Query Dialog and the XMLHTTP
> method are a different version of IE than the IE object you are using to
> navigate the web page?
>
> I'm at a loss.
>
> On Tue, Jan 1, 2013 at 10:57 AM, jcarlosd <jcdelrio@..
>
> > I fix my cache problems setting a different IE configuration (BTW, I did
> > it with VBA inside my macro, reading and writing in Windows registry). As I
> > told you before, there is no problem with the method of sending the click,
> > though is not shown (I tested leaving the IE window visible).
> >
> > However, SMF method is not affected by the cache settings (nor the
> > disclaimer I tried to set and never got). I have IE version 8 and MS Excel
> > 2003 (I prefer to use mature software)
> >
> > In the tools-references, I see that the "Microsoft Internet Controls" file
> > used is ieframe.dll with same IE version 8.00.7100.0.
> > SMF does not use it (am I wrong?) but is using "Microsoft HTML Object
> > Library" mshtml.tlb or "Microsoft XML, v3.0" msxml3.dll.
> >
> > Why SMF is not affected by the cache settings nor the disclaimer cookie?
> >
> >
>
Tue Jan 1, 2013 1:48 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I abandoned those other methods in RCHGetURLData(), because I got
significantly different results when I moved to a new computer, with a new
version of IE and and new version of EXCEL.
Interfacing with the IE object changes quite bit over the variation of
permutations of EXCEL and IE versions, so it wasn't a reliable thing to
base the add-in on.
On Tue, Jan 1, 2013 at 2:45 PM, jcarlosd <jcdelrio@procesando.com > wrote:
> However, I was thinking that since extracting data with IE object works
> fine, if there was a way to use it instead the XMLHTTP.
>
> And I found that there is an option in RCHGetURLData to use it. I did it
> that way and finally it seems to work (too late already: I'll check again
> tomorrow).
>
significantly different results when I moved to a new computer, with a new
version of IE and and new version of EXCEL.
Interfacing with the IE object changes quite bit over the variation of
permutations of EXCEL and IE versions, so it wasn't a reliable thing to
base the add-in on.
On Tue, Jan 1, 2013 at 2:45 PM, jcarlosd <jcdelrio@procesando
> However, I was thinking that since extracting data with IE object works
> fine, if there was a way to use it instead the XMLHTTP.
>
> And I found that there is an option in RCHGetURLData to use it. I did it
> that way and finally it seems to work (too late already: I'll check again
> tomorrow).
>
Tue Jan 1, 2013 6:09 am (PST) . Posted by:
"rho49m" rho49m
OK I have a problem, if I open this spreadsheet the array seems to be filled with "='C:\SMF Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B9:B27,C7:I7)
so I make a SMF Add-in folder in root and copy the add-in there. I enable the plug in in Excel, but all I get is a block of #NAME? Clearly I am missing something.
--- In smf_addin@yahoogroups.com , "rho49m" <rho49m@...> wrote:
>
>
> Thanks- that is service.
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
> >
> > In the FILES area of the group:
> >
> > Files > Templates and Examples > RCHGetYahooQuotes
> >
> >
> http://finance.groups.yahoo.com/group/smf_addin/files/Templates%20and%20\
> Examples/RCHGetYahooQuotes/
> >
> > On Mon, Dec 31, 2012 at 3:56 AM, rho49m rho49m@ wrote:
> >
> > > OK- but where do I find
> "RCHGetYahooQuotes-Example-Timed-Update.xls"?
> > > Tried your help file, Google search, site search but did not find
> it!
> > > Feeling pretty silly...
> > >
> >
>
so I make a SMF Add-in folder in root and copy the add-in there. I enable the plug in in Excel, but all I get is a block of #NAME? Clearly I am missing something.
--- In smf_addin@yahoogrou
>
>
> Thanks- that is service.
>
>
> --- In smf_addin@yahoogrou
> >
> > In the FILES area of the group:
> >
> > Files > Templates and Examples > RCHGetYahooQuotes
> >
> >
> http://finance.
> >
> > On Mon, Dec 31, 2012 at 3:56 AM, rho49m rho49m@ wrote:
> >
> > > OK- but where do I find
> "RCHGetYahooQuotes-
> > > Tried your help file, Google search, site search but did not find
> it!
> > > Feeling pretty silly...
> > >
> >
>
Tue Jan 1, 2013 6:21 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Check out the location errors item in the LINKS area of the group...
There should be no reason to move the add-in. Such location errors can
occur whenever you open someone else's workbooks.
On Tue, Jan 1, 2013 at 7:09 AM, rho49m <rho49m@yahoo.it > wrote:
> OK I have a problem, if I open this spreadsheet the array seems to be
> filled with "='C:\SMF
> Add-in\RCH_Stock_Market_Functions.xla'!RCHGetYahooQuotes(B9:B27,C7:I7)
> so I make a SMF Add-in folder in root and copy the add-in there. I enable
> the plug in in Excel, but all I get is a block of #NAME? Clearly I am
> missing something.
>
There should be no reason to move the add-in. Such location errors can
occur whenever you open someone else's workbooks.
On Tue, Jan 1, 2013 at 7:09 AM, rho49m <rho49m@yahoo.
> OK I have a problem, if I open this spreadsheet the array seems to be
> filled with "='C:\SMF
> Add-in\RCH_Stock_
> so I make a SMF Add-in folder in root and copy the add-in there. I enable
> the plug in in Excel, but all I get is a block of #NAME? Clearly I am
> missing something.
>
Tue Jan 1, 2013 11:12 am (PST) . Posted by:
"rho49m" rho49m
OK Think I have worked this out!
--- In smf_addin@yahoogrou
>
> OK I have a problem, if I open this spreadsheet the array seems to be filled with "='C:\SMF Add-in\RCH_Stock_
> so I make a SMF Add-in folder in root and copy the add-in there. I enable the plug in in Excel, but all I get is a block of #NAME? Clearly I am missing something.
>
>
>
> --- In smf_addin@yahoogrou
> >
> >
> > Thanks- that is service.
> >
> >
> > --- In smf_addin@yahoogrou
> > >
> > > In the FILES area of the group:
> > >
> > > Files > Templates and Examples > RCHGetYahooQuotes
> > >
> > >
> > http://finance.
> > >
> > > On Mon, Dec 31, 2012 at 3:56 AM, rho49m rho49m@ wrote:
> > >
> > > > OK- but where do I find
> > "RCHGetYahooQuotes-
> > > > Tried your help file, Google search, site search but did not find
> > it!
> > > > Feeling pretty silly...
> > > >
> > >
> >
>
Tue Jan 1, 2013 7:14 am (PST) . Posted by:
"cgrablew" cgrablew
Randy
I sent you an email about a problem with smfupdatetable stating that it was working for a couple of years and now stopped with ERRORs. I found out my wife hadn't open the in question spreadsheet since May so I downloaded the lastest addin (my previous addin was 2 or 3 yrs old) and it seemed to fix the issue except now smfupdatetable hangs when it encounters a stock symbol it doesn't find. I had AGL in the spreadsheet (GAS replace AGL) and it hung at that location for 8 hours. When I replace AGL with GAS it got passed that row and hung later on another stock. Is there a way I can get SMFUPDATETABLE to produce an error as opposed to hanging? Is it possible I re-loaded the addin wrong. I just overlayed the xla,xls and txt files in the original installed directory.
Also another minor issue was in Excel 2003 when I try to retrieve field 13873 (Zack Recommendation) it gives a VALUE error & with Excel 2010 it works!
Thanks
I sent you an email about a problem with smfupdatetable stating that it was working for a couple of years and now stopped with ERRORs. I found out my wife hadn't open the in question spreadsheet since May so I downloaded the lastest addin (my previous addin was 2 or 3 yrs old) and it seemed to fix the issue except now smfupdatetable hangs when it encounters a stock symbol it doesn't find. I had AGL in the spreadsheet (GAS replace AGL) and it hung at that location for 8 hours. When I replace AGL with GAS it got passed that row and hung later on another stock. Is there a way I can get SMFUPDATETABLE to produce an error as opposed to hanging? Is it possible I re-loaded the addin wrong. I just overlayed the xla,xls and txt files in the original installed directory.
Also another minor issue was in Excel 2003 when I try to retrieve field 13873 (Zack Recommendation) it gives a VALUE error & with Excel 2010 it works!
Thanks
Tue Jan 1, 2013 9:04 am (PST) . Posted by:
"Randy Harmelink" rharmelink
The missing ticker symbol problem is probably a Zacks element -- a similar
error was found last month, for a missing ticker symbol of POOSF:
http://finance.groups.yahoo.com/group/smf_addin/message/20475
Unfortunately, nothing I can do to handle it in the add-in.
Zack's Recommendation is no longer available, except as a premium data
element, so I couldn't redefine it based on their new web page layouts.
However, it is curious to me that it works on one machine and not the
other. Do both machines have the latest version of the add-in, with the new
element definitions? Note, however, that the Zack's Recommendation now
being returned is not what used to be returned. Or, at least that's what I
was told:
http://finance.groups.yahoo.com/group/smf_addin/message/20496
On Tue, Jan 1, 2013 at 8:14 AM, cgrablew <cgrablew@gmail.com > wrote:
>
> I sent you an email about a problem with smfupdatetable stating that it
> was working for a couple of years and now stopped with ERRORs. I found out
> my wife hadn't open the in question spreadsheet since May so I downloaded
> the lastest addin (my previous addin was 2 or 3 yrs old) and it seemed to
> fix the issue except now smfupdatetable hangs when it encounters a stock
> symbol it doesn't find. I had AGL in the spreadsheet (GAS replace AGL) and
> it hung at that location for 8 hours. When I replace AGL with GAS it got
> passed that row and hung later on another stock. Is there a way I can get
> SMFUPDATETABLE to produce an error as opposed to hanging? Is it possible I
> re-loaded the addin wrong. I just overlayed the xla,xls and txt files in
> the original installed directory.
>
> Also another minor issue was in Excel 2003 when I try to retrieve field
> 13873 (Zack Recommendation) it gives a VALUE error & with Excel 2010 it
> works!
>
error was found last month, for a missing ticker symbol of POOSF:
http://finance.
Unfortunately, nothing I can do to handle it in the add-in.
Zack's Recommendation is no longer available, except as a premium data
element, so I couldn't redefine it based on their new web page layouts.
However, it is curious to me that it works on one machine and not the
other. Do both machines have the latest version of the add-in, with the new
element definitions? Note, however, that the Zack's Recommendation now
being returned is not what used to be returned. Or, at least that's what I
was told:
http://finance.
On Tue, Jan 1, 2013 at 8:14 AM, cgrablew <cgrablew@gmail.
>
> I sent you an email about a problem with smfupdatetable stating that it
> was working for a couple of years and now stopped with ERRORs. I found out
> my wife hadn't open the in question spreadsheet since May so I downloaded
> the lastest addin (my previous addin was 2 or 3 yrs old) and it seemed to
> fix the issue except now smfupdatetable hangs when it encounters a stock
> symbol it doesn't find. I had AGL in the spreadsheet (GAS replace AGL) and
> it hung at that location for 8 hours. When I replace AGL with GAS it got
> passed that row and hung later on another stock. Is there a way I can get
> SMFUPDATETABLE to produce an error as opposed to hanging? Is it possible I
> re-loaded the addin wrong. I just overlayed the xla,xls and txt files in
> the original installed directory.
>
> Also another minor issue was in Excel 2003 when I try to retrieve field
> 13873 (Zack Recommendation) it gives a VALUE error & with Excel 2010 it
> works!
>
Tue Jan 1, 2013 12:12 pm (PST) . Posted by:
"cgrablew" cgrablew
Randy,
I did a little research and I was able to isolate the problem to the first Zack element 13890. The procedure hangs as soon as it hits it when it can't find the stock ticker symbol. If I take out the Zacks elements, the table update continues when it hits a bad ticker symbol. So it's exactly what you thought!
On the other issue, the 2 machines have the same addin - I actually copied it from the first machine which had Excel 2010 to the second machine that has excel 2003. I may update the second machine to Excel 2010 but I'm concerned the user (my wife) will freak out with the new menu structure in Excel 2010.
Thanks for you help,
Chuck Grablewski
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The missing ticker symbol problem is probably a Zacks element -- a similar
> error was found last month, for a missing ticker symbol of POOSF:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/20475
>
> Unfortunately, nothing I can do to handle it in the add-in.
>
> Zack's Recommendation is no longer available, except as a premium data
> element, so I couldn't redefine it based on their new web page layouts.
> However, it is curious to me that it works on one machine and not the
> other. Do both machines have the latest version of the add-in, with the new
> element definitions? Note, however, that the Zack's Recommendation now
> being returned is not what used to be returned. Or, at least that's what I
> was told:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/20496
>
> On Tue, Jan 1, 2013 at 8:14 AM, cgrablew <cgrablew@...> wrote:
>
> >
> > I sent you an email about a problem with smfupdatetable stating that it
> > was working for a couple of years and now stopped with ERRORs. I found out
> > my wife hadn't open the in question spreadsheet since May so I downloaded
> > the lastest addin (my previous addin was 2 or 3 yrs old) and it seemed to
> > fix the issue except now smfupdatetable hangs when it encounters a stock
> > symbol it doesn't find. I had AGL in the spreadsheet (GAS replace AGL) and
> > it hung at that location for 8 hours. When I replace AGL with GAS it got
> > passed that row and hung later on another stock. Is there a way I can get
> > SMFUPDATETABLE to produce an error as opposed to hanging? Is it possible I
> > re-loaded the addin wrong. I just overlayed the xla,xls and txt files in
> > the original installed directory.
> >
> > Also another minor issue was in Excel 2003 when I try to retrieve field
> > 13873 (Zack Recommendation) it gives a VALUE error & with Excel 2010 it
> > works!
> >
>
I did a little research and I was able to isolate the problem to the first Zack element 13890. The procedure hangs as soon as it hits it when it can't find the stock ticker symbol. If I take out the Zacks elements, the table update continues when it hits a bad ticker symbol. So it's exactly what you thought!
On the other issue, the 2 machines have the same addin - I actually copied it from the first machine which had Excel 2010 to the second machine that has excel 2003. I may update the second machine to Excel 2010 but I'm concerned the user (my wife) will freak out with the new menu structure in Excel 2010.
Thanks for you help,
Chuck Grablewski
--- In smf_addin@yahoogrou
>
> The missing ticker symbol problem is probably a Zacks element -- a similar
> error was found last month, for a missing ticker symbol of POOSF:
>
> http://finance.
>
> Unfortunately, nothing I can do to handle it in the add-in.
>
> Zack's Recommendation is no longer available, except as a premium data
> element, so I couldn't redefine it based on their new web page layouts.
> However, it is curious to me that it works on one machine and not the
> other. Do both machines have the latest version of the add-in, with the new
> element definitions? Note, however, that the Zack's Recommendation now
> being returned is not what used to be returned. Or, at least that's what I
> was told:
>
> http://finance.
>
> On Tue, Jan 1, 2013 at 8:14 AM, cgrablew <cgrablew@..
>
> >
> > I sent you an email about a problem with smfupdatetable stating that it
> > was working for a couple of years and now stopped with ERRORs. I found out
> > my wife hadn't open the in question spreadsheet since May so I downloaded
> > the lastest addin (my previous addin was 2 or 3 yrs old) and it seemed to
> > fix the issue except now smfupdatetable hangs when it encounters a stock
> > symbol it doesn't find. I had AGL in the spreadsheet (GAS replace AGL) and
> > it hung at that location for 8 hours. When I replace AGL with GAS it got
> > passed that row and hung later on another stock. Is there a way I can get
> > SMFUPDATETABLE to produce an error as opposed to hanging? Is it possible I
> > re-loaded the addin wrong. I just overlayed the xla,xls and txt files in
> > the original installed directory.
> >
> > Also another minor issue was in Excel 2003 when I try to retrieve field
> > 13873 (Zack Recommendation) it gives a VALUE error & with Excel 2010 it
> > works!
> >
>
Tue Jan 1, 2013 12:51 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I seem to recall EXCEL 2003 having an issue with another element that used
the new version of defining elements, where it had an internal limit of a
string's length that was less than later versions of EXCEL. So there could
be something like that going on...
Just as an FYI, you can double-check the version of the add-in that EXCEL
is using, with:
=RCHGetElementNumber("Version")
I have had situations where someone has multiple folders with different
versions of the add-in unzipped into them, and EXCEL is not pointing to the
one they thought it was.
On Tue, Jan 1, 2013 at 1:12 PM, cgrablew <cgrablew@gmail.com > wrote:
>
> On the other issue, the 2 machines have the same addin - I actually copied
> it from the first machine which had Excel 2010 to the second machine that
> has excel 2003. I may update the second machine to Excel 2010 but I'm
> concerned the user (my wife) will freak out with the new menu structure in
> Excel 2010.
>
the new version of defining elements, where it had an internal limit of a
string's length that was less than later versions of EXCEL. So there could
be something like that going on...
Just as an FYI, you can double-check the version of the add-in that EXCEL
is using, with:
=RCHGetElementNumbe
I have had situations where someone has multiple folders with different
versions of the add-in unzipped into them, and EXCEL is not pointing to the
one they thought it was.
On Tue, Jan 1, 2013 at 1:12 PM, cgrablew <cgrablew@gmail.
>
> On the other issue, the 2 machines have the same addin - I actually copied
> it from the first machine which had Excel 2010 to the second machine that
> has excel 2003. I may update the second machine to Excel 2010 but I'm
> concerned the user (my wife) will freak out with the new menu structure in
> Excel 2010.
>
Tue Jan 1, 2013 12:44 pm (PST) . Posted by:
"hathangz" hathangz
Is there a function that I can enter the ticker and the custom add-in will give the recent financial statement data i.e the balance sheet, income statement, and cash flows. I know there is a code to get each element, but I want to essentially type in the ticker in the code and it spits out whatever financial statement data is available on the website.
Thanks
Thanks
Tue Jan 1, 2013 1:45 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Check out the templates folder in the FILES area...
You're talking about multiple web pages worth of data. There's no reason to
get it all at once, since each piece can be gotten individually. There
would be no advantage to creating a function that retrieved everything --
it would still require the same number of web page retrievals. The add-in
functions are basically building blocks, so you can build what you want.
Having said that, the smfGetAdvFNElement-Template-All-Line-Items.xls
template is probably the closest to what you're asking for.
On Tue, Jan 1, 2013 at 1:15 PM, hathangz <rbalafx@gmail.com > wrote:
> Is there a function that I can enter the ticker and the custom add-in will
> give the recent financial statement data i.e the balance sheet, income
> statement, and cash flows. I know there is a code to get each element, but
> I want to essentially type in the ticker in the code and it spits out
> whatever financial statement data is available on the website.
>
You're talking about multiple web pages worth of data. There's no reason to
get it all at once, since each piece can be gotten individually. There
would be no advantage to creating a function that retrieved everything --
it would still require the same number of web page retrievals. The add-in
functions are basically building blocks, so you can build what you want.
Having said that, the smfGetAdvFNElement-
template is probably the closest to what you're asking for.
On Tue, Jan 1, 2013 at 1:15 PM, hathangz <rbalafx@gmail.
> Is there a function that I can enter the ticker and the custom add-in will
> give the recent financial statement data i.e the balance sheet, income
> statement, and cash flows. I know there is a code to get each element, but
> I want to essentially type in the ticker in the code and it spits out
> whatever financial statement data is available on the website.
>
Tidak ada komentar:
Posting Komentar