15 New Messages
Digest #2505
Messages
Mon Feb 11, 2013 8:21 am (PST) . Posted by:
"Randy Harmelink" rharmelink
How about:
=AVERAGE(RCHGetTableCell("http://finance.yahoo.com/q?s=VIX130522C00017000
",1,"Bid:"),RCHGetTableCell("http://finance.yahoo.com/q?s=VIX130522C00017000
",1,"Ask:"))
On Mon, Feb 11, 2013 at 8:50 AM, Steven sdavis81@yahoo.com > wrote:
> I am still having some trouble making this formula work.
>
> The URL is:
> http://finance.yahoo.com/q?s=VIX130522C00017000
>
> So there is a "?" mark in the URL which is corrected to formula:
>
> =AVERAGE(RCHGetTableCell("http://finance.yahoo.com/qs=VIX130522C00017000
> ",1,&quo...))
>
> This is still giving me a formula error message. I am not familiar with
> the syntax at the end of the formula, as I did not write it initially.
>
> Could you perhaps suggest the correct formula for yielding the average of
> the bid and ask for this option listed at this URL?
>
> Thanks again for looking, perhaps your insight will help me understand how
> to use this command better. I have read the documentation page for this
> command and cannot figure out how to do this correctly. Much appreciated.
>
=AVERAGE(RCHGetTabl
",1,"
",1,"
On Mon, Feb 11, 2013 at 8:50 AM, Steven sdavis81@yahoo.
> I am still having some trouble making this formula work.
>
> The URL is:
> http://finance.
>
> So there is a "?" mark in the URL which is corrected to formula:
>
> =AVERAGE(RCHGetTabl
> ",1,&quo.
>
> This is still giving me a formula error message. I am not familiar with
> the syntax at the end of the formula, as I did not write it initially.
>
> Could you perhaps suggest the correct formula for yielding the average of
> the bid and ask for this option listed at this URL?
>
> Thanks again for looking, perhaps your insight will help me understand how
> to use this command better. I have read the documentation page for this
> command and cannot figure out how to do this correctly. Much appreciated.
>
Mon Feb 11, 2013 9:37 am (PST) . Posted by:
"Steven" sdavis81
As usual,
Thanks so much,
I was trying to figure out how the other formula was constructed and this is more direct. Much appreciated.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> How about:
>
> =AVERAGE(RCHGetTableCell("http://finance.yahoo.com/q?s=VIX130522C00017000
> ",1,"Bid:"),RCHGetTableCell("http://finance.yahoo.com/q?s=VIX130522C00017000
> ",1,"Ask:"))
>
> On Mon, Feb 11, 2013 at 8:50 AM, Steven wrote:
>
> > I am still having some trouble making this formula work.
> >
> > The URL is:
> > http://finance.yahoo.com/q?s=VIX130522C00017000
> >
> > So there is a "?" mark in the URL which is corrected to formula:
> >
> > =AVERAGE(RCHGetTableCell("http://finance.yahoo.com/qs=VIX130522C00017000
> > ",1,&quo...))
> >
> > This is still giving me a formula error message. I am not familiar with
> > the syntax at the end of the formula, as I did not write it initially.
> >
> > Could you perhaps suggest the correct formula for yielding the average of
> > the bid and ask for this option listed at this URL?
> >
> > Thanks again for looking, perhaps your insight will help me understand how
> > to use this command better. I have read the documentation page for this
> > command and cannot figure out how to do this correctly. Much appreciated.
> >
>
Thanks so much,
I was trying to figure out how the other formula was constructed and this is more direct. Much appreciated.
--- In smf_addin@yahoogrou
>
> How about:
>
> =AVERAGE(RCHGetTabl
> ",1,"
> ",1,"
>
> On Mon, Feb 11, 2013 at 8:50 AM, Steven wrote:
>
> > I am still having some trouble making this formula work.
> >
> > The URL is:
> > http://finance.
> >
> > So there is a "?" mark in the URL which is corrected to formula:
> >
> > =AVERAGE(RCHGetTabl
> > ",1,&quo.
> >
> > This is still giving me a formula error message. I am not familiar with
> > the syntax at the end of the formula, as I did not write it initially.
> >
> > Could you perhaps suggest the correct formula for yielding the average of
> > the bid and ask for this option listed at this URL?
> >
> > Thanks again for looking, perhaps your insight will help me understand how
> > to use this command better. I have read the documentation page for this
> > command and cannot figure out how to do this correctly. Much appreciated.
> >
>
Mon Feb 11, 2013 8:33 am (PST) . Posted by:
"Jacob Jose" pepecan47
Randy, you are amazing. Thank you very much.
Regards,
Jose L. Jacob
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, February 10, 2013 10:29:43 AM
Subject: Re: [smf_addin] Dividends from Earnings.com
You'd need to retrieve a range of data and then sum up the premiums for that year. For example:
B2: 2010
B4:C22: =RCHGetYahooHistory("MMM",,,,,,,"v")
C2: =SUMPRODUCT(--(YEAR(B5:B22)=B2),C5:C22)
On Sun, Feb 10, 2013 at 8:09 AM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
>If I use RCHGetYahooHistory() to get the dividends history, how can I get the totals by year?
>
>If I have a cell with the value 2010 (for example), how can I get in another cell the sum al all dividends paid in 2010?
>
Regards,
Jose L. Jacob
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Sunday, February 10, 2013 10:29:43 AM
Subject: Re: [smf_addin] Dividends from Earnings.com
You'd need to retrieve a range of data and then sum up the premiums for that year. For example:
B2: 2010
B4:C22: =RCHGetYahooHistory
C2: =SUMPRODUCT(
On Sun, Feb 10, 2013 at 8:09 AM, Jacob Jose pepecan47@yahoo.
>
>If I use RCHGetYahooHistory(
>
>If I have a cell with the value 2010 (for example), how can I get in another cell the sum al all dividends paid in 2010?
>
Mon Feb 11, 2013 12:05 pm (PST) . Posted by:
"Jacob Jose" pepecan47
Randy, the formula woks perfectly, most of the times. I found a little problem.
I want dividends for (current + 10years), because I follow some stocks that pay monthly. , define the array B4:B136 (title + 132 dividends).
The formula is =SUMPRODUCT(--(YEAR($B5:$B136)=D2),$C5:$C136)
The problem is, when the function returns less than 133 rows, I get #value!. Is there a way to skip executing the formula when returns
empy or "no value"?
You can reproduce the problem using ticker ADI.
Regards,
Jose L. Jacob
________________________________
From: Jacob Jose pepecan47@yahoo.ca >
To: "smf_addin@yahoogroups.com " smf_addin@yahoogroups.com >
Sent: Monday, February 11, 2013 11:33:03 AM
Subject: [smf_addin] Getting annual dividends from yahoo history
Randy, you are amazing. Thank you very much.
Regards,Jose L. Jacob
________________________________
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Sunday, February 10, 2013 10:29:43 AM
Subject: Re: [smf_addin] Dividends from Earnings.com
You'd need to retrieve a range of data and then sum up the premiums for that year. For example:B2: 2010B4:C22: =RCHGetYahooHistory("MMM",,,,,,,"v")C2: =SUMPRODUCT(--(YEAR(B5:B22)=B2),C5:C22)
On Sun, Feb 10, 2013 at 8:09 AM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
>If I use RCHGetYahooHistory() to get the dividends history, how can I get the totals by year?
>
>If I have a cell with the value 2010 (for example), how can I get in another cell the sum al all dividends paid in 2010?
>
I want dividends for (current + 10years), because I follow some stocks that pay monthly. , define the array B4:B136 (title + 132 dividends).
The formula is =SUMPRODUCT(
The problem is, when the function returns less than 133 rows, I get #value!. Is there a way to skip executing the formula when returns
empy or "no value"?
You can reproduce the problem using ticker ADI.
Regards,
Jose L. Jacob
____________
From: Jacob Jose pepecan47@yahoo.
To: "smf_addin@yahoogrou
Sent: Monday, February 11, 2013 11:33:03 AM
Subject: [smf_addin] Getting annual dividends from yahoo history
Randy, you are amazing. Thank you very much.
Regards,Jose L. Jacob
____________
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Sunday, February 10, 2013 10:29:43 AM
Subject: Re: [smf_addin] Dividends from Earnings.com
You'd need to retrieve a range of data and then sum up the premiums for that year. For example:B2: 2010B4:C22: =RCHGetYahooHistory
On Sun, Feb 10, 2013 at 8:09 AM, Jacob Jose pepecan47@yahoo.
>
>If I use RCHGetYahooHistory(
>
>If I have a cell with the value 2010 (for example), how can I get in another cell the sum al all dividends paid in 2010?
>
Mon Feb 11, 2013 1:10 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Try:
=SUMPRODUCT(--((TEXT($B5:$B136,"yyyy"))=""&D2),$C5:$C136)
On Mon, Feb 11, 2013 at 1:05 PM, Jacob Jose pepecan47@yahoo.ca > wrote:
>
> Randy, the formula woks perfectly, most of the times. I found a little
> problem.
>
> I want dividends for (current + 10years), because I follow some stocks
> that pay monthly. , define the array B4:B136 (title + 132 dividends).
> The formula is =SUMPRODUCT(--(YEAR($B5:$B136)=D2),$C5:$C136)
>
> The problem is, when the function returns less than 133 rows, I get
> #value!. Is there a way to skip executing the formula when returns
> empy or "no value"?
>
> You can reproduce the problem using ticker ADI.
>
=SUMPRODUCT(
On Mon, Feb 11, 2013 at 1:05 PM, Jacob Jose pepecan47@yahoo.
>
> Randy, the formula woks perfectly, most of the times. I found a little
> problem.
>
> I want dividends for (current + 10years), because I follow some stocks
> that pay monthly. , define the array B4:B136 (title + 132 dividends).
> The formula is =SUMPRODUCT(
>
> The problem is, when the function returns less than 133 rows, I get
> #value!. Is there a way to skip executing the formula when returns
> empy or "no value"?
>
> You can reproduce the problem using ticker ADI.
>
Mon Feb 11, 2013 11:42 am (PST) . Posted by:
"Matthew" matthewcrawford88
I am doing some comp analysis on a company, "GLYE", and all of a sudden I'm receving "Error" for my data I am pulling for this company only, the rest of the data for the remaining companies is fine. Please help?
Mon Feb 11, 2013 11:43 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Without more detail on whatever functions you were using, I can't be of
help.
It could be the data source you are using just doesn't have the data
available for that company.
On Mon, Feb 11, 2013 at 12:05 PM, Matthew matthewcrawford88@yahoo.com >wrote:
> I am doing some comp analysis on a company, "GLYE", and all of a sudden
> I'm receving "Error" for my data I am pulling for this company only, the
> rest of the data for the remaining companies is fine. Please help?
>
help.
It could be the data source you are using just doesn't have the data
available for that company.
On Mon, Feb 11, 2013 at 12:05 PM, Matthew matthewcrawford88@
> I am doing some comp analysis on a company, "GLYE"
> I'm receving "Error" for my data I am pulling for this company only, the
> rest of the data for the remaining companies is fine. Please help?
>
Tue Feb 12, 2013 7:19 am (PST) . Posted by:
"Matthew" matthewcrawford88
I am using the RCHGetElementNumber...but today it is working. Thank you.
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Without more detail on whatever functions you were using, I can't be of
> help.
>
> It could be the data source you are using just doesn't have the data
> available for that company.
>
> On Mon, Feb 11, 2013 at 12:05 PM, Matthew wrote:
>
> > I am doing some comp analysis on a company, "GLYE", and all of a sudden
> > I'm receving "Error" for my data I am pulling for this company only, the
> > rest of the data for the remaining companies is fine. Please help?
> >
>
--- In smf_addin@yahoogrou
>
> Without more detail on whatever functions you were using, I can't be of
> help.
>
> It could be the data source you are using just doesn't have the data
> available for that company.
>
> On Mon, Feb 11, 2013 at 12:05 PM, Matthew wrote:
>
> > I am doing some comp analysis on a company, "GLYE"
> > I'm receving "Error" for my data I am pulling for this company only, the
> > rest of the data for the remaining companies is fine. Please help?
> >
>
Mon Feb 11, 2013 8:27 pm (PST) . Posted by:
"wisfan411" wisfan411
I am new to this, how do you download the smf addin for excel. I am using excel 2007.
Mon Feb 11, 2013 8:28 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
That information is on the front page of the group, as well as in the
"Welcome to the group" message you received.
On Mon, Feb 11, 2013 at 8:15 PM, wisfan411 wisfan411@yahoo.com > wrote:
> I am new to this, how do you download the smf addin for excel. I am using
> excel 2007.
>
"Welcome to the group" message you received.
On Mon, Feb 11, 2013 at 8:15 PM, wisfan411 wisfan411@yahoo.
> I am new to this, how do you download the smf addin for excel. I am using
> excel 2007.
>
Mon Feb 11, 2013 10:08 pm (PST) . Posted by:
"Tze Wei," tzewei_79
Hi,
Thanks. It works! :-)
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Just use an additional search string (you can use up to 4 of them):
>
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol=NCT ",1,"Net
> Income","Net Income")
>
> ...or you could use the "id" descriptor:
>
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol=NCT
> ",1,"id=""NetIncome""")
>
> Just a word of caution -- it's typically not a good idea to use something
> like "Net Income" as a search string, all by itself. That string could
> easily show up elsewhere in the source code of the web page, such as in
> Meta tag descriptions of the web page, or even a news item that may show up
> someplace early on the page.
>
> On Mon, Feb 11, 2013 at 1:52 AM, Tze Wei, wrote:
>
> >
> > I tried using the following formula to get the Net Income from MSN but it
> > seems to get the 1st Net Income at the site, which is "Net Income Before
> > Extra. Items"
> >
> > Is there a way to make the code skip 2 rows below Net Income Before Extra.
> > Items?
> >
> > =RCHGetTableCell("
> > http://investing.money.msn.com/investments/stock-income-statement/?symbol=NCT ",1,"Net
> > Income")
> >
>
Thanks. It works! :-)
--- In smf_addin@yahoogrou
>
> Just use an additional search string (you can use up to 4 of them):
>
> =RCHGetTableCell(
> http://investing.
> Income"
>
> ...or you could use the "id" descriptor:
>
> =RCHGetTableCell(
> http://investing.
> ",1,"
>
> Just a word of caution -- it's typically not a good idea to use something
> like "Net Income" as a search string, all by itself. That string could
> easily show up elsewhere in the source code of the web page, such as in
> Meta tag descriptions of the web page, or even a news item that may show up
> someplace early on the page.
>
> On Mon, Feb 11, 2013 at 1:52 AM, Tze Wei, wrote:
>
> >
> > I tried using the following formula to get the Net Income from MSN but it
> > seems to get the 1st Net Income at the site, which is "Net Income Before
> > Extra. Items"
> >
> > Is there a way to make the code skip 2 rows below Net Income Before Extra.
> > Items?
> >
> > =RCHGetTableCell(
> > http://investing.
> > Income"
> >
>
Tue Feb 12, 2013 4:39 am (PST) . Posted by:
"rjemery7" rjemery7
Randy,
Why is it certain RCHYetYahooHistory() calls fail? For example,
=RCHGetYahooHistory("^DJI";,2012,1,31,2012,1,31,,"c",0) and
=RCHGetYahooHistory("^DJI";,2013,1,31,2013,1,31,,"c",0)
both return nothing.
What other resources (finance.google.com?) exist for extracting the same information? What would be the command to use?
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> To get year-end 2011 closing price, unadjusted:
>
> =RCHGetYahooHistory("MMM",2011,12,30,2011,12,30,,"c",0)
>
> On Tue, Feb 5, 2013 at 11:21 AM, rjemery7 wrote:
>
> > How do I obtain UNADJUSTED closing prices for a specific ticker and date?
> >
>
Why is it certain RCHYetYahooHistory(
=RCHGetYahooHistory
=RCHGetYahooHistory
both return nothing.
What other resources (finance.google.
--- In smf_addin@yahoogrou
>
> To get year-end 2011 closing price, unadjusted:
>
> =RCHGetYahooHistory
>
> On Tue, Feb 5, 2013 at 11:21 AM, rjemery7 wrote:
>
> > How do I obtain UNADJUSTED closing prices for a specific ticker and date?
> >
>
Tue Feb 12, 2013 6:28 am (PST) . Posted by:
"Ron Spruell" hashky
Randy -
I can't get the new Addin version to work.
I get a compile error.
"Can't find project or library."
I am running Windows XP with Excel 2010.
Stock Market
Functions add-in, Version 2.1.2013.01.04 (C:\Program Files\SMF Add-In; 1)
Ron Spruell
>________________________________
> From: Randy Harmelink rharmelink@gmail.com >
>To: smf_addin@yahoogroups.com
>Sent: Wednesday, February 6, 2013 10:27 PM
>Subject: Re: [smf_addin] VIX options quote not working
>
>
>
>My reply evidently went directly to Mike instead of to the Yahoo group.
>
>If anyone else tries 2.1.2012.02.06 -- let me know if you get the same compiler error, or whether it works. I've seen several other messages that it worked correctly, and can't see anything wrong on this end, so I'm wondering if it's an isolated case.
>
>Note that you do have to exit EXCEL before updating the XLA file, since add-ins are loaded when EXCEL starts up.
>
>
>________________________________
>
>Hmmm. Not sure what to tell you. I went into the add-in and the VBA
environment compiles it successfully. And the UCase() function is not
something new -- I have been using that in numerous places for some
time. And my template that uses that particular function is working
fine...
>
>One thing I saw from a Google search on the topic had this advice:
>
>"In the VBE, go to Tools > References. In the dialog, you will
probably see a reference marked as "MISSING". Resolve that missing
reference - just uncheck it if it's not needed - and you should then
find all is well (with the UCase, although not necessarily
with other things - it depends what it was that was missing)."
>
>I haven't changed the references, at least not intentionally.
>
>On Wed, Feb 6, 2013 at 4:38 PM, Michael mike@grames.net > wrote:
>Randy,
>
>I have tried your new beta version, because I was also having
problems with VIX. However, the new version does not run, and
produces an error for me, such as "library missing" and brings up
the debugger. I have switched back to the previous beta version,
which seems to run fine.
>
>
>
>Mike
>
>
>
I can't get the new Addin version to work.
I get a compile error.
"Can'
I am running Windows XP with Excel 2010.
Stock Market
Functions add-in, Version 2.1.2013.01.
Ron Spruell
>________
> From: Randy Harmelink rharmelink@gmail.
>To: smf_addin@yahoogrou
>Sent: Wednesday, February 6, 2013 10:27 PM
>Subject: Re: [smf_addin] VIX options quote not working
>
>
>
>My reply evidently went directly to Mike instead of to the Yahoo group.
>
>If anyone else tries 2.1.2012.02.
>
>Note that you do have to exit EXCEL before updating the XLA file, since add-ins are loaded when EXCEL starts up.
>
>
>________
>
>Hmmm. Not sure what to tell you. I went into the add-in and the VBA
environment compiles it successfully. And the UCase() function is not
something new -- I have been using that in numerous places for some
time. And my template that uses that particular function is working
fine...
>
>One thing I saw from a Google search on the topic had this advice:
>
>"In the VBE, go to Tools > References. In the dialog, you will
probably see a reference marked as "MISSING"
reference - just uncheck it if it's not needed - and you should then
find all is well (with the UCase, although not necessarily
with other things - it depends what it was that was missing)."
>
>I haven't changed the references, at least not intentionally.
>
>On Wed, Feb 6, 2013 at 4:38 PM, Michael mike@grames.
>Randy,
>
>I have tried your new beta version, because I was also having
problems with VIX. However, the new version does not run, and
produces an error for me, such as "library missing" and brings up
the debugger. I have switched back to the previous beta version,
which seems to run fine.
>
>
>
>Mike
>
>
>
Tue Feb 12, 2013 6:48 am (PST) . Posted by:
"Ron Spruell" hashky
Randy -
Sorry I am so far behind on reading the posts. This post fixed my problem.
[smf_addin] Re: Get Error using rchgetelementnumber
Hide Details
From
* webz1984
To
* smf_addin@yahoogroups.com
One way to work around the error message is to open Excel from office, go to options ->add-in
to go through the add-in process, then the error msg will pop out. Just
click OK,and it will redirect to the following reference page.
http://imgur.com/ZsGZGUW
Uncheck the box of MISSING:HTML.XLAM, then open the worksheet from this excel window. It seems works fine afterwards.
Regards,
Wz
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Not good. Someone else reported that issue with the latest release...
>
> But I haven't changed any reference libraries.
>
> On Thu, Feb 7, 2013 at 2:54 PM, webz1984 wrote:
>
> >
> > Also, sometimes when I open the spreadsheet, it gave me an error of "Can't
> > find project or Library"
> >
>
>________________________________
> From: Ron Spruell hashky@yahoo.com >
>To: "smf_addin@yahoogroups.com " smf_addin@yahoogroups.com >
>Sent: Tuesday, February 12, 2013 8:28 AM
>Subject: Re: [smf_addin] VIX options quote not working-Addin 2.1.2013.02.06
>
>
>Randy -
>
>
>I can't get the new Addin version to work.
>
>
>
>I get a compile error.
>
>"Can't find project or library."
>
>
>I am running Windows XP with Excel 2010.
>
>Stock Market Functions add-in, Version 2.1.2013.01.04 (C:\Program Files\SMF Add-In; 1)
>
>
>Ron Spruell
>
>
>
>
>>________________________________
>> From: Randy Harmelink rharmelink@gmail.com >
>>To: smf_addin@yahoogroups.com
>>Sent: Wednesday, February 6, 2013 10:27 PM
>>Subject: Re: [smf_addin] VIX options quote not working
>>
>>
>>
>>My reply evidently went directly to Mike instead of to the Yahoo group.
>>
>>If anyone else tries 2.1.2012.02.06 -- let me know if you get the same compiler error, or whether it works. I've seen several other messages that it worked correctly, and can't see anything wrong on this end, so I'm wondering if it's an isolated case.
>>
>>Note that you do have to exit EXCEL before updating the XLA file, since add-ins are loaded when EXCEL starts up.
>>
>>
>>________________________________
>>
>>Hmmm. Not sure what to tell you. I went into the add-in and the VBA
environment compiles it successfully. And the UCase() function is not
something new -- I have been using that in numerous places for some
time. And my template that uses that particular function is working
fine...
>>
>>One thing I saw from a Google search on the topic had this advice:
>>
>>"In the VBE, go to Tools > References. In the dialog, you will
probably see a reference marked as "MISSING". Resolve that missing
reference - just uncheck it if it's not needed - and you should then
find all is well (with the UCase, although not necessarily
with other things - it depends what it was that was missing)."
>>
>>I haven't changed the references, at least not intentionally.
>>
>>On Wed, Feb 6, 2013 at 4:38 PM, Michael mike@grames.net > wrote:
>>Randy,
>>
>>I have tried your new beta version, because I was also having
problems with VIX. However, the new version does not run, and
produces an error for me, such as "library missing" and brings up
the debugger. I have switched back to the previous beta version,
which seems to run fine.
>>
>>
>>
>>Mike
>>
>>
>
>
Sorry I am so far behind on reading the posts. This post fixed my problem.
[smf_addin] Re: Get Error using rchgetelementnumber
Hide Details
From
* webz1984
To
* smf_addin@yahoogrou
One way to work around the error message is to open Excel from office, go to options ->add-in
to go through the add-in process, then the error msg will pop out. Just
click OK,and it will redirect to the following reference page.
http://imgur.
Uncheck the box of MISSING:HTML.
Regards,
Wz
--- In smf_addin@yahoogrou
>
> Not good. Someone else reported that issue with the latest release...
>
> But I haven't changed any reference libraries.
>
> On Thu, Feb 7, 2013 at 2:54 PM, webz1984 wrote:
>
> >
> > Also, sometimes when I open the spreadsheet, it gave me an error of "Can'
> > find project or Library"
> >
>
>________
> From: Ron Spruell hashky@yahoo.
>To: "smf_addin@yahoogrou
>Sent: Tuesday, February 12, 2013 8:28 AM
>Subject: Re: [smf_addin] VIX options quote not working-Addin 2.1.2013.02.
>
>
>Randy -
>
>
>I can't get the new Addin version to work.
>
>
>
>I get a compile error.
>
>"Can&#
>
>
>I am running Windows XP with Excel 2010.
>
>Stock Market Functions add-in, Version 2.1.2013.01.
>
>
>Ron Spruell
>
>
>
>
>>____
>> From: Randy Harmelink rharmelink@gmail.
>>To: smf_addin@yahoogrou
>>Sent: Wednesday, February 6, 2013 10:27 PM
>>Subject: Re: [smf_addin] VIX options quote not working
>>
>>
>>
>>My reply evidently went directly to Mike instead of to the Yahoo group.
>>
>>If anyone else tries 2.1.2012.02.
>>
>>Note that you do have to exit EXCEL before updating the XLA file, since add-ins are loaded when EXCEL starts up.
>>
>>
>>____
>>
>>Hmmm. Not sure what to tell you. I went into the add-in and the VBA
environment compiles it successfully. And the UCase() function is not
something new -- I have been using that in numerous places for some
time. And my template that uses that particular function is working
fine...
>>
>>One thing I saw from a Google search on the topic had this advice:
>>
>>"
probably see a reference marked as "MISSING"
reference - just uncheck it if it's not needed - and you should then
find all is well (with the UCase, although not necessarily
with other things - it depends what it was that was missing)."
>>
>>I haven't changed the references, at least not intentionally.
>>
>>On Wed, Feb 6, 2013 at 4:38 PM, Michael mike@grames.
>>Randy,
>>
>>I have tried your new beta version, because I was also having
problems with VIX. However, the new version does not run, and
produces an error for me, such as "library missing" and brings up
the debugger. I have switched back to the previous beta version,
which seems to run fine.
>>
>>
>>
>>Mike
>>
>>
>
>
Tue Feb 12, 2013 7:10 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
Try the latest version in the Work-in-progress folder in the files section. It works for me
Stock Market Functions add-in, Version 2.1.2013.02.06 (C:\Program Files\SMF Add-in; 1)
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Ron Spruell
Sent: Tuesday, February 12, 2013 9:29 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] VIX options quote not working-Addin 2.1.2013.02.06
Randy -
I can't get the new Addin version to work.
I get a compile error.
"Can't find project or library."
I am running Windows XP with Excel 2010.
Stock Market Functions add-in, Version 2.1.2013.01.04 (C:\Program Files\SMF Add-In; 1)
Ron Spruell
_____
From: Randy Harmelink rharmelink@gmail.com >
To: smf_addin@yahoogroups.com
Sent: Wednesday, February 6, 2013 10:27 PM
Subject: Re: [smf_addin] VIX options quote not working
My reply evidently went directly to Mike instead of to the Yahoo group.
If anyone else tries 2.1.2012.02.06 -- let me know if you get the same compiler error, or whether it works. I've seen several other messages that it worked correctly, and can't see anything wrong on this end, so I'm wondering if it's an isolated case.
Note that you do have to exit EXCEL before updating the XLA file, since add-ins are loaded when EXCEL starts up.
_____
Hmmm. Not sure what to tell you. I went into the add-in and the VBA environment compiles it successfully. And the UCase() function is not something new -- I have been using that in numerous places for some time. And my template that uses that particular function is working fine...
One thing I saw from a Google search on the topic had this advice:
"In the VBE, go to Tools > References. In the dialog, you will probably see a reference marked as "MISSING". Resolve that missing reference - just uncheck it if it's not needed - and you should then find all is well (with the UCase, although not necessarily with other things - it depends what it was that was missing)."
I haven't changed the references, at least not intentionally.
https://mail.google.com/mail/u/0/images/cleardot.gif >
On Wed, Feb 6, 2013 at 4:38 PM, Michael mike@grames.net > wrote:
Randy,
I have tried your new beta version, because I was also having problems with VIX. However, the new version does not run, and produces an error for me, such as "library missing" and brings up the debugger. I have switched back to the previous beta version, which seems to run fine.
Mike
Stock Market Functions add-in, Version 2.1.2013.02.
From: smf_addin@yahoogrou
Sent: Tuesday, February 12, 2013 9:29 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] VIX options quote not working-Addin 2.1.2013.02.
Randy -
I can't get the new Addin version to work.
I get a compile error.
"Can'
I am running Windows XP with Excel 2010.
Stock Market Functions add-in, Version 2.1.2013.01.
Ron Spruell
_____
From: Randy Harmelink rharmelink@gmail.
To: smf_addin@yahoogrou
Sent: Wednesday, February 6, 2013 10:27 PM
Subject: Re: [smf_addin] VIX options quote not working
My reply evidently went directly to Mike instead of to the Yahoo group.
If anyone else tries 2.1.2012.02.
Note that you do have to exit EXCEL before updating the XLA file, since add-ins are loaded when EXCEL starts up.
_____
Hmmm. Not sure what to tell you. I went into the add-in and the VBA environment compiles it successfully. And the UCase() function is not something new -- I have been using that in numerous places for some time. And my template that uses that particular function is working fine...
One thing I saw from a Google search on the topic had this advice:
"In the VBE, go to Tools > References. In the dialog, you will probably see a reference marked as "MISSING"
I haven't changed the references, at least not intentionally.
https://mail.
On Wed, Feb 6, 2013 at 4:38 PM, Michael mike@grames.
Randy,
I have tried your new beta version, because I was also having problems with VIX. However, the new version does not run, and produces an error for me, such as "library missing" and brings up the debugger. I have switched back to the previous beta version, which seems to run fine.
Mike
Tidak ada komentar:
Posting Komentar