Jumat, 26 April 2013

[smf_addin] Digest Number 2595

11 New Messages

Digest #2595
2b
3a
hai by "Raju A" raju_14342
3b
Re: hai by "Randy Harmelink" rharmelink
4a
extracting data from world bank by "weekeewawa" weekeewawa
4b
Re: extracting data from world bank by "Randy Harmelink" rharmelink
6
(no subject) by commakazi1

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?
> >
>

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

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?
>

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?
> >
>

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

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
>
>

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

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
>
>

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"))
>

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?
>

Tidak ada komentar:

Posting Komentar