15 New Messages
Digest #2535
Messages
Thu Mar 7, 2013 5:43 am (PST) . Posted by:
"njouellette83" njouellette83
You had mentioned that if I went down the other way it would open up 12 internets, perhaps this is not a problem would you know the formula for that I was seeing things like. Just not entirely sure how to make them function between 2190 days to 1826 days ago for example.
=AVERAGE(RCHGetYaho oHistory("MED",,,,,,,,"A",0,1,,50,1))
=MAX(RCHGetYahooHis tory("MED";,,,,,,,,"H",0,1,,50,1))
=MIN(RCHGetYahooHis tory("MED";,,,,,,,,"L",0,1,,50,1))
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> I would just array-enter this over a large enough range to contain the data
> you need:
>
> =RCHGetYahooHistory(C6,,,,,,,,,,1)
>
> On Wed, Mar 6, 2013 at 7:11 PM, njouellette83 <nouellette83@...>wrote:
>
> > Do you know a formula to pull the entire array for 6 years of high low
> > pricing?
> >
>
=AVERAGE(RCHGetYaho oHistory("
=MAX(RCHGetYahooHis tory("MED"
=MIN(RCHGetYahooHis tory("MED"
--- In smf_addin@yahoogrou
>
> I would just array-enter this over a large enough range to contain the data
> you need:
>
> =RCHGetYahooHistory
>
> On Wed, Mar 6, 2013 at 7:11 PM, njouellette83 <nouellette83@
>
> > Do you know a formula to pull the entire array for 6 years of high low
> > pricing?
> >
>
Thu Mar 7, 2013 8:46 am (PST) . Posted by:
"Randy Harmelink" rharmelink
Something like this should work:
=MAX(RCHGetYahooHistory("MED",2011,1,1,2011,12,31,,"h",0,1,,260,1))
...but I'm not happy with the 12 Internet accesses that would require. It
puts an unnecessary burden on a free data resource.
On Thu, Mar 7, 2013 at 6:43 AM, njouellette83 <nouellette83@gmail.com >wrote:
> You had mentioned that if I went down the other way it would open up 12
> internets, perhaps this is not a problem would you know the formula for
> that I was seeing things like. Just not entirely sure how to make them
> function between 2190 days to 1826 days ago for example.
>
> =AVERAGE(RCHGetYaho oHistory("MED",,,,,,,,"A",0,1,,50,1))
> =MAX(RCHGetYahooHis tory("MED";,,,,,,,,"H",0,1,,50,1))
> =MIN(RCHGetYahooHis tory("MED";,,,,,,,,"L",0,1,,50,1))
>
=MAX(RCHGetYahooHis
...but I'm not happy with the 12 Internet accesses that would require. It
puts an unnecessary burden on a free data resource.
On Thu, Mar 7, 2013 at 6:43 AM, njouellette83 <nouellette83@
> You had mentioned that if I went down the other way it would open up 12
> internets, perhaps this is not a problem would you know the formula for
> that I was seeing things like. Just not entirely sure how to make them
> function between 2190 days to 1826 days ago for example.
>
> =AVERAGE(RCHGetYaho oHistory("
> =MAX(RCHGetYahooHis tory("MED"
> =MIN(RCHGetYahooHis tory("MED"
>
Thu Mar 7, 2013 8:50 am (PST) . Posted by:
"njouellette83" njouellette83
Yeah that definetly is too much to pull I ended up restructing my valuation model to use my original formula rather than a high low system. I appreciate the help.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Something like this should work:
>
> =MAX(RCHGetYahooHistory("MED",2011,1,1,2011,12,31,,"h",0,1,,260,1))
>
> ...but I'm not happy with the 12 Internet accesses that would require. It
> puts an unnecessary burden on a free data resource.
>
> On Thu, Mar 7, 2013 at 6:43 AM, njouellette83 <nouellette83@...>wrote:
>
> > You had mentioned that if I went down the other way it would open up 12
> > internets, perhaps this is not a problem would you know the formula for
> > that I was seeing things like. Just not entirely sure how to make them
> > function between 2190 days to 1826 days ago for example.
> >
> > =AVERAGE(RCHGetYaho oHistory("MED",,,,,,,,"A",0,1,,50,1))
> > =MAX(RCHGetYahooHis tory("MED";,,,,,,,,"H",0,1,,50,1))
> > =MIN(RCHGetYahooHis tory("MED";,,,,,,,,"L",0,1,,50,1))
> >
>
--- In smf_addin@yahoogrou
>
> Something like this should work:
>
> =MAX(RCHGetYahooHis
>
> ...but I'm not happy with the 12 Internet accesses that would require. It
> puts an unnecessary burden on a free data resource.
>
> On Thu, Mar 7, 2013 at 6:43 AM, njouellette83 <nouellette83@
>
> > You had mentioned that if I went down the other way it would open up 12
> > internets, perhaps this is not a problem would you know the formula for
> > that I was seeing things like. Just not entirely sure how to make them
> > function between 2190 days to 1826 days ago for example.
> >
> > =AVERAGE(RCHGetYaho oHistory("
> > =MAX(RCHGetYahooHis tory("MED"
> > =MIN(RCHGetYahooHis tory("MED"
> >
>
Thu Mar 7, 2013 7:19 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
I'm at a total loss on what to try next to resolve the issues I reported before.
I opened the failing workbook on my laptop and after resetting all the links it works without failures. So I know the workbook is okay.
Apparently, I am missing something when doing the removal and re-install of the addin.
Is there detailed instruction on how to TOTALLY remove the addin?
Apparently, I am missing something.
I have the detailed instructions on the install that Derek Barrett wrote. http://seekingalpha.com/author/derek-a-barrett/instablog
This driving me NUTS!!! HELP!!!!
On the failing system, I have removed the addin from excel, deleted all copies of SMF-addin from my Vista 64 bit machine, rebooted my system, downloaded the latest smf addin version - Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files\SMF Add-in; 1)
, re-installed the addin and I still get both failures.
Reported problems: NOTE: my working system returns exactly the same sfmgetaparms.
1- no MSN elements work - every element returns an error such as element 24
the smfGetAParms(24) returns MSN;Volatility (Beta);http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;VOLATILITY (BETA); ; ;0;0;0;0
2. elements 811,812,and 813 was returning error on symbol SIRI now after the re-install it is reporting error on all symbols for 811-813
Smf parms for 811 – 813 are
StockScores;Price Indicator -- 100 Day Trend;=PROPER(RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~ ",1,"Moving Average/Vol","100 Day Trend"))
StockScores;Price Indicator -- 15 Day Trend;=PROPER(RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~ ",1,"Moving Average/Vol","15 Day Trend"))
StockScores;Price Indicator -- 45 Day Trend;=PROPER(RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~ ",1,"Moving Average/Vol","45 Day Trend"))
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Wednesday, March 06, 2013 11:23 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Getting errors on SIRI from stockscores template
Those thee elements work fine for me with SIRI. I suspect you got a bad copy of the web page -- timed out, being updated, corrupted, whatever.
If you're still getting the Error, you can try the smfGetTagContent-Quick-Webpage-Examination.xls template with this URL:
http://www.stockscores.com/quickreport.asp?ticker=SIRI
That should allow you to examine the saved copy you have of the web page to see what might be an issue.
On Wed, Mar 6, 2013 at 8:35 AM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
In using the Stockscores spreadsheet I am getting an error on SIRI but looking at the web page I see no difference between SIRI and WMC both shown below.
Can you shed any light on why I am getting the error in the 3 cells?
WMC
6
6
0
Bearish
Bullish
Bearish
Bearish
Bearish
Bearish
Bullish
Bullish
Bullish
Bearish
Bullish
Bullish
Dec 27, 2012
Jan 28, 2013
1.45
6.7%
Element number
812
813
811
SIRI
2
7
0
Bullish
Bullish
Bearish
Bearish
Bullish
Bullish
Bullish
Bullish
Bullish
Error
Error
Error
Dec 14, 2012
Dec 27, 2012
0.05
1.6%
This is the content of the cells shown in yellow
RCHGetElementNumber(A108, 812)
RCHGetElementNumber(A108, 813)
RCHGetElementNumber(A108, 811)
812
813
811
RCHGetElementNumber(A110, 812)
RCHGetElementNumber(A110, 813)
RCHGetElementNumber(A110, 811)
Below is the content of the webpage for the area that is being retrieved in the first error cell
_____
SIRI
<tr>
<td class=table-content1>10 Day Trend </td>
<td class=table-content1><img src="images/bullish_small.gif" border=0 alt="Bullish"> bullish</td>
</tr>
_____
WMC
<tr>
<td class=table-content1>10 Day Trend </td>
<td class=table-content1><img src="images/bullish_small.gif" border=0 alt="Bullish"> bullish</td>
</tr>
_____
I opened the failing workbook on my laptop and after resetting all the links it works without failures. So I know the workbook is okay.
Apparently, I am missing something when doing the removal and re-install of the addin.
Is there detailed instruction on how to TOTALLY remove the addin?
Apparently, I am missing something.
I have the detailed instructions on the install that Derek Barrett wrote. http://seekingalpha
This driving me NUTS!!! HELP!!!!
On the failing system, I have removed the addin from excel, deleted all copies of SMF-addin from my Vista 64 bit machine, rebooted my system, downloaded the latest smf addin version - Stock Market Functions add-in, Version 2.1.2012.12.
, re-installed the addin and I still get both failures.
Reported problems: NOTE: my working system returns exactly the same sfmgetaparms.
1- no MSN elements work - every element returns an error such as element 24
the smfGetAParms(
2. elements 811,812,and 813 was returning error on symbol SIRI now after the re-install it is reporting error on all symbols for 811-813
Smf parms for 811 – 813 are
StockScores;
StockScores;
StockScores;
From: smf_addin@yahoogrou
Sent: Wednesday, March 06, 2013 11:23 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Getting errors on SIRI from stockscores template
Those thee elements work fine for me with SIRI. I suspect you got a bad copy of the web page -- timed out, being updated, corrupted, whatever.
If you're still getting the Error, you can try the smfGetTagContent-
http://www.stocksco
That should allow you to examine the saved copy you have of the web page to see what might be an issue.
On Wed, Mar 6, 2013 at 8:35 AM, Kermit W. Prather <kermitp@tampabay.
In using the Stockscores spreadsheet I am getting an error on SIRI but looking at the web page I see no difference between SIRI and WMC both shown below.
Can you shed any light on why I am getting the error in the 3 cells?
WMC
6
6
0
Bearish
Bullish
Bearish
Bearish
Bearish
Bearish
Bullish
Bullish
Bullish
Bearish
Bullish
Bullish
Dec 27, 2012
Jan 28, 2013
1.45
6.7%
Element number
812
813
811
SIRI
2
7
0
Bullish
Bullish
Bearish
Bearish
Bullish
Bullish
Bullish
Bullish
Bullish
Error
Error
Error
Dec 14, 2012
Dec 27, 2012
0.05
1.6%
This is the content of the cells shown in yellow
RCHGetElementNumber
RCHGetElementNumber
RCHGetElementNumber
812
813
811
RCHGetElementNumber
RCHGetElementNumber
RCHGetElementNumber
Below is the content of the webpage for the area that is being retrieved in the first error cell
_____
SIRI
<tr>
<td class=table-
<td class=table-
</tr>
_____
WMC
<tr>
<td class=table-
<td class=table-
</tr>
_____
Thu Mar 7, 2013 8:57 am (PST) . Posted by:
"Randy Harmelink" rharmelink
To completely remove the add-in -- uncheck it within the add-in manager,
then exit EXCEL, and then delete the add-in contents and folder.
The element definition for element #24 is correct. In essence, it should be
doing:
=RCHGetTableCell("
http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=SIRI ",1,"STOCK
ACTIVITY","VOLATILITY (BETA)")
Your element #811 should be doing:
=PROPER(RCHGetTableCell("
http://www.stockscores.com/quickreport.asp?ticker=SIRI ",1,"Moving
Average/Vol","100 Day Trend"))
Do you see the web page you expect when you use that last URL as the web
address in an EXCEL Web Query? Several times in the past, I've seen
redirections to another web page for one reason or another. For example, an
advertisement or a "too many accesses to web site" type of warning.
On Thu, Mar 7, 2013 at 8:19 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> I'm at a total loss on what to try next to resolve the issues I reported
> before.****
>
> ** **
>
> I opened the failing workbook on my laptop and after resetting all the
> links it works without failures. So I know the workbook is okay. ****
>
> ** **
>
> Apparently, I am missing something when doing the removal and re-install
> of the addin. ****
>
> ** **
>
> *Is there detailed instruction on how to TOTALLY remove the addin? *
>
> *Apparently, I am missing something. *****
>
> I have the detailed instructions on the install that Derek Barrett wrote.
> http://seekingalpha.com/author/derek-a-barrett/instablog****
>
> ** **
>
> This driving me NUTS!!! HELP!!!!****
>
> ** **
>
> On the failing system, I have removed the addin from excel, deleted all
> copies of SMF-addin from my Vista 64 bit machine, rebooted my system,
> downloaded the latest smf addin version - Stock Market Functions add-in,
> Version 2.1.2012.12.29 (C:\Program Files\SMF Add-in; 1)****
>
> , re-installed the addin and I still get both failures.****
>
> ** **
>
> Reported problems: NOTE: *my working system returns exactly the same
> sfmgetaparms*. ****
>
> ** **
>
> **1- **no MSN elements work - every element returns an error such
> as element 24****
>
> the smfGetAParms(24) returns MSN;Volatility (Beta);
> http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCKACTIVITY;VOLATILITY (BETA); ; ;0;0;0;0
> ****
>
> ** **
>
> 2. elements 811,812,and 813 was returning error on symbol SIRI now after
> the re-install it is reporting error on all symbols for 811-813****
>
> ** **
>
> Smf parms for 811 – 813 are ****
>
> ****
>
> StockScores;Price Indicator -- 100 Day Trend;=PROPER(RCHGetTableCell("
> http://www.stockscores.com/quickreport.asp?ticker=~~~~~ ",1,"Moving
> Average/Vol","100 Day Trend"))****
>
> StockScores;Price Indicator -- 15 Day Trend;=PROPER(RCHGetTableCell("
> http://www.stockscores.com/quickreport.asp?ticker=~~~~~ ",1,"Moving
> Average/Vol","15 Day Trend"))****
>
> StockScores;Price Indicator -- 45 Day Trend;=PROPER(RCHGetTableCell("
> http://www.stockscores.com/quickreport.asp?ticker=~~~~~ ",1,"Moving
> Average/Vol","45 Day Trend"))
>
then exit EXCEL, and then delete the add-in contents and folder.
The element definition for element #24 is correct. In essence, it should be
doing:
=RCHGetTableCell(
http://investing.
ACTIVITY"
Your element #811 should be doing:
=PROPER(RCHGetTable
http://www.stocksco
Average/Vol"
Do you see the web page you expect when you use that last URL as the web
address in an EXCEL Web Query? Several times in the past, I've seen
redirections to another web page for one reason or another. For example, an
advertisement or a "too many accesses to web site" type of warning.
On Thu, Mar 7, 2013 at 8:19 AM, Kermit W. Prather
<kermitp@tampabay.
>
> I'm at a total loss on what to try next to resolve the issues I reported
> before.****
>
> ** **
>
> I opened the failing workbook on my laptop and after resetting all the
> links it works without failures. So I know the workbook is okay. ****
>
> ** **
>
> Apparently, I am missing something when doing the removal and re-install
> of the addin. ****
>
> ** **
>
> *Is there detailed instruction on how to TOTALLY remove the addin? *
>
> *Apparently, I am missing something. *****
>
> I have the detailed instructions on the install that Derek Barrett wrote.
> http://seekingalpha
>
> ** **
>
> This driving me NUTS!!! HELP!!!!****
>
> ** **
>
> On the failing system, I have removed the addin from excel, deleted all
> copies of SMF-addin from my Vista 64 bit machine, rebooted my system,
> downloaded the latest smf addin version - Stock Market Functions add-in,
> Version 2.1.2012.12.
>
> , re-installed the addin and I still get both failures.***
>
> ** **
>
> Reported problems: NOTE: *my working system returns exactly the same
> sfmgetaparms*
>
> ** **
>
> **1- **no MSN elements work - every element returns an error such
> as element 24****
>
> the smfGetAParms(
> http://investing.
> ****
>
> ** **
>
> 2. elements 811,812,and 813 was returning error on symbol SIRI now after
> the re-install it is reporting error on all symbols for 811-813****
>
> ** **
>
> Smf parms for 811 – 813 are ****
>
> ****
>
> StockScores;
> http://www.stocksco
> Average/Vol"
>
> StockScores;
> http://www.stocksco
> Average/Vol"
>
> StockScores;
> http://www.stocksco
> Average/Vol"
>
Thu Mar 7, 2013 9:25 am (PST) . Posted by:
"Kermit W. Prather" kermitpra
I did the addin removal just as you wrote and reinstalled and it stills fails. I even uninstall power off the system and restarted everything and it still fails.
Somewhere there is something being left in excel or in a global but damn if I can figure it out.
Got any other suggestions?
I agree with everything you wrote. However, my vista 64bit is not working as it should with the addin.
Using this I still get error return in the cell.
=PROPER(RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI ",1,"Moving Average/Vol","100 Day Trend"))
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, March 07, 2013 11:57 AM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] I NEED HELP - this isdriving me nuts
To completely remove the add-in -- uncheck it within the add-in manager, then exit EXCEL, and then delete the add-in contents and folder.
The element definition for element #24 is correct. In essence, it should be doing:
=RCHGetTableCell("http://investing.money.msn.com/investments/stock-report?CR=1 <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=SIRI > &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=SIRI";,1,"STOCK ACTIVITY","VOLATILITY (BETA)")
Your element #811 should be doing:
=PROPER(RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI ",1,"Moving Average/Vol","100 Day Trend"))
Do you see the web page you expect when you use that last URL as the web address in an EXCEL Web Query? Several times in the past, I've seen redirections to another web page for one reason or another. For example, an advertisement or a "too many accesses to web site" type of warning.
On Thu, Mar 7, 2013 at 8:19 AM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
I'm at a total loss on what to try next to resolve the issues I reported before.
I opened the failing workbook on my laptop and after resetting all the links it works without failures. So I know the workbook is okay.
Apparently, I am missing something when doing the removal and re-install of the addin.
Is there detailed instruction on how to TOTALLY remove the addin?
Apparently, I am missing something.
I have the detailed instructions on the install that Derek Barrett wrote. http://seekingalpha.com/author/derek-a-barrett/instablog
This driving me NUTS!!! HELP!!!!
On the failing system, I have removed the addin from excel, deleted all copies of SMF-addin from my Vista 64 bit machine, rebooted my system, downloaded the latest smf addin version - Stock Market Functions add-in, Version 2.1.2012.12.29 (C:\Program Files\SMF Add-in; 1)
, re-installed the addin and I still get both failures.
Reported problems: NOTE: my working system returns exactly the same sfmgetaparms.
1- no MSN elements work - every element returns an error such as element 24
the smfGetAParms(24) returns MSN;Volatility (Beta);http://investing.money.msn.com/investments/stock-report?CR=1 <http://investing.money.msn.com/investments/stock-report?CR=1&AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK > &AF=1&IH=1&AIE=1&AIR=1&FRH=1&FRK=1&ISA=1&ISQ=1&BSA=1&BSQ=1&CFA=1&CFQ=1&TYS=1&ITT=1&ITP=1&Type=Equity&Symbol=~~~~~;1;STOCK ACTIVITY;VOLATILITY (BETA); ; ;0;0;0;0
2. elements 811,812,and 813 was returning error on symbol SIRI now after the re-install it is reporting error on all symbols for 811-813
Smf parms for 811 – 813 are
StockScores;Price Indicator -- 100 Day Trend;=PROPER(RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~ ",1,"Moving Average/Vol","100 Day Trend"))
StockScores;Price Indicator -- 15 Day Trend;=PROPER(RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~ ",1,"Moving Average/Vol","15 Day Trend"))
StockScores;Price Indicator -- 45 Day Trend;=PROPER(RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=~~~~~ ",1,"Moving Average/Vol","45 Day Trend"))
Somewhere there is something being left in excel or in a global but damn if I can figure it out.
Got any other suggestions?
I agree with everything you wrote. However, my vista 64bit is not working as it should with the addin.
Using this I still get error return in the cell.
=PROPER(RCHGetTable
From: smf_addin@yahoogrou
Sent: Thursday, March 07, 2013 11:57 AM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] I NEED HELP - this isdriving me nuts
To completely remove the add-in -- uncheck it within the add-in manager, then exit EXCEL, and then delete the add-in contents and folder.
The element definition for element #24 is correct. In essence, it should be doing:
=RCHGetTableCell(
Your element #811 should be doing:
=PROPER(RCHGetTable
Do you see the web page you expect when you use that last URL as the web address in an EXCEL Web Query? Several times in the past, I've seen redirections to another web page for one reason or another. For example, an advertisement or a "too many accesses to web site" type of warning.
On Thu, Mar 7, 2013 at 8:19 AM, Kermit W. Prather <kermitp@tampabay.
I'm at a total loss on what to try next to resolve the issues I reported before.
I opened the failing workbook on my laptop and after resetting all the links it works without failures. So I know the workbook is okay.
Apparently, I am missing something when doing the removal and re-install of the addin.
Is there detailed instruction on how to TOTALLY remove the addin?
Apparently, I am missing something.
I have the detailed instructions on the install that Derek Barrett wrote. http://seekingalpha
This driving me NUTS!!! HELP!!!!
On the failing system, I have removed the addin from excel, deleted all copies of SMF-addin from my Vista 64 bit machine, rebooted my system, downloaded the latest smf addin version - Stock Market Functions add-in, Version 2.1.2012.12.
, re-installed the addin and I still get both failures.
Reported problems: NOTE: my working system returns exactly the same sfmgetaparms.
1- no MSN elements work - every element returns an error such as element 24
the smfGetAParms(
2. elements 811,812,and 813 was returning error on symbol SIRI now after the re-install it is reporting error on all symbols for 811-813
Smf parms for 811 – 813 are
StockScores;
StockScores;
StockScores;
Thu Mar 7, 2013 9:35 am (PST) . Posted by:
"Randy Harmelink" rharmelink
What happens if you do an EXCEL Web Query on this URL and import the data:
http://www.stockscores.com/quickreport.asp?ticker=SIRI
Do you see the data you want? Do you see the web page you want?
On Thu, Mar 7, 2013 at 10:18 AM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
> I did the addin removal just as you wrote and reinstalled and it stills
> fails. I even uninstall power off the system and restarted everything and
> it still fails. ****
>
> ** **
>
> Somewhere there is something being left in excel or in a global but damn
> if I can figure it out.****
>
> ****
>
> Got any other suggestions?****
>
> ** **
>
> I agree with everything you wrote. However, my vista 64bit is not working
> as it should with the addin. ****
>
> ** **
>
> Using this I still get error return in the cell. ****
>
> ** **
>
> =PROPER(RCHGetTableCell("
> http://www.stockscores.com/quickreport.asp?ticker=SIRI ",1,"Moving
> Average/Vol","100 Day Trend"))
>
http://www.stocksco
Do you see the data you want? Do you see the web page you want?
On Thu, Mar 7, 2013 at 10:18 AM, Kermit W. Prather
<kermitp@tampabay.
>
> I did the addin removal just as you wrote and reinstalled and it stills
> fails. I even uninstall power off the system and restarted everything and
> it still fails. ****
>
> ** **
>
> Somewhere there is something being left in excel or in a global but damn
> if I can figure it out.****
>
> ****
>
> Got any other suggestions?
>
> ** **
>
> I agree with everything you wrote. However, my vista 64bit is not working
> as it should with the addin. ****
>
> ** **
>
> Using this I still get error return in the cell. ****
>
> ** **
>
> =PROPER(RCHGetTable
> http://www.stocksco
> Average/Vol"
>
Thu Mar 7, 2013 12:30 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
Very interesting.
Using the query you asked about I get an error screen. Not sure the picture will show up in the yahoo group.
It says " An error has occurred in the script on this page.
Line 1 char 1 error invalid argument. URL is http://www.stockscores.com/quickreport.asp?ticker=SIRI
I get this same error for any symbols when I substitute for SIRI on my Vista system
I do not get this error on my laptop. When I repeat the exact sequence.
I tried at least 10 other URL's for other websites on both systems and I don't get any errors.
Any idea what is causing this error and if that is part of the problem.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, March 07, 2013 12:35 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] I NEED HELP - this isdriving me nuts
What happens if you do an EXCEL Web Query on this URL and import the data:
http://www.stockscores.com/quickreport.asp?ticker=SIRI
Do you see the data you want? Do you see the web page you want?
On Thu, Mar 7, 2013 at 10:18 AM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
I did the addin removal just as you wrote and reinstalled and it stills fails. I even uninstall power off the system and restarted everything and it still fails.
Somewhere there is something being left in excel or in a global but damn if I can figure it out.
Got any other suggestions?
I agree with everything you wrote. However, my vista 64bit is not working as it should with the addin.
Using this I still get error return in the cell.
=PROPER(RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker=SIRI ",1,"Moving Average/Vol","100 Day Trend"))
Using the query you asked about I get an error screen. Not sure the picture will show up in the yahoo group.
It says " An error has occurred in the script on this page.
Line 1 char 1 error invalid argument. URL is http://www.stocksco
I get this same error for any symbols when I substitute for SIRI on my Vista system
I do not get this error on my laptop. When I repeat the exact sequence.
I tried at least 10 other URL's for other websites on both systems and I don't get any errors.
Any idea what is causing this error and if that is part of the problem.
From: smf_addin@yahoogrou
Sent: Thursday, March 07, 2013 12:35 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] I NEED HELP - this isdriving me nuts
What happens if you do an EXCEL Web Query on this URL and import the data:
http://www.stocksco
Do you see the data you want? Do you see the web page you want?
On Thu, Mar 7, 2013 at 10:18 AM, Kermit W. Prather <kermitp@tampabay.
I did the addin removal just as you wrote and reinstalled and it stills fails. I even uninstall power off the system and restarted everything and it still fails.
Somewhere there is something being left in excel or in a global but damn if I can figure it out.
Got any other suggestions?
I agree with everything you wrote. However, my vista 64bit is not working as it should with the addin.
Using this I still get error return in the cell.
=PROPER(RCHGetTable
Thu Mar 7, 2013 12:39 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I don't get that error when I do it. Are you using IE as your browser on
the laptop?
Do you have an older version of IE on that machine?
What happens if you click on "Yes" and continue?
On Thu, Mar 7, 2013 at 1:30 PM, Kermit W. Prather
<kermitp@tampabay.rr.com >wrote:
>
>
> Using the query you asked about I get an error screen. Not sure the
> picture will show up in the yahoo group. ****
>
> It says " An error has occurred in the script on this page. ****
>
> ** **
>
> Line 1 char 1 error invalid argument. URL is
> http://www.stockscores.com/quickreport.asp?ticker=SIRI****
>
> ** **
>
> I get this same error for any symbols when I substitute for SIRI on my
> Vista system****
>
> ** **
>
> *I do not get this error on my laptop*. When I repeat the exact sequence.
> ****
>
> ** **
>
> I tried at least 10 other URL's for other websites on both systems and I
> don't get any errors. ****
>
> ** **
>
> *Any idea what is causing this error and if that is part of the problem. *
> **
>
> ** **
>
> ****
>
> ** **
>
>
the laptop?
Do you have an older version of IE on that machine?
What happens if you click on "Yes" and continue?
On Thu, Mar 7, 2013 at 1:30 PM, Kermit W. Prather
<kermitp@tampabay.
>
>
> Using the query you asked about I get an error screen. Not sure the
> picture will show up in the yahoo group. ****
>
> It says " An error has occurred in the script on this page. ****
>
> ** **
>
> Line 1 char 1 error invalid argument. URL is
> http://www.stocksco
>
> ** **
>
> I get this same error for any symbols when I substitute for SIRI on my
> Vista system****
>
> ** **
>
> *I do not get this error on my laptop*. When I repeat the exact sequence.
> ****
>
> ** **
>
> I tried at least 10 other URL's for other websites on both systems and I
> don't get any errors. ****
>
> ** **
>
> *Any idea what is causing this error and if that is part of the problem. *
> **
>
> ** **
>
> ****
>
> ** **
>
>
Thu Mar 7, 2013 1:56 pm (PST) . Posted by:
"Kermit W. Prather" kermitpra
To answer your questions:
I am using IE version 9.0.13 (KB2792100) on both machines. I try to keep my machines up-to-date with Microsoft updates.
When I click yes and continue the web page loads with every field correct. The webpage looks the same if I reply Y or N
Well, I have good news and Bad news.
I discovered an old copy of the Addin in the appData/Roaming/Microsoft/Addin folder. I had deleted it twice. But I guess I must have done something between the delete and the reboot to cause it to reappear.
For the third time I remove every reference to the Addin from my Vista machine. I did the same thing I had done previously deleting, rebooting, re-downloading, and re-installing.
Good news is all MSN elements now work.
Good news now all Stockscores elements except 811-813 work but then they worked before
Bad news 811 -813 now fails for all symbols. I can live with not having that information but it would be nice to know why it fails.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Thursday, March 07, 2013 3:40 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] I NEED HELP - this isdriving me nuts
I don't get that error when I do it. Are you using IE as your browser on the laptop?
Do you have an older version of IE on that machine?
What happens if you click on "Yes" and continue?
On Thu, Mar 7, 2013 at 1:30 PM, Kermit W. Prather <kermitp@tampabay.rr.com > wrote:
Using the query you asked about I get an error screen. Not sure the picture will show up in the yahoo group.
It says " An error has occurred in the script on this page.
Line 1 char 1 error invalid argument. URL is http://www.stockscores.com/quickreport.asp?ticker=SIRI
I get this same error for any symbols when I substitute for SIRI on my Vista system
I do not get this error on my laptop. When I repeat the exact sequence.
I tried at least 10 other URL's for other websites on both systems and I don't get any errors.
Any idea what is causing this error and if that is part of the problem.
I am using IE version 9.0.13 (KB2792100) on both machines. I try to keep my machines up-to-date with Microsoft updates.
When I click yes and continue the web page loads with every field correct. The webpage looks the same if I reply Y or N
Well, I have good news and Bad news.
I discovered an old copy of the Addin in the appData/Roaming/
For the third time I remove every reference to the Addin from my Vista machine. I did the same thing I had done previously deleting, rebooting, re-downloading, and re-installing.
Good news is all MSN elements now work.
Good news now all Stockscores elements except 811-813 work but then they worked before
Bad news 811 -813 now fails for all symbols. I can live with not having that information but it would be nice to know why it fails.
From: smf_addin@yahoogrou
Sent: Thursday, March 07, 2013 3:40 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] I NEED HELP - this isdriving me nuts
I don't get that error when I do it. Are you using IE as your browser on the laptop?
Do you have an older version of IE on that machine?
What happens if you click on "Yes" and continue?
On Thu, Mar 7, 2013 at 1:30 PM, Kermit W. Prather <kermitp@tampabay.
Using the query you asked about I get an error screen. Not sure the picture will show up in the yahoo group.
It says " An error has occurred in the script on this page.
Line 1 char 1 error invalid argument. URL is http://www.stocksco
I get this same error for any symbols when I substitute for SIRI on my Vista system
I do not get this error on my laptop. When I repeat the exact sequence.
I tried at least 10 other URL's for other websites on both systems and I don't get any errors.
Any idea what is causing this error and if that is part of the problem.
Thu Mar 7, 2013 8:38 am (PST) . Posted by:
"Randy Harmelink" rharmelink
This works fine for me:
=smfGetOptionQuotes("gntx Jun 2013 17.5 Put","a",0,"Y")
The comma between 17 and 5 would never work, because the symbol list is
comma-delimited, so the function would see that as a divider between two
separate ticker symbols. If your system/EXCEL regional settings require
that comma-numeric specification, it will never work.
On Thu, Mar 7, 2013 at 3:13 AM, aronnisch <aronnisch@yahoo.com > wrote:
>
> the down function does not work with ecimals in strike price. Example 15
> works, 200 works but noz 17.5 or 17,5. In the same cell.
> The options exists.
>
> smfGetOptionQuotes"gntx Jun 2013 17,5 Put";"a";0;"Y"
> smfGetOptionQuotes"gntx Jun 2013 17.5 Put";"a";0;"Y"
>
> What do i am wrong?
>
=smfGetOptionQuotes
The comma between 17 and 5 would never work, because the symbol list is
comma-delimited, so the function would see that as a divider between two
separate ticker symbols. If your system/EXCEL regional settings require
that comma-numeric specification, it will never work.
On Thu, Mar 7, 2013 at 3:13 AM, aronnisch <aronnisch@yahoo.
>
> the down function does not work with ecimals in strike price. Example 15
> works, 200 works but noz 17.5 or 17,5. In the same cell.
> The options exists.
>
> smfGetOptionQuotes&
> smfGetOptionQuotes&
>
> What do i am wrong?
>
Thu Mar 7, 2013 10:44 am (PST) . Posted by:
"Dhiraj" frodo_dhiraj
hi,
I started using SMF addin very recently. One suggestion : There are lot of old files and many of them dont work with no consistency #NAME? error and files that are just there lying around.
would it make sense to do a clean up for lot of these files ? I am willing to volunteer. I can put an excel list with the files, Yahoo doesnt do a good job to even filter files by date on the groups website.
Just my feedback.
Thanks,
Dhiraj
I started using SMF addin very recently. One suggestion : There are lot of old files and many of them dont work with no consistency #NAME? error and files that are just there lying around.
would it make sense to do a clean up for lot of these files ? I am willing to volunteer. I can put an excel list with the files, Yahoo doesnt do a good job to even filter files by date on the groups website.
Just my feedback.
Thanks,
Dhiraj
Thu Mar 7, 2013 12:05 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Actually, if you use the recommended file location for the add-in, all of
my newer files will have #NAME? errors.
I had to change the location of my add-in because Vista wouldn't allow me
to update the add-in while it was in the "Program Files" directory.
Whenever I get the location errors, I just click on an icon on my toolbar
that runs the smfFixLinks macro. Although in protected worksheets, you do
need to unprotect the sheet first.
On Thu, Mar 7, 2013 at 11:44 AM, Dhiraj <dhiraj.chhajer@gmail.com > wrote:
>
> I started using SMF addin very recently. One suggestion : There are lot of
> old files and many of them dont work with no consistency #NAME? error and
> files that are just there lying around.
>
> would it make sense to do a clean up for lot of these files ? I am willing
> to volunteer. I can put an excel list with the files, Yahoo doesnt do a
> good job to even filter files by date on the groups website.
>
my newer files will have #NAME? errors.
I had to change the location of my add-in because Vista wouldn't allow me
to update the add-in while it was in the "Program Files" directory.
Whenever I get the location errors, I just click on an icon on my toolbar
that runs the smfFixLinks macro. Although in protected worksheets, you do
need to unprotect the sheet first.
On Thu, Mar 7, 2013 at 11:44 AM, Dhiraj <dhiraj.chhajer@
>
> I started using SMF addin very recently. One suggestion : There are lot of
> old files and many of them dont work with no consistency #NAME? error and
> files that are just there lying around.
>
> would it make sense to do a clean up for lot of these files ? I am willing
> to volunteer. I can put an excel list with the files, Yahoo doesnt do a
> good job to even filter files by date on the groups website.
>
Thu Mar 7, 2013 1:02 pm (PST) . Posted by:
"jtravisano2002" jtravisano2002
It's been years since I've used this add-in, but I was thinking it might be able to help with something and I was hoping to verify with the group....
A)How far back can I retrieve historical pricing data? For instance if I'm interested in a company that was publicly traded in 1950 could I get a closing price for any given day in that year?
B)Is there anyway to give a symbol and a historic time range and get a total return?
Thank you!
A)How far back can I retrieve historical pricing data? For instance if I'm interested in a company that was publicly traded in 1950 could I get a closing price for any given day in that year?
B)Is there anyway to give a symbol and a historic time range and get a total return?
Thank you!
Thu Mar 7, 2013 4:00 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
I think Yahoo historical quotes only go back to 1970 for companies. Indexes
can go back further.
You can use the smfPricesByDates() function to get the prices for two
dates, then compute the total return.
For example:
=smfPricesByDates("MMM","1/2/70","3/7/13")
On Thu, Mar 7, 2013 at 2:02 PM, jtravisano2002 <jacob.travisano@gmail.com >wrote:
> It's been years since I've used this add-in, but I was thinking it might
> be able to help with something and I was hoping to verify with the group....
>
> A)How far back can I retrieve historical pricing data? For instance if I'm
> interested in a company that was publicly traded in 1950 could I get a
> closing price for any given day in that year?
>
> B)Is there anyway to give a symbol and a historic time range and get a
> total return?
>
can go back further.
You can use the smfPricesByDates(
dates, then compute the total return.
For example:
=smfPricesByDates(
On Thu, Mar 7, 2013 at 2:02 PM, jtravisano2002 <jacob.travisano@
> It's been years since I've used this add-in, but I was thinking it might
> be able to help with something and I was hoping to verify with the group....
>
> A)How far back can I retrieve historical pricing data? For instance if I'm
> interested in a company that was publicly traded in 1950 could I get a
> closing price for any given day in that year?
>
> B)Is there anyway to give a symbol and a historic time range and get a
> total return?
>
Tidak ada komentar:
Posting Komentar