Sabtu, 18 Juni 2011

[smf_addin] Digest Number 1860

Messages In This Digest (14 Messages)

1a.
Re: Excel 2010 From: ospogrp
2a.
Error while retrieving ticker's name From: sancho_best
2b.
Re: Error while retrieving ticker's name From: Randy Harmelink
2c.
Re: Error while retrieving ticker's name From: sancho_best
2d.
Re: Error while retrieving ticker's name From: Randy Harmelink
2e.
Re: Error while retrieving ticker's name From: sancho_best
2f.
Re: Error while retrieving ticker's name From: Randy Harmelink
3.
Cash Conversion Cycle From: cardiaccharest
4a.
Net Income and Cash From: ermitesh
4b.
Re: Net Income and Cash From: Randy Harmelink
5.1.
Re: RCHGetYahooHistory, MA slope From: Jacob Jose
6a.
RCHGetWebData assistance From: pgh2377
6b.
Re: RCHGetWebData assistance From: Randy Harmelink
7.
Use of smf_addins cause excel to hang (i.e. not respond) From: E Spray

Messages

1a.

Re: Excel 2010

Posted by: "ospogrp" irrazu@gmail.com   ospogrp

Fri Jun 17, 2011 4:08 am (PDT)





--- In smf_addin@yahoogroups.com, Nolan Madson <nolanmadson@...> wrote:
>
> I've been one of the minority who have not been able to use the add-in with
> Excel 2010. Too bad, it seems like such a VERY useful tool.
>
> Nolan
>
Is it possible or is the very good smf_addin ·somewhat behind the curve.
It goes w/ out saying the smf_addin ·works extremely well on Excel 2007.
Have you tried EXCEL 2007 and Excel 2010 o n the same PC.?? O

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (12)
2a.

Error while retrieving ticker's name

Posted by: "sancho_best" sancho_best@yahoo.com   sancho_best

Fri Jun 17, 2011 7:44 am (PDT)



Hello guys!

Trying to get stock indexes data i encountered the problem: a ticker with long name doesn't show up in my spreadsheet. For instance, a ticker I:KOSPI200-2.KQ Yahoo provides the quote, however i get only N/A. I suppose that happens due to long ticker's name. How to override that issue? Any suggestions?

Thanks

Alex

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2b.

Re: Error while retrieving ticker's name

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jun 17, 2011 8:02 am (PDT)



N/A is a Yahoo value, so the add-in is just returning what Yahoo is
providing. A possible work-around:

=smfStrExtr(smfGetTagContent("http://finance.yahoo.com/q?s=I:KOSPI200-2.KQ","title",1),"Summary
for ", "- Yahoo")

On Fri, Jun 17, 2011 at 7:40 AM, sancho_best <sancho_best@yahoo.com> wrote:

>
> Trying to get stock indexes data i encountered the problem: a ticker with
> long name doesn't show up in my spreadsheet. For instance, a ticker
> I:KOSPI200-2.KQ Yahoo provides the quote, however i get only N/A. I suppose
> that happens due to long ticker's name. How to override that issue? Any
> suggestions?
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2c.

Re: Error while retrieving ticker's name

Posted by: "sancho_best" sancho_best@yahoo.com   sancho_best

Fri Jun 17, 2011 9:27 am (PDT)



Dear Randy!

But Yahoo provides the full quotation on the website. There are two tickers:
I-KOSPI-I.KQ and I-KOSPI200-2.KQ

Yahoo provides both tickers with full info on the website. However, using RCHGetYahooQuotes function, you get information in your spreadsheet only for the first ticker. I am pretty sure, this is the issue of the the function.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> N/A is a Yahoo value, so the add-in is just returning what Yahoo is
> providing. A possible work-around:
>
> =smfStrExtr(smfGetTagContent("http://finance.yahoo.com/q?s=I:KOSPI200-2.KQ","title",1),"Summary
> for ", "- Yahoo")
>
> On Fri, Jun 17, 2011 at 7:40 AM, sancho_best <sancho_best@...> wrote:
>
> >
> > Trying to get stock indexes data i encountered the problem: a ticker with
> > long name doesn't show up in my spreadsheet. For instance, a ticker
> > I:KOSPI200-2.KQ Yahoo provides the quote, however i get only N/A. I suppose
> > that happens due to long ticker's name. How to override that issue? Any
> > suggestions?
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2d.

Re: Error while retrieving ticker's name

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jun 17, 2011 9:32 am (PDT)



The RCHGetYahooQuotes() function can only return to you what Yahoo provides:

http://download.finance.yahoo.com/d/quotes.csv?s=I:KOSPI200-2.KQ&f=sl1d1t1c1ohgv&e=.csv

Yahoo may be providing full info on their web page, but they are not
providing it via their CSV interface -- which is the process from Yahoo that
the RCHGetYahooQuotes() function uses.

On Fri, Jun 17, 2011 at 9:27 AM, sancho_best <sancho_best@yahoo.com> wrote:

>
> But Yahoo provides the full quotation on the website. There are two
> tickers:
> I-KOSPI-I.KQ and I-KOSPI200-2.KQ
>
> Yahoo provides both tickers with full info on the website. However, using
> RCHGetYahooQuotes function, you get information in your spreadsheet only for
> the first ticker. I am pretty sure, this is the issue of the the function.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2e.

Re: Error while retrieving ticker's name

Posted by: "sancho_best" sancho_best@yahoo.com   sancho_best

Fri Jun 17, 2011 12:05 pm (PDT)



Randy!

It semms like we don't understand each other.

My point is if ticker's name has more than 12 symbols it doesn't show up in spreadsheet. I checked your last point. For instance, a ticker "IGPA-MID.SN" has 11 symbols and a ticker "IGPA-LARGE.SN" has already 13 symbols. As i see in the initial webpage code, Yahoo provides csv. interface for both tickers. But in Excel i get only ticker "IGPA-MID.SN". That where i don't understand what i have to do next.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The RCHGetYahooQuotes() function can only return to you what Yahoo provides:
>
> http://download.finance.yahoo.com/d/quotes.csv?s=I:KOSPI200-2.KQ&f=sl1d1t1c1ohgv&e=.csv
>
> Yahoo may be providing full info on their web page, but they are not
> providing it via their CSV interface -- which is the process from Yahoo that
> the RCHGetYahooQuotes() function uses.
>
> On Fri, Jun 17, 2011 at 9:27 AM, sancho_best <sancho_best@...> wrote:
>
> >
> > But Yahoo provides the full quotation on the website. There are two
> > tickers:
> > I-KOSPI-I.KQ and I-KOSPI200-2.KQ
> >
> > Yahoo provides both tickers with full info on the website. However, using
> > RCHGetYahooQuotes function, you get information in your spreadsheet only for
> > the first ticker. I am pretty sure, this is the issue of the the function.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
2f.

Re: Error while retrieving ticker's name

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jun 17, 2011 12:25 pm (PDT)



You'll need to upload an example. I'm getting exactly what I am expecting to
see when I use the RCHGetYahooQuotes() function -- it's returning what I am
seeing in the Yahoo CSV file. I'll grant that there is nothing of value
being returned for the IGPA-LARGE.SN symbol, but it *is* what I'm seeing
returned by Yahoo. That is:

s n l1 Symbol Name Last Price IGPA-LARGE.SN IGPA-LARGE.SN
IGPA-LARGE.SN 0 IGPA-MID.SN IGPA-MID.SN IGPA MID 18846.178
The blue-shaded area is what RCHGetYahooQuotes() is returning based on the
yellow-shaded parameters.

So, this URL:

http://download.finance.yahoo.com/d/quotes.csv?s=IGPA-LARGE.SN,IGPA-MID.SN&f=snl1&e=.csv

...is returning this CSV file:

"IGPA-LARGE.SN","IGPA-LARGE.SN",0.00
"IGPA-MID.SN","IGPA MID",18846.178

...which is what RCHGetYahooQuotes() is interpreting to return the table I
have above.

On Fri, Jun 17, 2011 at 12:05 PM, sancho_best <sancho_best@yahoo.com> wrote:

>
> It semms like we don't understand each other.
>
> My point is if ticker's name has more than 12 symbols it doesn't show up in
> spreadsheet. I checked your last point. For instance, a ticker "
> IGPA-MID.SN" has 11 symbols and a ticker "IGPA-LARGE.SN" has already 13
> symbols. As i see in the initial webpage code, Yahoo provides csv. interface
> for both tickers. But in Excel i get only ticker "IGPA-MID.SN". That where
> i don't understand what i have to do next.
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (6)
3.

Cash Conversion Cycle

Posted by: "cardiaccharest" cardiaccharest@gmail.com   cardiaccharest

Fri Jun 17, 2011 8:47 am (PDT)



has anyone created a template to compare the cash conversion cycle between related companies?

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
4a.

Net Income and Cash

Posted by: "ermitesh" ermitesh@yahoo.com   ermitesh

Fri Jun 17, 2011 11:59 am (PDT)



Dear Randy,

I am trying to search for the quarterly "Net Income" using RCHGetElementNumber() but couldn't find this. It is referred as a "NetIncome" on MSN web. Following page displays that.

http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?symbol=MMM&stmtView=Qtr

Also, I am lookign for "Cash and Short Term Investments", which you can find here

http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Balance&symbol=US%3aMMM&stmtView=Qtr

Let me know if there is any other better way to retrieve this information other than RCHGetElementNumber()

Thanks,

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
4b.

Re: Net Income and Cash

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jun 17, 2011 12:16 pm (PDT)



Check out this template in the files area:

RCHGetTableCell-Template-MSN-Financial-Statements.xls

...which uses the RCHGetTableCell() function.

On Fri, Jun 17, 2011 at 11:59 AM, ermitesh <ermitesh@yahoo.com> wrote:

>
> I am trying to search for the quarterly "Net Income" using
> RCHGetElementNumber() but couldn't find this. It is referred as a
> "NetIncome" on MSN web. Following page displays that.
>
>
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?symbol=MMM&stmtView=Qtr
>
> Also, I am lookign for "Cash and Short Term Investments", which you can
> find here
>
>
> http://moneycentral.msn.com/investor/invsub/results/statemnt.aspx?lstStatement=Balance&symbol=US%3aMMM&stmtView=Qtr
>
> Let me know if there is any other better way to retrieve this information
> other than RCHGetElementNumber()
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
5.1.

Re: RCHGetYahooHistory, MA slope

Posted by: "Jacob Jose" pepecan47@yahoo.ca   pepecan47

Fri Jun 17, 2011 12:36 pm (PDT)



Hi Dan - thank you very much for the suggestions. A question, how do you use MA
slope for buy/sell signals?
 Regards,
Jose L. Jacob

________________________________
From: Dan Lancaster <dansgonefishing@yahoo.com>
To: smf_addin@yahoogroups.com
Sent: Thu, June 16, 2011 2:36:42 PM
Subject: [smf_addin] Re: RCHGetYahooHistory, MA slope

 

I use MA slope for buy/sell signals. I agree with Randy. You should download the
price history with one RCHGetYahooHistory call then do all of your calculations
in the spreadsheet using OFFSET, AVERAGE and SLOPE. The download will be quicker
and you will have a lot more flexibility in your analysis calculations. For
example, the Excel functions allow cell references so you can set up driving
cells to vary the time period over which the average is calculated and the time
period over which the slope is calculated. Both had a big impact on the results
of my back testing of this method.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Not using the same method. There are times I would like to use the OFFSET()
> function to extract data from the function, but OFFSET() only accepts a
> range as input. However, INDEX() does allow either a range or an array as
> an input, so you could do it this way:
>
> =INDEX(smfTech(RCHGetYahooHistory("MMM",,,,,,,,,,1,1,100,6),"SMA",50),100)
> =INDEX(smfTech(RCHGetYahooHistory("MMM",,,,,,,,,,1,1,100,6),"SMA",50),99)
>
> The first gets you the current 50-day SMA. The second gets you the previous
> 50-day SMA.
>
> Another option would be to mathematically compute it. Today's 50-day SMA and
> yesterday's 50-day SMA have 49 common days that went into their calculation.
> So, really, you're just looking at the change between today's closing price
> and the the closing price from 51 days ago, and then dividing that
> difference by 50. So:
>
>=(RCHGetYahooHistory("MMM",,,,,,,,"A",0,,,1,1)-INDEX(RCHGetYahooHistory("MMM",,,,,,,,"A",0,,,51,1),51))/50
>0
>
> I would just drop the division by 50 and call it a 50-day rate-of-change.
>
> On Tue, Jun 14, 2011 at 5:31 PM, Jacob Jose <pepecan47@...> wrote:
>
> >
> > Randy, is there any way to get the last 51 days of data and do the
> > AVERAGE of day 2 to 51? I don't see how to automate my workbook if I have
> > to provide the dates hard coded.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (29)
6a.

RCHGetWebData assistance

Posted by: "pgh2377" pgh2377@yahoo.com   pgh2377

Fri Jun 17, 2011 1:14 pm (PDT)



I'm trying to get the Category off of the website www.cefconnect.com for symbol IGD and AWP;

I'm having trouble through the page source

align="left">Category:</td><td class="tabs">US Equity-Covered Call</td>

when I ask the string to start with "tabs"> it errors out because of the quotes, any suggestions?

This produces and error

=smfStrExtr(RCHGetWebData("http://www.cefconnect.com/Details/Summary.aspx?ticker="&$A4&"","Category:",75),"tabs">","<"")

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
6b.

Re: RCHGetWebData assistance

Posted by: "Randy Harmelink" rharmelink@gmail.com   rharmelink

Fri Jun 17, 2011 1:40 pm (PDT)



Whenever you have a double quote within a string, you need to double it up
so that EXCEL doesn't take it as the ending quote on the string. That is:

=smfStrExtr(RCHGetWebData("
http://www.cefconnect.com/Details/Summary.aspx?ticker="&$A4,"Category:",75),
"tabs"">",
"<")

I don't know how you ended up with the mess of double quotes you are using.
:)

You basically asked to evaluate if:

"tabs"

...is greater than:

","

...is less than:

""

...which evaluates to FALSE. So, lacking strings for the 2nd and 3rd
parameter of the smfStrExtr() function, you get a #VALUE! error as the
result.

On Fri, Jun 17, 2011 at 1:14 PM, pgh2377 <pgh2377@yahoo.com> wrote:

> I'm trying to get the Category off of the website www.cefconnect.com for
> symbol IGD and AWP;
>
> I'm having trouble through the page source
>
> align="left">Category:</td><td class="tabs">US Equity-Covered Call</td>
>
> when I ask the string to start with "tabs"> it errors out because of the
> quotes, any suggestions?
>
> This produces and error
>
> =smfStrExtr(RCHGetWebData("
> http://www.cefconnect.com/Details/Summary.aspx?ticker=
> "&$A4&"","Category:",75),"tabs">","<"")
>
Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (2)
7.

Use of smf_addins cause excel to hang (i.e. not respond)

Posted by: "E Spray" espray@optimum.net   espray

Fri Jun 17, 2011 7:24 pm (PDT)



Any suggestions on resolving this problem is greatly appreciated.

I've been using the smf_addins for over a year with no problems until today. I'm using IE8, Excel 2010, Windows 7 and the 2.1.2010.08.02 version of the addin. When opening a file or entering a formula by hand into an excel spreadsheet, the file begins to process the data query and immediately becomes hung (excel not responding).

The source websites are all operative and I'm sure it's not an excel issue. I suspect the problem is with a setting within IE8 somehow changing - but not sure what it could be.

I've verified the Internet Options / Settings / Miscellaneous / Access Data Sources Across Domains is set for "enabled" and restarted the computer. No success.

Any thoughts or hints on possible solutions would be appreciated.

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (1)
Recent Activity
Visit Your Group
Yahoo! Finance

It's Now Personal

Guides, news,

advice & more.

Search Ads

Get new customers.

List your web site

in Yahoo! Search.

Yahoo! News

Get it all here

Breaking news to

entertainment news

Need to Reply?

Click one of the "Reply" links to respond to a specific message in the Daily Digest.

Create New Topic | Visit Your Group on the Web
Diposting oleh EXCEL FEED LEARNING di 03.55

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)