11 New Messages
Digest #2595
Messages
Thu Apr 25, 2013 3:41 am (PDT) . Posted by:
"sewuzy" sewuzy
Randy,
Wonderful, Thanks so much for your kind explanation.
Seth
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> What I would usually do is:
>
> =smfPricesBetween(A2,B2,C2,"09")
>
> ...where cell A2 contains the ticker symbol, cell B2 contains the starting
> date, and cell C2 contains the ending date. It would certainly be possible
> to do:
>
> =smfPricesBetween(A2,B2,B2+90,"09")
>
> If you want to do multiple periods, it would be faster to retrieve the data
> once with RCHGetYahooHistory() and then extract your volumes from that
> returned range of data.
>
> On Tue, Apr 23, 2013 at 8:20 PM, sewuzy <sewuzy@...> wrote:
>
> >
> > Perhaps I misread what you meant in saying that any of the parameters
> > below could be cell references ---- in generating cumulative volume
> > between dates:
> >
> > =smfPricesBetween("MMM",DATE(2013,4,1),DATE(2013,4,1),"09")
> >
> > I was unsuccessful in trying this variation (P5 being a cell with a date:
> >
> > =smfPricesBetween("MMM",DATE(P5),DATE(P5),"09")
> >
> > Do you merely mean that each of 2013 and 4 and 1 could be a separate cell
> > reference?
> >
>
Wonderful, Thanks so much for your kind explanation.
Seth
--- In smf_addin@yahoogrou
>
> What I would usually do is:
>
> =smfPricesBetween(
>
> ...where cell A2 contains the ticker symbol, cell B2 contains the starting
> date, and cell C2 contains the ending date. It would certainly be possible
> to do:
>
> =smfPricesBetween(
>
> If you want to do multiple periods, it would be faster to retrieve the data
> once with RCHGetYahooHistory(
> returned range of data.
>
> On Tue, Apr 23, 2013 at 8:20 PM, sewuzy <sewuzy@.
>
> >
> > Perhaps I misread what you meant in saying that any of the parameters
> > below could be cell references ---- in generating cumulative volume
> > between dates:
> >
> > =smfPricesBetween(
> >
> > I was unsuccessful in trying this variation (P5 being a cell with a date:
> >
> > =smfPricesBetween(
> >
> > Do you merely mean that each of 2013 and 4 and 1 could be a separate cell
> > reference?
> >
>
Thu Apr 25, 2013 8:30 am (PDT) . Posted by:
"rkpatel215" rkpatel215
I am trying to load FinAnSu.xll in Excel 2010 through the options-add-ins box, but keep getting an error message saying:
FinAnSu.xll is not a valid add-in
I have downloaded the latest files. Is this add-in compatible with this version of Excel, or does anyone have any idea what is wrong?
Thanks in advance,
Rishi
FinAnSu.xll is not a valid add-in
I have downloaded the latest files. Is this add-in compatible with this version of Excel, or does anyone have any idea what is wrong?
Thanks in advance,
Rishi
Thu Apr 25, 2013 8:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
FinAnSu.xll is not part of the SMF add-in. But, yes, the SMF add-in is
compatible with EXCEL 2010.
On Thu, Apr 25, 2013 at 7:53 AM, rkpatel215 <rishinyc@gmail.com > wrote:
> I am trying to load FinAnSu.xll in Excel 2010 through the options-add-ins
> box, but keep getting an error message saying:
>
> FinAnSu.xll is not a valid add-in
>
> I have downloaded the latest files. Is this add-in compatible with this
> version of Excel, or does anyone have any idea what is wrong?
>
compatible with EXCEL 2010.
On Thu, Apr 25, 2013 at 7:53 AM, rkpatel215 <rishinyc@gmail.
> I am trying to load FinAnSu.xll in Excel 2010 through the options-add-
> box, but keep getting an error message saying:
>
> FinAnSu.xll is not a valid add-in
>
> I have downloaded the latest files. Is this add-in compatible with this
> version of Excel, or does anyone have any idea what is wrong?
>
Thu Apr 25, 2013 11:31 am (PDT) . Posted by:
"rkpatel215" rkpatel215
Apologies, I posted to the wrong forum.
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> FinAnSu.xll is not part of the SMF add-in. But, yes, the SMF add-in is
> compatible with EXCEL 2010.
>
> On Thu, Apr 25, 2013 at 7:53 AM, rkpatel215 <rishinyc@...> wrote:
>
> > I am trying to load FinAnSu.xll in Excel 2010 through the options-add-ins
> > box, but keep getting an error message saying:
> >
> > FinAnSu.xll is not a valid add-in
> >
> > I have downloaded the latest files. Is this add-in compatible with this
> > version of Excel, or does anyone have any idea what is wrong?
> >
>
--- In smf_addin@yahoogrou
>
> FinAnSu.xll is not part of the SMF add-in. But, yes, the SMF add-in is
> compatible with EXCEL 2010.
>
> On Thu, Apr 25, 2013 at 7:53 AM, rkpatel215 <rishinyc@
>
> > I am trying to load FinAnSu.xll in Excel 2010 through the options-add-
> > box, but keep getting an error message saying:
> >
> > FinAnSu.xll is not a valid add-in
> >
> > I have downloaded the latest files. Is this add-in compatible with this
> > version of Excel, or does anyone have any idea what is wrong?
> >
>
Thu Apr 25, 2013 11:31 am (PDT) . Posted by:
"Raju A" raju_14342
hai this is raju
from india
i am very happy to join in this group,
i am new to use excel
plz help me
how to use this group ?
i want to learn vwap,cumulative voume ,cumulative open interset in excel
any knowledge material about vwap
tnk you
from india
i am very happy to join in this group,
i am new to use excel
plz help me
how to use this group ?
i want to learn vwap,cumulative voume ,cumulative open interset in excel
any knowledge material about vwap
tnk you
Thu Apr 25, 2013 11:33 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you are new to EXCEL, using the add-in is probably not going to be
something you want to attempt. You should spend some time learning EXCEL
first. Among the more difficult tasks for most is the use of array-entered
functions and the need for string concatenations.
On Thu, Apr 25, 2013 at 11:13 AM, Raju A <raju_14342@yahoo.com > wrote:
>
> hai this is raju
> from india
> i am very happy to join in this group,
>
> i am new to use excel
> plz help me
>
> how to use this group ?
> i want to learn vwap,cumulative voume ,cumulative open interset in excel
>
> any knowledge material about vwap
>
>
something you want to attempt. You should spend some time learning EXCEL
first. Among the more difficult tasks for most is the use of array-entered
functions and the need for string concatenations.
On Thu, Apr 25, 2013 at 11:13 AM, Raju A <raju_14342@yahoo.
>
> hai this is raju
> from india
> i am very happy to join in this group,
>
> i am new to use excel
> plz help me
>
> how to use this group ?
> i want to learn vwap,cumulative voume ,cumulative open interset in excel
>
> any knowledge material about vwap
>
>
Thu Apr 25, 2013 9:13 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy,
do you have any codes to extract data from this webpage,
http://data.worldbank.org/indicator/CM.MKT.LCAP.CD
thanks
do you have any codes to extract data from this webpage,
http://data.
thanks
Fri Apr 26, 2013 1:01 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
No element numbers. But the data is easily extracted with RCHGetHTMLTable():
*Web Page:* http://data.worldbank.org/indicator/CM.MKT.LCAP.CD *Begin
String:* Country Name *Begin Direction:* -1 *End String:*
*End Direction:* 1
On Thu, Apr 25, 2013 at 9:13 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> do you have any codes to extract data from this webpage,
>
> http://data.worldbank.org/indicator/CM.MKT.LCAP.CD
>
>
*Web Page:* http://data.
String:* Country Name *Begin Direction:* -1 *End String:*
*End Direction:* 1
On Thu, Apr 25, 2013 at 9:13 PM, weekeewawa <weekeewawa@yahoo.
>
> do you have any codes to extract data from this webpage,
>
> http://data.
>
>
Thu Apr 25, 2013 11:40 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy, while extracting 4-traders data for this webpage
http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/quotes/
Session exchange 902 246 866$
Avg. Exchange 20 sessions 979 378 017$
shows a #VALUE error
the code which i put is
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&C2&"/quotes/",1,"Session exchange")," ","")
=0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&C2&"/quotes/",1,"Avg. Exchange 20 sessions")," ","")
any solution to that?
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> On Sun, Apr 14, 2013 at 3:56 AM, weekeewawa <weekeewawa@...> wrote:
>
> > 1) is it possible to extract news from http://finviz.com/news.ashx?
> > tried
> > =RCHGetHTMLTable("http://finviz.com/news.ashx ",">News",1,"",1) but
> > completely blank and so on for other permutations
> >
> > any codes for it?
> >
>
> Possible, but extremely tedious. It's tables within tables within tables.
> So you'd have to determine their coding pattern for the web page before
> decided how to extract each bit.
>
>
> > 2) is it even remotely possible that for news extraction such as
> > =smfGetTagContent("
> > http://www.reuters.com/finance/stocks/companyNews?symbol= "&$A$1,"a",1,"select
> > another date") where A1 points to for example IBM in which the headlines is
> > actually a hyperlink which links me to the news article?
> >
>
> Not quite sure what you're asking? Is it this:
>
> =HYPERLINK("http://www.reuters.com/ "&smfStrExtr(smfGetTagContent("
> http://www.reuters.com/finance/stocks/companyNews?symbol= "&$A$1,"h2",1,"select
> another date"),"""",""""),smfGetTagContent("
> http://www.reuters.com/finance/stocks/companyNews?symbol= "&$A$1,"a",1,"select
> another date"))
>
http://www.4-
Session exchange 902 246 866$
Avg. Exchange 20 sessions 979 378 017$
shows a #VALUE error
the code which i put is
=0+SUBSTITUTE(
=0+SUBSTITUTE(
any solution to that?
--- In smf_addin@yahoogrou
>
> On Sun, Apr 14, 2013 at 3:56 AM, weekeewawa <weekeewawa@
>
> > 1) is it possible to extract news from http://finviz.
> > tried
> > =RCHGetHTMLTable(
> > completely blank and so on for other permutations
> >
> > any codes for it?
> >
>
> Possible, but extremely tedious. It's tables within tables within tables.
> So you'd have to determine their coding pattern for the web page before
> decided how to extract each bit.
>
>
> > 2) is it even remotely possible that for news extraction such as
> > =smfGetTagContent(
> > http://www.reuters.
> > another date") where A1 points to for example IBM in which the headlines is
> > actually a hyperlink which links me to the news article?
> >
>
> Not quite sure what you're asking? Is it this:
>
> =HYPERLINK("http://www.reuters.
> http://www.reuters.
> another date"),
> http://www.reuters.
> another date"))
>
Fri Apr 26, 2013 1:07 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Get rid of the trailing dollar sign from what you retrieve...
Just drop the "0+" from the formula, and you'll see what gets returned. If
it's not numeric, you'll get a #VALUE! error when you try to add 0 to it.
Or, you can use the smfConvertData() function instead of adding 0 to
convert it to numeric:
=smfConvertData(SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/
"&C2&"/quotes/",
1,"Session exchange")," ",""))
On Thu, Apr 25, 2013 at 11:40 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
> hello randy, while extracting 4-traders data for this webpage
>
> http://www.4-traders.com/INTERNATIONAL-BUSINESS-MA-4828/quotes/
>
> Session exchange 902 246 866$
> Avg. Exchange 20 sessions 979 378 017$
>
> shows a #VALUE error
> the code which i put is
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&C2&"/quotes/",1,"Session
> exchange")," ","")
>
>
> =0+SUBSTITUTE(RCHGetTableCell("http://www.4-traders.com/ "&C2&"/quotes/",1,"Avg.
> Exchange 20 sessions")," ","")
>
> any solution to that?
>
Just drop the "0+" from the formula, and you'll see what gets returned. If
it's not numeric, you'll get a #VALUE! error when you try to add 0 to it.
Or, you can use the smfConvertData(
convert it to numeric:
=smfConvertData(
"&C2&
1,"Session exchange"
On Thu, Apr 25, 2013 at 11:40 PM, weekeewawa <weekeewawa@yahoo.
> hello randy, while extracting 4-traders data for this webpage
>
> http://www.4-
>
> Session exchange 902 246 866$
> Avg. Exchange 20 sessions 979 378 017$
>
> shows a #VALUE error
> the code which i put is
>
> =0+SUBSTITUTE(
> exchange"
>
>
> =0+SUBSTITUTE(
> Exchange 20 sessions"
>
> any solution to that?
>
Tidak ada komentar:
Posting Komentar