Messages In This Digest (25 Messages)
- 1a.
- options From: bob_cutillo
- 1b.
- two RCHGetElementNumber calls return "Error" message From: Ping Zhu
- 1c.
- Re: two RCHGetElementNumber calls return "Error" message From: Randy Harmelink
- 1d.
- Re: options From: Randy Harmelink
- 2a.
- The following is no longer working...3 6 and 12 month RS From: lulsh@sbcglobal.net
- 2b.
- Re: The following is no longer working...3 6 and 12 month RS From: Randy Harmelink
- 3a.
- GetElementNumber 13862 not working and GetElementNumber 25 not the l From: luigimaster73
- 3b.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: Randy Harmelink
- 3c.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: luigimaster73
- 3d.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: luigimaster73
- 3e.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: Randy Harmelink
- 3f.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: luigimaster73
- 3g.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: Harry Savas Financial Services
- 3h.
- Re: [Bulk] Re: [smf_addin] Re: GetElementNumber 13862 not working an From: Mike McQuaid
- 3i.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: Randy Harmelink
- 3j.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: Randy Harmelink
- 3k.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: Harry Savas Financial Services
- 3l.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: Randy Harmelink
- 3m.
- Re: GetElementNumber 13862 not working and GetElementNumber 25 not t From: Harry Savas Financial Services
- 4a.
- Only #Value! cells, no data! From: trichter877
- 4b.
- Re: Only #Value! cells, no data! From: Randy Harmelink
- 4c.
- Re: Only #Value! cells, no data! From: mutantcar
- 4d.
- Re: Only #Value! cells, no data! From: Randy Harmelink
- 4e.
- Re: Only #Value! cells, no data! From: mutantcar
- 5.1.
- New file uploaded to smf_addin From: smf_addin@yahoogroups.com
Messages
- 1a.
-
options
Posted by: "bob_cutillo" bob.cutillo@yahoo.com bob_cutillo
Thu May 10, 2012 6:49 am (PDT)
I have 2 questions on options:
1. I am retrieving quotes for individual options most of which work. The LULU example is the only one that gives a #value error
Cell C12 = LULU120616C00072500 - Doesn't work
Call on LULU June 16th 2012 at 72.50
Cell C12 = GOOG130119C00500000 - example that does work
Call on Google Jan 19 2013 at 500
=IF($P12=0,"",smfGetGoogleOp tionQuote( MID(C12,1, 4),MID(C12, 11,1),DATE( "20"&MID( C12,5,2), MID(C12,7, 2),MID(C12, 9,2)),MID( C12,12,5) ,"b"))
Do you see anything that I have coded incorrectly?
2. The quotes above give me a price of 0 when the market is closed. Is there a way to retrieve the last price pre / post market hours?
Thank you in advance
- 1b.
-
two RCHGetElementNumber calls return "Error" message
Posted by: "Ping Zhu" p_zhu00@yahoo.com p_zhu00
Thu May 10, 2012 9:05 am (PDT)
The following 2 functions are returning "Error" for me, either with the latest
SMF AddIn files (updated in February 2012).
Ticker = "IBM"
RCHGetElementNumber(Ticker, 1)
RCHGetElementNumber(Ticker, 13862)
The other RCHGetElementNumber calls all work for me.
Can someone tell me how to solve this issue?
Thanks and regards,
Ping
- 1c.
-
Re: two RCHGetElementNumber calls return "Error" message
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 9:22 am (PDT)
You probably just need the new smf-elements-1.txt file from the "Works in
Progress" folder. It has the latest element definitions for MSN elements.
On Thu, May 10, 2012 at 9:05 AM, Ping Zhu <p_zhu00@yahoo.com > wrote:
>
> The following 2 functions are returning "Error" for me, either with the
> latest SMF AddIn files (updated in February 2012).
>
> Ticker = "IBM"
> RCHGetElementNumber(Ticker, 1)
> RCHGetElementNumber(Ticker, 13862)
> The other RCHGetElementNumber calls all work for me.
>
> Can someone tell me how to solve this issue?
>
- 1d.
-
Re: options
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 9:28 am (PDT)
1. It's because your "MID(C12,12,5)" causes the strike price to be $72
for LULU. There is no such strike price.
2. You'd need to pick up the other data item when the market isn't open.
That could be adjusted with an IF() statement based on the current time.
On Thu, May 10, 2012 at 6:49 AM, bob_cutillo <bob.cutillo@yahoo.com > wrote:
> I have 2 questions on options:
>
> 1. I am retrieving quotes for individual options most of which work. The
> LULU example is the only one that gives a #value error
>
> Cell C12 = LULU120616C00072500 - Doesn't work
> Call on LULU June 16th 2012 at 72.50
>
> Cell C12 = GOOG130119C00500000 - example that does work
> Call on Google Jan 19 2013 at 500
>
>
> =IF($P12=0,"",smfGetGoogleOp tionQuote( MID(C12,1, 4),MID(C12, 11,1),DATE( "20"&MID( C12,5,2), MID(C12,7, 2),MID(C12, 9,2)),MID( C12,12,5) ,"b"))
>
> Do you see anything that I have coded incorrectly?
>
> 2. The quotes above give me a price of 0 when the market is closed. Is
> there a way to retrieve the last price pre / post market hours?
>
- 2a.
-
The following is no longer working...3 6 and 12 month RS
Posted by: "lulsh@sbcglobal.net" lulsh@sbcglobal.net lulsh@sbcglobal.net
Thu May 10, 2012 9:48 am (PDT)
=RCHGetElementNumber(A3,31)
Did I miss a change or fix?
- 2b.
-
Re: The following is no longer working...3 6 and 12 month RS
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 9:57 am (PDT)
Yes, you did. It's only been the major topic of discussion on the board for
the last several weeks.
You probably need the new smf-elements-1.txt file from the "Works in
Progress" folder. I had to redefine almost all of the MSN data elements
because of changes to their web site.
On Thu, May 10, 2012 at 9:48 AM, lulsh@sbcglobal.net <lulsh@sbcglobal.net >wrote:
> =RCHGetElementNumber(A3,31)
>
> Did I miss a change or fix?
>
- 3a.
-
GetElementNumber 13862 not working and GetElementNumber 25 not the l
Posted by: "luigimaster73" luis.martin@itradingfunds.com luigimaster73
Thu May 10, 2012 11:19 am (PDT)
=RCHGetElementNumber('DE:DAI' ;13862) = Error
=RCHGetElementNumber('DE:DAI' ;25) = Gives price from previous close not the last price.
I updated the last smf-elements-1.txt file from work in progress folder but not succeed.
What am I forgeting or making wrong ?
Any suggestion will be appreciated.
Thank you.
- 3b.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 11:26 am (PDT)
Element #25 is working as it should, at least as far as the add-in is
concerned -- you're getting what MSN is posting for "Last Price".
Element #13862 is returning "Daimler AG" for me. What do you get with:
=smfGetAParms(13862)
=TRIM(smfStrExtr("|"&smfGetTagCon tent("
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=DE: DAI
","div",-1,"class=""cn" ">"),"|", "<"))
=smfEval("TRIM(smfStrExtr( ""|""&smfGetTagC ontent(""
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=DE: DAI
"",""div"",-1,""class= """"cn""" ">""),""| "",""<"") )")
On Thu, May 10, 2012 at 11:18 AM, luigimaster73 <
luis.martin@itradingfunds. > wrote:com
> =RCHGetElementNumber('DE:DAI' ;13862) = Error
> =RCHGetElementNumber('DE:DAI' ;25) = Gives price from previous close not
> the last price.
>
> I updated the last smf-elements-1.txt file from work in progress folder
> but not succeed.
>
> What am I forgeting or making wrong ?
> Any suggestion will be appreciated.
>
- 3c.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "luigimaster73" luis.martin@itradingfunds.com luigimaster73
Thu May 10, 2012 11:54 am (PDT)
Result for : =smfGetAParms(13862)
MSN;Company Name;=TRIM(smfStrExtr("|"&smfGetTag Content("http://investing. money.msn. ","div",-1,"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=~~ ~~~ class=""cn" ">"),"|", "<"))
Result for the other two is an error in formula.
I'm using a spanish Excel and here the parameters are ";" delimited not "," delimited (if it may affect).
Thank you.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Element #25 is working as it should, at least as far as the add-in is
> concerned -- you're getting what MSN is posting for "Last Price".
>
> Element #13862 is returning "Daimler AG" for me. What do you get with:
>
> =smfGetAParms(13862)
>
> =TRIM(smfStrExtr("|"&smfGetTagCon tent("
> 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=DE: DAI
> ","div",-1,"class=""cn" ">"),"|", "<"))
>
> =smfEval("TRIM(smfStrExtr( ""|""&smfGetTagC ontent(""
> 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=DE: DAI
> "",""div"",-1,""class= """"cn""" ">""),""| "",""<"") )")
>
> On Thu, May 10, 2012 at 11:18 AM, luigimaster73 <
> luis.martin@...> wrote:
>
> > =RCHGetElementNumber('DE:DAI' ;13862) = Error
> > =RCHGetElementNumber('DE:DAI' ;25) = Gives price from previous close not
> > the last price.
> >
> > I updated the last smf-elements-1.txt file from work in progress folder
> > but not succeed.
> >
> > What am I forgeting or making wrong ?
> > Any suggestion will be appreciated.
> >
>
- 3d.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "luigimaster73" luis.martin@itradingfunds.com luigimaster73
Thu May 10, 2012 12:03 pm (PDT)
I think it is related with the international delimiters that Excel uses depeding the Regional settings.
--- In smf_addin@yahoogroups.com , "luigimaster73" <luis.martin@...> wrote:
>
> Result for : =smfGetAParms(13862)
>
>
> MSN;Company Name;=TRIM(smfStrExtr("|"&smfGetTag Content("http://investing. money.msn. ","div",-1,"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=~~ ~~~ class=""cn" ">"),"|", "<"))
>
>
> Result for the other two is an error in formula.
> I'm using a spanish Excel and here the parameters are ";" delimited not "," delimited (if it may affect).
>
> Thank you.
>
>
> --- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@> wrote:
> >
> > Element #25 is working as it should, at least as far as the add-in is
> > concerned -- you're getting what MSN is posting for "Last Price".
> >
> > Element #13862 is returning "Daimler AG" for me. What do you get with:
> >
> > =smfGetAParms(13862)
> >
> > =TRIM(smfStrExtr("|"&smfGetTagCon tent("
> > 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=DE: DAI
> > ","div",-1,"class=""cn" ">"),"|", "<"))
> >
> > =smfEval("TRIM(smfStrExtr( ""|""&smfGetTagC ontent(""
> > 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=DE: DAI
> > "",""div"",-1,""class= """"cn""" ">""),""| "",""<"") )")
> >
> > On Thu, May 10, 2012 at 11:18 AM, luigimaster73 <
> > luis.martin@> wrote:
> >
> > > =RCHGetElementNumber('DE:DAI' ;13862) = Error
> > > =RCHGetElementNumber('DE:DAI' ;25) = Gives price from previous close not
> > > the last price.
> > >
> > > I updated the last smf-elements-1.txt file from work in progress folder
> > > but not succeed.
> > >
> > > What am I forgeting or making wrong ?
> > > Any suggestion will be appreciated.
> > >
> >
>
- 3e.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 12:06 pm (PDT)
Sounds right. It's trying to evaluate a formula that uses commas instead of
semi-colons as delimiters, and that's probably what is causing the error to
occur.
On Thu, May 10, 2012 at 12:03 PM, luigimaster73 <
luis.martin@itradingfunds. > wrote:com
> I think it is related with the international delimiters that Excel uses
> depeding the Regional settings.
>
- 3f.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "luigimaster73" luis.martin@itradingfunds.com luigimaster73
Thu May 10, 2012 12:50 pm (PDT)
And where in the elements file should I make the replacements to match the specific regional settings ?
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Sounds right. It's trying to evaluate a formula that uses commas instead of
> semi-colons as delimiters, and that's probably what is causing the error to
> occur.
>
> On Thu, May 10, 2012 at 12:03 PM, luigimaster73 <
> luis.martin@...> wrote:
>
> > I think it is related with the international delimiters that Excel uses
> > depeding the Regional settings.
> >
>
- 3g.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "Harry Savas Financial Services" savasfinancial@yahoo.com savasfinancial
Thu May 10, 2012 1:02 pm (PDT)
My experience with 13862 is that it works for stock and ETF symbols, but no longer works for mutual fund tickers. When it did work, 13862 returned the most complete mutual fund name and class description. I'm now using 13863, but it doesn't always return a complete or accurate fund name and class. Is there some way to solve the 13862 Mutual Fund description issue?
Harry
--- On Thu, 5/10/12, luigimaster73 <luis.martin@itradingfunds. > wrote:com
From: luigimaster73 <luis.martin@itradingfunds. >com
Subject: [smf_addin] Re: GetElementNumber 13862 not working and GetElementNumber 25 not the last price
To: smf_addin@yahoogroups.com
Date: Thursday, May 10, 2012, 3:50 PM
And where in the elements file should I make the replacements to match the specific regional settings ?
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Sounds right. It's trying to evaluate a formula that uses commas instead of
> semi-colons as delimiters, and that's probably what is causing the error to
> occur.
>
> On Thu, May 10, 2012 at 12:03 PM, luigimaster73 <
> luis.martin@...> wrote:
>
> > I think it is related with the international delimiters that Excel uses
> > depeding the Regional settings.
> >
>
- 3h.
-
Re: [Bulk] Re: [smf_addin] Re: GetElementNumber 13862 not working an
Posted by: "Mike McQuaid" mikemcq802@yahoo.com mikemcq802
Thu May 10, 2012 1:10 pm (PDT)
If you don't like the name MSN has anymore, have you tried 13863 - the name
from Yahoo?
_____
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Harry Savas Financial Services
Sent: Thursday, May 10, 2012 4:03 PM
To: smf_addin@yahoogroups.com
Subject: [Bulk] Re: [smf_addin] Re: GetElementNumber 13862 not working and
GetElementNumber 25 not the last price
My experience with 13862 is that it works for stock and ETF symbols, but no
longer works for mutual fund tickers. When it did work, 13862 returned the
most complete mutual fund name and class description. I'm now using 13863,
but it doesn't always return a complete or accurate fund name and class. Is
there some way to solve the 13862 Mutual Fund description issue?
Harry
- 3i.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 1:43 pm (PDT)
You can't. The elements file uses semi-colons as delimiters between the
various pieces of the element definitions.
On Thu, May 10, 2012 at 12:50 PM, luigimaster73 <
luis.martin@itradingfunds. > wrote:com
> And where in the elements file should I make the replacements to match the
> specific regional settings ?
>
- 3j.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 1:47 pm (PDT)
13862 was NEVER intended to work for ETF or mutual funds, because it's
sourced from a STOCK print page.
For mutual funds, you will need your own formula. Try:
=smfGetTagContent("
http://investing.money.msn. com/investments/ fund-print- report/?symbol= VFINX
","a",1,"id=""quickquoteb" "")
On Thu, May 10, 2012 at 1:02 PM, Harry Savas Financial Services <
savasfinancial@yahoo.com > wrote:
>
> My experience with 13862 is that it works for stock and ETF symbols, but
> no longer works for mutual fund tickers. When it did work, 13862 returned
> the most complete mutual fund name and class description. I'm now using
> 13863, but it doesn't always return a complete or accurate fund name and
> class. Is there some way to solve the 13862 Mutual Fund description issue?
>
>
- 3k.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "Harry Savas Financial Services" savasfinancial@yahoo.com savasfinancial
Thu May 10, 2012 1:57 pm (PDT)
Thanks for the formula. How can I get it to work by picking up the fund symbol from another cell rather than type into the formula?
Thanks- Harry
--- On Thu, 5/10/12, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] Re: GetElementNumber 13862 not working and GetElementNumber 25 not the last price
To: smf_addin@yahoogroups.com
Date: Thursday, May 10, 2012, 4:47 PM
13862 was NEVER intended to work for ETF or mutual funds, because it's sourced from a STOCK print page.
For mutual funds, you will need your own formula. Try:
=smfGetTagContent("http://investing. money.msn. ","a",1,"id=com/investments/ fund-print- report/?symbol= VFINX ""quickquoteb" "")
On Thu, May 10, 2012 at 1:02 PM, Harry Savas Financial Services <savasfinancial@yahoo.com > wrote:
My experience with 13862 is that it works for stock and ETF symbols, but no longer works for mutual fund tickers. When it did work, 13862 returned the most complete mutual fund name and class description. I'm now using 13863, but it doesn't always return a complete or accurate fund name and class. Is there some way to solve the 13862 Mutual Fund description issue?
- 3l.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 2:19 pm (PDT)
I just uploaded a new copy of the smf-elements-1.txt that should allow the
extraction of a Mutual Fund name. Give it a try and let me know if it works
for your mutual funds -- I tried it with VFINX here and it worked.
I had to change the formula slightly -- the error was caused because I was
using the exchange as a delimiter for the end of the name. Exchange is only
reported for stocks and ETFs, so the mutual funds were erroring out. I put
in a "fake" exchange delimiter that the mutual fund will pick up, but will
be ignored on stocks and ETFs (because its after the actual reported
exchange).
On Thu, May 10, 2012 at 1:57 PM, Harry Savas Financial Services <
savasfinancial@yahoo.com > wrote:
>
> Thanks for the formula. How can I get it to work by picking up the fund
> symbol from another cell rather than type into the formula?
>
- 3m.
-
Re: GetElementNumber 13862 not working and GetElementNumber 25 not t
Posted by: "Harry Savas Financial Services" savasfinancial@yahoo.com savasfinancial
Thu May 10, 2012 2:35 pm (PDT)
The "Amazing Randy" has done it again. It works perfectly. Thank you so much for your excellent service.
Harry
--- On Thu, 5/10/12, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] Re: GetElementNumber 13862 not working and GetElementNumber 25 not the last price
To: smf_addin@yahoogroups.com
Date: Thursday, May 10, 2012, 5:19 PM
I just uploaded a new copy of the smf-elements-1.txt that should allow the extraction of a Mutual Fund name. Give it a try and let me know if it works for your mutual funds -- I tried it with VFINX here and it worked.
I had to change the formula slightly -- the error was caused because I was using the exchange as a delimiter for the end of the name. Exchange is only reported for stocks and ETFs, so the mutual funds were erroring out. I put in a "fake" exchange delimiter that the mutual fund will pick up, but will be ignored on stocks and ETFs (because its after the actual reported exchange).
On Thu, May 10, 2012 at 1:57 PM, Harry Savas Financial Services <savasfinancial@yahoo.com > wrote:
Thanks for the formula. How can I get it to work by picking up the fund symbol from another cell rather than type into the formula?
- 4a.
-
Only #Value! cells, no data!
Posted by: "trichter877" trichter87@googlemail.com trichter877
Thu May 10, 2012 1:42 pm (PDT)
Hey all,
I searched around in other messages but I didnt find the solution to my problem. I installed the addin fine in Excel 2010. It seems to have all the functions because when I type in "=RCH ..." it shows me the available functions... BUT
not even the easiest things work, at all.
I Type: =RCHGetYahooHistory("MSFT")
and all I get is lots of cells with #Value!
Thats it. No other functions work as well.
What to do? In internet explorer security is on low and I tried the trick with security settings and enabling access. It doesnt work!
- 4b.
-
Re: Only #Value! cells, no data!
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 1:49 pm (PDT)
That works fine here. Can you attach a copy of a workbook with just that
formula in it, so I can verify what you have?
Typically, I would interpret #VALUE! in that situation to mean you did not
enter a proper string as the first parameter. I've seen that when people
use left-double-quote and right-double- quote instead of the regular
double-quote to delimit the string, but that's not what you are showing
below.
On Thu, May 10, 2012 at 12:40 PM, trichter877 <trichter87@googlemail.com >wrote:
>
> I searched around in other messages but I didnt find the solution to my
> problem. I installed the addin fine in Excel 2010. It seems to have all the
> functions because when I type in "=RCH ..." it shows me the available
> functions... BUT
>
> not even the easiest things work, at all.
>
> I Type: =RCHGetYahooHistory("MSFT")
> and all I get is lots of cells with #Value!
>
> Thats it. No other functions work as well.
>
> What to do? In internet explorer security is on low and I tried the trick
> with security settings and enabling access. It doesnt work!
>
- 4c.
-
Re: Only #Value! cells, no data!
Posted by: "mutantcar" mutant.car@virgin.net mutantcar
Thu May 10, 2012 3:01 pm (PDT)
Hi,
Sounds similar to a problem I just had. I am, however, running a slightly customised version of Randy's file. I think it was related to recent Windows updates I've applied, presumably security on Office 2010.
If you go to 'Data' tab, 'Edit Links', select 'RCH_Stock_Market_Functions. xla', and 'Open Source', do you get a message about macro security? I can't remember the appropriate response, but allow macros to run?
Sorry if this is a red-herring, but my setup is different, so perhaps not this. Worth a try though?
Huw.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> That works fine here. Can you attach a copy of a workbook with just that
> formula in it, so I can verify what you have?
>
> Typically, I would interpret #VALUE! in that situation to mean you did not
> enter a proper string as the first parameter. I've seen that when people
> use left-double-quote and right-double- quote instead of the regular
> double-quote to delimit the string, but that's not what you are showing
> below.
>
> On Thu, May 10, 2012 at 12:40 PM, trichter877 <trichter87@...>wrote:
>
> >
> > I searched around in other messages but I didnt find the solution to my
> > problem. I installed the addin fine in Excel 2010. It seems to have all the
> > functions because when I type in "=RCH ..." it shows me the available
> > functions... BUT
> >
> > not even the easiest things work, at all.
> >
> > I Type: =RCHGetYahooHistory("MSFT")
> > and all I get is lots of cells with #Value!
> >
> > Thats it. No other functions work as well.
> >
> > What to do? In internet explorer security is on low and I tried the trick
> > with security settings and enabling access. It doesnt work!
> >
>
- 4d.
-
Re: Only #Value! cells, no data!
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Thu May 10, 2012 3:17 pm (PDT)
You should never need to tell EXCEL to run macros in order to use add-in
functions or macros. The fact you've added it via the add-in manager tells
EXCEL that the add-in has the security clearance to run.
On Thu, May 10, 2012 at 3:00 PM, mutantcar <mutant.car@virgin.net > wrote:
> Hi,
>
> Sounds similar to a problem I just had. I am, however, running a slightly
> customised version of Randy's file. I think it was related to recent
> Windows updates I've applied, presumably security on Office 2010.
>
> If you go to 'Data' tab, 'Edit Links', select
> 'RCH_Stock_Market_Functions. xla', and 'Open Source', do you get a message
> about macro security? I can't remember the appropriate response, but allow
> macros to run?
>
> Sorry if this is a red-herring, but my setup is different, so perhaps not
> this. Worth a try though?
>
> Huw.
>
- 4e.
-
Re: Only #Value! cells, no data!
Posted by: "mutantcar" mutant.car@virgin.net mutantcar
Thu May 10, 2012 4:27 pm (PDT)
You're correct I'm sure Randy. As I said, I'm using a slightly modified version, and I don't think I've added it correctly as an Add In. I'll take a look sometime.
It's been working fine, but since Windows update, it appears I need to Edit links, Open source, and Enable Macros in an Excel Security notice popup.
Maybe the OP hasn't correctly added the Add In?
- 5.1.
-
New file uploaded to smf_addin
Posted by: "smf_addin@yahoogroups.com" smf_addin@yahoogroups.com
Thu May 10, 2012 2:16 pm (PDT)
Hello,
This email message is a notification to let you know that
a file has been uploaded to the Files area of the smf_addin
group.
File : /Works-In-Progress/smf-elements- 1.txt
Uploaded by : rharmelink <rharmelink@gmail.com >
Description : Contains updates to MSN data element definitions, which had to be redefined because of URL and page layout changes made by MSN. These definitions are used by the RCHGetElementNumber() function.
You can access this file at the URL:
http://groups.yahoo.com/ group/smf_ addin/files/ Works-In- Progress/ smf-elements- 1.txt
To learn more about file sharing for your group, please visit:
http://help.yahoo.com/ l/us/yahoo/ groups/original/ members/web/ index.html
Regards,
rharmelink <rharmelink@gmail.com >
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar