15 New Messages
Digest #2666
Messages
Fri Jun 21, 2013 5:51 am (PDT) . Posted by:
"Thomas" tg.bruin
I am able to get quotes just fine for the SnP500 but cannot get quotes for NAZ or DJI. I am tring to retrieve Hi/Lo/Last (or close)prices for each index. I am using following formula/syntax:
=RCHGetYahooQuotes(B3,"l1",NOW())
the cell reference in this example is for NASDAQ using the symbol ^IXIC (what finance.yahoo.com shows as the symbol for Nasdaq.) The formula returns a price that is not correct, and the formula adjusted for retrieving high and low prices retrieves the exact same price as Last.
For DJIA I am using the symbol ^DJI and it returns the message "missing symbols list"
SECOND QUESTION: I assume that unless I include the NOW() parameter, there is no other way to refresh the data? I am also using the formula above for individual stock quotes, and it is working just fine for that, but it seems to really slow down the operation of my spreadsheet, and when I hit F9 to refresh it takes a very long time to cycle thru the refresh.
Any help is appreciated, thanks.
P.S. -- I know a similar question was posted here (re: quotes for indices) but I did not understand your reply.
=RCHGetYahooQuotes(
the cell reference in this example is for NASDAQ using the symbol ^IXIC (what finance.yahoo.
For DJIA I am using the symbol ^DJI and it returns the message "missing symbols list"
SECOND QUESTION: I assume that unless I include the NOW() parameter, there is no other way to refresh the data? I am also using the formula above for individual stock quotes, and it is working just fine for that, but it seems to really slow down the operation of my spreadsheet, and when I hit F9 to refresh it takes a very long time to cycle thru the refresh.
Any help is appreciated, thanks.
P.S. -- I know a similar question was posted here (re: quotes for indices) but I did not understand your reply.
Fri Jun 21, 2013 6:06 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
- The add-in is processing ^IXIC properly. That's what Yahoo is sending.
You can always check by going here:
http://finance.yahoo.com/q?s= ^IXIC
...and clicking on the "Download Data (delayed)" link. That's a version
of file that the add-in is using.
- But it won't work for ^DJI. About a year or so ago, Dow Jones cracked
down on usage of their quotes an their licensing agreement with Yahoo won't
let Yahoo provide and Dow Jones quotes in CSV format. Note that if you go
to:
http://finance.yahoo.com/q?s= ^DJI
...there is no "Download Data (delayed)" link.
- I prefer to refresh add-in functions with the smfForceRecalculation
macro. It's required for refreshing many of the other functions. I have the
macro on a button on my toolbar. More info on the macro can be found in the
LINKS area of the group.
- If you want to speed up your RCHGetYahooQuotes() data retrieval, you
should array-enter the function(s) over a range. Then it can return
numerous data items on up to 200 stocks with a single Internet access.
Otherwise, if you enter one function per cell, each function requires an
individual Internet access. Very slow if you have a number of them.
On Fri, Jun 21, 2013 at 5:47 AM, Thomas <thos.bruin@gmail.com > wrote:
> I am able to get quotes just fine for the SnP500 but cannot get quotes for
> NAZ or DJI. I am tring to retrieve Hi/Lo/Last (or close)prices for each
> index. I am using following formula/syntax:
>
> =RCHGetYahooQuotes(B3,"l1",NOW())
>
> the cell reference in this example is for NASDAQ using the symbol ^IXIC
> (what finance.yahoo.com shows as the symbol for Nasdaq.) The formula
> returns a price that is not correct, and the formula adjusted for
> retrieving high and low prices retrieves the exact same price as Last.
>
> For DJIA I am using the symbol ^DJI and it returns the message "missing
> symbols list"
>
> SECOND QUESTION: I assume that unless I include the NOW() parameter,
> there is no other way to refresh the data? I am also using the formula
> above for individual stock quotes, and it is working just fine for that,
> but it seems to really slow down the operation of my spreadsheet, and when
> I hit F9 to refresh it takes a very long time to cycle thru the refresh.
>
> Any help is appreciated, thanks.
>
> P.S. -- I know a similar question was posted here (re: quotes for indices)
> but I did not understand your reply.
>
You can always check by going here:
http://finance.
...and clicking on the "Download Data (delayed)" link. That's a version
of file that the add-in is using.
- But it won't work for ^DJI. About a year or so ago, Dow Jones cracked
down on usage of their quotes an their licensing agreement with Yahoo won't
let Yahoo provide and Dow Jones quotes in CSV format. Note that if you go
to:
http://finance.
...there is no "Download Data (delayed)" link.
- I prefer to refresh add-in functions with the smfForceRecalculati
macro. It's required for refreshing many of the other functions. I have the
macro on a button on my toolbar. More info on the macro can be found in the
LINKS area of the group.
- If you want to speed up your RCHGetYahooQuotes(
should array-enter the function(s) over a range. Then it can return
numerous data items on up to 200 stocks with a single Internet access.
Otherwise, if you enter one function per cell, each function requires an
individual Internet access. Very slow if you have a number of them.
On Fri, Jun 21, 2013 at 5:47 AM, Thomas <thos.bruin@gmail.
> I am able to get quotes just fine for the SnP500 but cannot get quotes for
> NAZ or DJI. I am tring to retrieve Hi/Lo/Last (or close)prices for each
> index. I am using following formula/syntax:
>
> =RCHGetYahooQuotes(
>
> the cell reference in this example is for NASDAQ using the symbol ^IXIC
> (what finance.yahoo.
> returns a price that is not correct, and the formula adjusted for
> retrieving high and low prices retrieves the exact same price as Last.
>
> For DJIA I am using the symbol ^DJI and it returns the message "missing
> symbols list"
>
> SECOND QUESTION: I assume that unless I include the NOW() parameter,
> there is no other way to refresh the data? I am also using the formula
> above for individual stock quotes, and it is working just fine for that,
> but it seems to really slow down the operation of my spreadsheet, and when
> I hit F9 to refresh it takes a very long time to cycle thru the refresh.
>
> Any help is appreciated, thanks.
>
> P.S. -- I know a similar question was posted here (re: quotes for indices)
> but I did not understand your reply.
>
Fri Jun 21, 2013 7:29 am (PDT) . Posted by:
"Kermit W. Prather" kermitpra
First you have to answer the question Relative Strength to what? The "what" is an important part of the question.
The most common comparison is to the SP-500 or SPY an EFT of all stocks in the SP-500. You will need to calculate the value for most any other index or stock.
Checkout this Video recently done by my friends at Worden.com. They do an excellent job as usual.
Webinar: Uncover Relative Strength with Comparison Charts <http://www.worden.com/videos/index/169 >
It is easy to compare multiple price plots on one chart in TC2000. This technique creates easy-to-understand relative strength relationships between symbols. Easily make apples-to-apples comparisons between stocks, ETFs, Indexes or any related symbols you want. You'll instantly see stocks moving together or diverging and how they are performing against each other.
You might want to check out this link:
http://stockcharts.com/school/doku.php?id=chart_school:technical_indicators:relative_strength_index_rsi
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of kabrod77
Sent: Thursday, June 20, 2013 8:10 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] 13862 now returns a blank
Do you know where I can get the Relative Strength numbers?
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Wednesday, June 19, 2013 8:43 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] 13862 now returns a blank
It appears MSN dropped those items...I don't see them anywhere on the new print page.
On Wed, Jun 19, 2013 at 5:40 PM, kabrod77 <kabrod77@verizon.net > wrote:
Tried the new file – have errors with
=RCHGetElementNumber($A$1,27)
=RCHGetElementNumber($A$1, 28)
The most common comparison is to the SP-500 or SPY an EFT of all stocks in the SP-500. You will need to calculate the value for most any other index or stock.
Checkout this Video recently done by my friends at Worden.com. They do an excellent job as usual.
Webinar: Uncover Relative Strength with Comparison Charts <http://www.worden.
It is easy to compare multiple price plots on one chart in TC2000. This technique creates easy-to-understand relative strength relationships between symbols. Easily make apples-to-apples comparisons between stocks, ETFs, Indexes or any related symbols you want. You'll instantly see stocks moving together or diverging and how they are performing against each other.
You might want to check out this link:
http://stockcharts.
From: smf_addin@yahoogrou
Sent: Thursday, June 20, 2013 8:10 PM
To: smf_addin@yahoogrou
Subject: RE: [smf_addin] 13862 now returns a blank
Do you know where I can get the Relative Strength numbers?
From: smf_addin@yahoogrou
Sent: Wednesday, June 19, 2013 8:43 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] 13862 now returns a blank
It appears MSN dropped those items...I don't see them anywhere on the new print page.
On Wed, Jun 19, 2013 at 5:40 PM, kabrod77 <kabrod77@verizon.
Tried the new file – have errors with
=RCHGetElementNumbe
=RCHGetElementNumbe
Fri Jun 21, 2013 8:11 am (PDT) . Posted by:
"nap1805" nap1805
Thank you for the heads up prompt response.
The browser I used was Internet Explorer.
Using =RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MCD ",1) I get an error message.
Regards.
--- In smf_addin@yahoogroups.com , "Randy H" <rharmelink@...> wrote:
>
> When you say "go in the browser", which browser? The add-in uses the
> MicroSoft DLL libraries, so it would use the same process as IE. Going
> to the web page in FireFox would tell you little.
>
> The other thing you can do is look at the actual source code returned to
> the add-in:
>
> =RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MCD ",1)
>
> From time to time, when someone has an issue, that content has some
> type of website-based error message. Or, if "Error", it means the
> add-in couldn't even retrieve the web page for some reason...
>
> PS: You need to send add-in questions to the Yahoo group. I have email
> filters that direct them to a folder. I found this message in my SPAM
> folder, which means it could easily have deleted without me ever seeing
> it.
>
> On Thu, Jun 20, 2013 at 7:35 PM, nap1805 <nap1805@...
> <mailto:nap1805@...> > wrote:
>
> First of all, thanks for the add-in and support. It greatly improves the
> capabilities of Excel.
>
> I am having a problem retrieving Google info. To give you some
> background:
>
> - =RCHGETELEMENTNUMBER("Version" )returns Stock Market Functions add-in,
> Version 2.1.2013.06.03 (C:\Program Files\SMF ADD-IN; 1)
> - =smfGetAParms(3380) returns Google;Annual Income Statement --
> Operating Income -- FY1;http://www.google.com/
> finance?fstype=ii&q=~~~~~;1; INCANNUALDIV;Operating
> <http://www.google.com/finance?fstype=ii&q=%7E%7E%7E%7E%7E;1;INCANNUALDI\
> V;Operating> Income; ; ;0;</TABLE;0;0
> - I am able to retrieve info from MSN, YAHOO, Morningstar etc, but not
> Google.
> - I am also able to go in the browser and access
> http://www.google.com/finance? fstype=ii&q=MCD
> <http://www.google.com/finance?fstype=ii&q=MCD >
>
> What do you think can be generating the problem?
>
The browser I used was Internet Explorer.
Using =RCHGetWebData(
Regards.
--- In smf_addin@yahoogrou
>
> When you say "go in the browser"
> MicroSoft DLL libraries, so it would use the same process as IE. Going
> to the web page in FireFox would tell you little.
>
> The other thing you can do is look at the actual source code returned to
> the add-in:
>
> =RCHGetWebData(
>
> From time to time, when someone has an issue, that content has some
> type of website-based error message. Or, if "Error"
> add-in couldn't even retrieve the web page for some reason...
>
> PS: You need to send add-in questions to the Yahoo group. I have email
> filters that direct them to a folder. I found this message in my SPAM
> folder, which means it could easily have deleted without me ever seeing
> it.
>
> On Thu, Jun 20, 2013 at 7:35 PM, nap1805 <nap1805@
> <mailto:nap1805@
>
> First of all, thanks for the add-in and support. It greatly improves the
> capabilities of Excel.
>
> I am having a problem retrieving Google info. To give you some
> background:
>
> - =RCHGETELEMENTNUMBE
> Version 2.1.2013.06.
> - =smfGetAParms(
> Operating Income -- FY1;http://www.google.
> finance?fstype=
> <http://www.google.
> - I am able to retrieve info from MSN, YAHOO, Morningstar etc, but not
> Google.
> - I am also able to go in the browser and access
> http://www.google.
> <http://www.google.
>
> What do you think can be generating the problem?
>
Fri Jun 21, 2013 8:14 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You get an error MESSAGE? Or just get a value of "Error" returned?
If the latter, it means the add-in isn't able to read the source code of
the web page, for whatever reason.
Are you able to visit that web page with the EXCEL Web Query dialog? That
is, does it look normal? Can you do a query to import the contents of the
web page?
You don't have a firewall that would prevent EXCEL from accessing Google,
right?
On Fri, Jun 21, 2013 at 8:07 AM, nap1805 <nap1805@yahoo.com > wrote:
> Thank you for the heads up prompt response.
>
> The browser I used was Internet Explorer.
>
> Using =RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MCD ",1) I
> get an error message.
>
If the latter, it means the add-in isn't able to read the source code of
the web page, for whatever reason.
Are you able to visit that web page with the EXCEL Web Query dialog? That
is, does it look normal? Can you do a query to import the contents of the
web page?
You don't have a firewall that would prevent EXCEL from accessing Google,
right?
On Fri, Jun 21, 2013 at 8:07 AM, nap1805 <nap1805@yahoo.
> Thank you for the heads up prompt response.
>
> The browser I used was Internet Explorer.
>
> Using =RCHGetWebData(
> get an error message.
>
Fri Jun 21, 2013 3:48 pm (PDT) . Posted by:
"nap1805" nap1805
I just get the value of "error". I am able to visit the website using Excel query and it looks normal but I am unable to import the date. I get a message from excel stating "This query returned no data..." This does not happen when I try to import data from yahoo.finance or others. I don't think I have a firewall. I will double check.
Thanks.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> You get an error MESSAGE? Or just get a value of "Error" returned?
>
> If the latter, it means the add-in isn't able to read the source code of
> the web page, for whatever reason.
>
> Are you able to visit that web page with the EXCEL Web Query dialog? That
> is, does it look normal? Can you do a query to import the contents of the
> web page?
>
> You don't have a firewall that would prevent EXCEL from accessing Google,
> right?
>
> On Fri, Jun 21, 2013 at 8:07 AM, nap1805 <nap1805@...> wrote:
>
> > Thank you for the heads up prompt response.
> >
> > The browser I used was Internet Explorer.
> >
> > Using =RCHGetWebData("http://www.google.com/finance?fstype=ii&q=MCD ",1) I
> > get an error message.
> >
>
Thanks.
--- In smf_addin@yahoogrou
>
> You get an error MESSAGE? Or just get a value of "Error" returned?
>
> If the latter, it means the add-in isn't able to read the source code of
> the web page, for whatever reason.
>
> Are you able to visit that web page with the EXCEL Web Query dialog? That
> is, does it look normal? Can you do a query to import the contents of the
> web page?
>
> You don't have a firewall that would prevent EXCEL from accessing Google,
> right?
>
> On Fri, Jun 21, 2013 at 8:07 AM, nap1805 <nap1805@
>
> > Thank you for the heads up prompt response.
> >
> > The browser I used was Internet Explorer.
> >
> > Using =RCHGetWebData(
> > get an error message.
> >
>
Fri Jun 21, 2013 4:00 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Hmmm. I also get the message about the query returning no data. But I can
still access the web page with the add-in functions.
The very fact you can bring up the web page in EXCEL means you don't have a
firewall preventing access to it.
I'm really at a loss to explain why you can't access the Google data.
Can you access AdvFN data? In the LINKS area of the group, there is an IE
setting that needs to be toggled to access AdvFN data. It could be the same
setting is preventing access to Google. But I'm grasping at straws for that.
On Fri, Jun 21, 2013 at 3:48 PM, nap1805 <nap1805@yahoo.com > wrote:
> I just get the value of "error". I am able to visit the website using
> Excel query and it looks normal but I am unable to import the date. I get a
> message from excel stating "This query returned no data..." This does not
> happen when I try to import data from yahoo.finance or others. I don't
> think I have a firewall. I will double check.
>
still access the web page with the add-in functions.
The very fact you can bring up the web page in EXCEL means you don't have a
firewall preventing access to it.
I'm really at a loss to explain why you can't access the Google data.
Can you access AdvFN data? In the LINKS area of the group, there is an IE
setting that needs to be toggled to access AdvFN data. It could be the same
setting is preventing access to Google. But I'm grasping at straws for that.
On Fri, Jun 21, 2013 at 3:48 PM, nap1805 <nap1805@yahoo.
> I just get the value of "error"
> Excel query and it looks normal but I am unable to import the date. I get a
> message from excel stating "This query returned no data..." This does not
> happen when I try to import data from yahoo.finance or others. I don't
> think I have a firewall. I will double check.
>
Fri Jun 21, 2013 8:12 am (PDT) . Posted by:
"mdkumar kumar" mdkumarz
Hi All,
Floods in Uttarakhand saw much devastation and human loss. Time to
pitch in with help. I made my donation. Time's about you do it too. Money
or service is welcome. Contact:
Sewa Bharati,
http://www.sewabharathi.com/2013/06/appeal-for-support-2013-uttarakhand.html
About Sewa Bharati(WIKI)
http://en.wikipedia.org/wiki/Seva_Bharati#External_links
PS: Not issued by Sewa Bharati,
--
Yours sincerely,
Draksharamam Kumar Mandavilli
mdkumarz@gmail.com ,
Floods in Uttarakhand saw much devastation and human loss. Time to
pitch in with help. I made my donation. Time's about you do it too. Money
or service is welcome. Contact:
Sewa Bharati,
http://www.sewabhar
About Sewa Bharati(WIKI)
http://en.wikipedia
PS: Not issued by Sewa Bharati,
--
Yours sincerely,
Draksharamam Kumar Mandavilli
mdkumarz@gmail.
Fri Jun 21, 2013 9:01 am (PDT) . Posted by:
"Bob Nauman" rkn001
Where and which file in "FILES" do I find a file to download to install the
smf_addin?
smf_addin?
Fri Jun 21, 2013 9:56 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Documentation is in the DOCUMENTATION folder.
The add-in is in the ADD-IN FILES folder.
There are also several items in the LINKS area of the group with
step-by-step instructions written by others.
On Fri, Jun 21, 2013 at 8:50 AM, Bob Nauman <rnauman1@nc.rr.com > wrote:
>
> Where and which file in "FILES" do I find a file to download to install
> the smf_addin?
>
The add-in is in the ADD-IN FILES folder.
There are also several items in the LINKS area of the group with
step-by-step instructions written by others.
On Fri, Jun 21, 2013 at 8:50 AM, Bob Nauman <rnauman1@nc.
>
> Where and which file in "FILES" do I find a file to download to install
> the smf_addin?
>
Fri Jun 21, 2013 10:32 am (PDT) . Posted by:
"ron125" ron125
I have been looking and cannot find the function. I'm assuming I need to set this up as an add-in like I did with MSN stock quotes.
I did try entering the following in the first row:
ARNA #NAME?
The first row is the stock symbol and the second row has =RCHGetYahooQuotes( "ARNA","l1" )
What am I missing?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Not a work-around. A better method. Use the RCHGetYahooQuotes() function.
> For example:
>
> =RCHGetYahooQuotes("MMM","l1")
>
> On Thu, Jun 20, 2013 at 8:26 AM, ron125 <ron125@...> wrote:
>
> >
> > Is there a work around to get the last quote into a cell?
> >
>
I did try entering the following in the first row:
ARNA #NAME?
The first row is the stock symbol and the second row has =RCHGetYahooQuotes( "ARNA"
What am I missing?
--- In smf_addin@yahoogrou
>
> Not a work-around. A better method. Use the RCHGetYahooQuotes(
> For example:
>
> =RCHGetYahooQuotes(
>
> On Thu, Jun 20, 2013 at 8:26 AM, ron125 <ron125@.
>
> >
> > Is there a work around to get the last quote into a cell?
> >
>
Fri Jun 21, 2013 10:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
You'd need to install the SMF add-in found the FILES area. Documentation is
in the DOCUMENTATION folder. Tips and FAQ are in the LINKS area of the
group, including several links to several blogs of people showing
step-by-step instructions for installing the add-in.
On Fri, Jun 21, 2013 at 10:32 AM, ron125 <ron125@yahoo.com > wrote:
> I have been looking and cannot find the function. I'm assuming I need to
> set this up as an add-in like I did with MSN stock quotes.
>
> I did try entering the following in the first row:
> ARNA #NAME?
> The first row is the stock symbol and the second row has
> =RCHGetYahooQuotes( "ARNA","l1" )
>
> What am I missing?
>
in the DOCUMENTATION folder. Tips and FAQ are in the LINKS area of the
group, including several links to several blogs of people showing
step-by-step instructions for installing the add-in.
On Fri, Jun 21, 2013 at 10:32 AM, ron125 <ron125@yahoo.
> I have been looking and cannot find the function. I'm assuming I need to
> set this up as an add-in like I did with MSN stock quotes.
>
> I did try entering the following in the first row:
> ARNA #NAME?
> The first row is the stock symbol and the second row has
> =RCHGetYahooQuotes( "ARNA"
>
> What am I missing?
>
Fri Jun 21, 2013 3:30 pm (PDT) . Posted by:
"Kermit W. Prather" kermitpra
Here is an excellent write-up on installing the SMF ADDIN. Even my wife could follow it.
So I have attached a very small spreadsheet that will test for a proper install.
<http://www.traineetrader.com/importing-stock-quotes-to-excel-using-smf-add-in/ > http://www.traineetrader.com/importing-stock-quotes-to-excel-using-smf-add-in/
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Friday, June 21, 2013 1:51 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Re: MSN moved the goal posts
You'd need to install the SMF add-in found the FILES area. Documentation is in the DOCUMENTATION folder. Tips and FAQ are in the LINKS area of the group, including several links to several blogs of people showing step-by-step instructions for installing the add-in.
On Fri, Jun 21, 2013 at 10:32 AM, ron125 <ron125@yahoo.com > wrote:
I have been looking and cannot find the function. I'm assuming I need to set this up as an add-in like I did with MSN stock quotes.
I did try entering the following in the first row:
ARNA #NAME?
The first row is the stock symbol and the second row has =RCHGetYahooQuotes( "ARNA","l1" )
What am I missing?
So I have attached a very small spreadsheet that will test for a proper install.
<http://www.traineet
From: smf_addin@yahoogrou
Sent: Friday, June 21, 2013 1:51 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Re: MSN moved the goal posts
You'd need to install the SMF add-in found the FILES area. Documentation is in the DOCUMENTATION folder. Tips and FAQ are in the LINKS area of the group, including several links to several blogs of people showing step-by-step instructions for installing the add-in.
On Fri, Jun 21, 2013 at 10:32 AM, ron125 <ron125@yahoo.
I have been looking and cannot find the function. I'm assuming I need to set this up as an add-in like I did with MSN stock quotes.
I did try entering the following in the first row:
ARNA #NAME?
The first row is the stock symbol and the second row has =RCHGetYahooQuotes( "ARNA"
What am I missing?
Attachments with this message:
1 of 1 File(s)
Fri Jun 21, 2013 3:23 pm (PDT) . Posted by:
"aishu_1110" aishu_1110
Hi Randy,
I was trying this function on some data, but it returned error in some cases. I checked with inputs, html formats and everything related. Everything is uniform, but the o/p still remains error. I am posting a sample of the xls. Would appreciate your help.
Thanks
Meena
(I could not attach it to this message, so mailing it.)
I was trying this function on some data, but it returned error in some cases. I checked with inputs, html formats and everything related. Everything is uniform, but the o/p still remains error. I am posting a sample of the xls. Would appreciate your help.
Thanks
Meena
(I could not attach it to this message, so mailing it.)
Fri Jun 21, 2013 3:53 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Everything looked fine in the workbook you sent. I saw no "Error" values
returned.
On Fri, Jun 21, 2013 at 3:23 PM, aishu_1110 <aishu_1110@yahoo.com > wrote:
>
> I was trying this function on some data, but it returned error in some
> cases. I checked with inputs, html formats and everything related.
> Everything is uniform, but the o/p still remains error. I am posting a
> sample of the xls. Would appreciate your help.
>
returned.
On Fri, Jun 21, 2013 at 3:23 PM, aishu_1110 <aishu_1110@yahoo.
>
> I was trying this function on some data, but it returned error in some
> cases. I checked with inputs, html formats and everything related.
> Everything is uniform, but the o/p still remains error. I am posting a
> sample of the xls. Would appreciate your help.
>
Tidak ada komentar:
Posting Komentar