Jumat, 15 Maret 2013

[smf_addin] Digest Number 2547

15 New Messages

Digest #2547
1a
Re: Guru spreadsheet no longer works by "Randy Harmelink" rharmelink
3.1
Re: RCHGetWebData by "iamruf" iamruf
3.2
Re: RCHGetWebData by "Randy Harmelink" rharmelink
3.3
Re: RCHGetWebData by "iamruf" iamruf
3.4
Re: RCHGetWebData by "Randy Harmelink" rharmelink

Messages

Fri Mar 15, 2013 3:01 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I can't even open the gurufocus web site with IE, so I can't be of much
help.

With FireFox, I did need to log in to get to one of the URLs you use:

http://www.gurufocus.com/holdings.php?GuruName=AndreasHalvorsen&sort=position&p=4&ind=120

But I need to click on a link from that page to get the actual holdings.

On Fri, Mar 15, 2013 at 2:47 PM, Brett <bpeven@yahoo.com> wrote:

> I can't figure out how to get this spreadsheet that extracts holdings from
> Gurufocus.com to work anymore.
>
>
> http://f1.grp.yahoofs.com/v1/mJZDUY1U4DJcWV6hKhlL4U_S91uIJZloQ2HYOO7s7Pq6rC54Ez9rePBfKPd-ZU3xgraSEJ5SyFgZSuYVYjX1PME4cpkT/Uploads%20by%20forum%20members/Guru%20Industry%20Report.xls
>

Fri Mar 15, 2013 3:08 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Unfortunately, that gets me back to the same problem as using element 811-813.


=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"Moving Average/Vol","100 Day Trend")

This returns an "Error" value in the cell.

Do you see anything wrong with the way I have it coded?


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, March 15, 2013 5:51 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Geeting invalid results for some symbols usingStockScores


As is, your "100-day trend" string will grab the 100-day trend from the "volume/momentum" tab instead of the "moving average/volatility&quot; tab.

That's why I use "moving average/vol" as my first search string, to position me on the proper tab.
On Fri, Mar 15, 2013 at 2:29 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

I am sure the problem is me but I can't figure out why it is failing on some symbols and working on most.
I'm hoping you can spot my error
Using only these 4 symbols 2 return misinformation


Symbol
Price Indicator -- 15 Day Trend
Price Indicator -- 45 Day Trend
Price Indicator -- 100 Day Trend


win
bullish
bearish
bullish
red cells should be bearish not bullish.

ibm
bullish
bullish
bullish


AMTG
bearish
bullish
bullish


agnc
bullish
bullish
bullish


Column "B" contains =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"15 Day Trend","images&quot;)
Column "C" contains =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"45 Day Trend","images&quot;)
Column "D" contains =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"100 Day Trend","images&quot;)

I am using this method to pull the information because elements 811 -813 still do not work on my desktop or laptop.


Fri Mar 15, 2013 3:18 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

I tried changing the "0" after the "td" in the =smfgettagcontent to 1,2,3,4 and all got errors.

I noticed in the smfgetaparm you use a 1.

From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Kermit W. Prather
Sent: Friday, March 15, 2013 6:08 PM
To: smf_addin@yahoogroups.com
Subject: RE: [smf_addin] Geeting invalid results for some symbols usingStockScores


Unfortunately, that gets me back to the same problem as using element 811-813.


=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"Moving Average/Vol","100 Day Trend")

This returns an "Error" value in the cell.

Do you see anything wrong with the way I have it coded?


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, March 15, 2013 5:51 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Geeting invalid results for some symbols usingStockScores


As is, your "100-day trend" string will grab the 100-day trend from the "volume/momentum" tab instead of the "moving average/volatility&quot; tab.

That's why I use "moving average/vol" as my first search string, to position me on the proper tab.
On Fri, Mar 15, 2013 at 2:29 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:

I am sure the problem is me but I can't figure out why it is failing on some symbols and working on most.
I'm hoping you can spot my error
Using only these 4 symbols 2 return misinformation


Symbol
Price Indicator -- 15 Day Trend
Price Indicator -- 45 Day Trend
Price Indicator -- 100 Day Trend


win
bullish
bearish
bullish
red cells should be bearish not bullish.

ibm
bullish
bullish
bullish


AMTG
bearish
bullish
bullish


agnc
bullish
bullish
bullish


Column "B" contains =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"15 Day Trend","images&quot;)
Column "C" contains =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"45 Day Trend","images&quot;)
Column "D" contains =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"100 Day Trend","images&quot;)

I am using this method to pull the information because elements 811 -813 still do not work on my desktop or laptop.


Fri Mar 15, 2013 3:27 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

As I said, 811-813 work fine for me. I don't know why your web page labels
are different than me.

So this works fine for me:

=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",1,"Moving
Average/Vol","100 Day Trend")

An alternative is to search for the second "100 Day Trend" string, as in:

=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"100
Day Trend","100 Day Trend","images&quot;)

...or to use the section header instead:

=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker="&A2,1,"Moving
Average Indictors","100 Day Trend")

...although it worries me they have "Indicators&quot; spelled wrong. It could
stop working if they fix that error.

On Fri, Mar 15, 2013 at 3:08 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

> Unfortunately, that gets me back to the same problem as using element
> 811-813.****
>
> ** **
>
> =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"Moving
> Average/Vol","100 Day Trend")****
>
> ** **
>
> This returns an "Error" value in the cell. ****
>
> ** **
>
> Do you see anything wrong with the way I have it coded?
>

Fri Mar 15, 2013 3:41 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

Thanks, I tried each and here are the results. Don't understand why the first one gets Error results. It fails on my laptop and desktop


The 2nd and 3rd work so I'll go with the 2nd one.

Thanks,
Kermit



=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",1,"Moving Average/Vol","100 Day Trend")
Error <http://www.stockscores.com/quickreport.asp?ticker=>
An alternative is to search for the second "100 Day Trend" string, as in:

=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"100 Day Trend","100 Day Trend","images&quot;)
bearish <http://www.stockscores.com/quickreport.asp?ticker=>
...or to use the section header instead:

=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker="&A2,1,"Moving Average Indictors","100 Day Trend")
bearish <http://www.stockscores.com/quickreport.asp?ticker=>




From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, March 15, 2013 6:27 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Geeting invalid results for some symbols usingStockScores


As I said, 811-813 work fine for me. I don't know why your web page labels are different than me.

So this works fine for me:

=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",1,"Moving Average/Vol","100 Day Trend")

An alternative is to search for the second "100 Day Trend" string, as in:

=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"100 Day Trend","100 Day Trend","images&quot;)

...or to use the section header instead:

=RCHGetTableCell("http://www.stockscores.com/quickreport.asp?ticker="&A2,1,"Moving Average Indictors","100 Day Trend")

...although it worries me they have "Indicators&quot; spelled wrong. It could stop working if they fix that error.
On Fri, Mar 15, 2013 at 3:08 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
Unfortunately, that gets me back to the same problem as using element 811-813.

=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",0,"Moving Average/Vol","100 Day Trend")

This returns an "Error" value in the cell.

Do you see anything wrong with the way I have it coded?

Fri Mar 15, 2013 3:48 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

Because you told me your web page doesn't have a "Moving Average/Vol"
string on it.

So, without that search string, you'll always get "Error" returned.

Why you get different web page content is beyond me. Maybe it has to do
with the version of IE. I have an old version (IE7), because I don't use it
as a browser.

On Fri, Mar 15, 2013 at 3:41 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

> Thanks, I tried each and here are the results. Don't understand why the
> first one gets Error results. It fails on my laptop and desktop****
>
> ** **
>
> =smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",1,"Moving
> Average/Vol","100 Day Trend")
> *Error <http://www.stockscores.com/quickreport.asp?ticker=>*
>
>
>
>

Fri Mar 15, 2013 4:38 pm (PDT) . Posted by:

"Kermit W. Prather" kermitpra

That is true it does not have "Moving Average/Vol"

It has >mov. avg<br>/Volatility<

That is also what displays on the webpage.

Could it be that I am retrieving webpage form a different server?


From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com] On Behalf Of Randy Harmelink
Sent: Friday, March 15, 2013 6:48 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Geeting invalid results for some symbols usingStockScores


Because you told me your web page doesn't have a "Moving Average/Vol" string on it.

So, without that search string, you'll always get "Error" returned.

Why you get different web page content is beyond me. Maybe it has to do with the version of IE. I have an old version (IE7), because I don't use it as a browser.
On Fri, Mar 15, 2013 at 3:41 PM, Kermit W. Prather <kermitp@tampabay.rr.com> wrote:
Thanks, I tried each and here are the results. Don't understand why the first one gets Error results. It fails on my laptop and desktop


=smfGetTagContent("http://www.stockscores.com/quickreport.asp?ticker="&A2,"td",1,"Moving Average/Vol","100 Day Trend")
Error <http://www.stockscores.com/quickreport.asp?ticker=>




Fri Mar 15, 2013 5:43 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

It's possible, but then you would have to be consistently getting data from
one server, and I would consistently be getting data from another server. I
suppose if different regions had a different set of servers, and each
region had a different set of software serving up the web pages...

Do you have FireFox? What do you see as the label there?

On Fri, Mar 15, 2013 at 4:38 PM, Kermit W. Prather
<kermitp@tampabay.rr.com>wrote:

>
> That is true it does not have "Moving Average/Vol"****
>
> ** **
>
> It has >mov. avg<br>/Volatility<****
>
> ** **
>
> That is also what displays on the webpage. ****
>
> ** **
>
> Could it be that I am retrieving webpage form a different server?
>

Fri Mar 15, 2013 3:39 pm (PDT) . Posted by:

"iamruf" iamruf

Hi Randy,
The following is the info/content of our message exchanged on Jan 18.
Will this help?

The RCHGetWebData() is just returning this JavaScript data:

( { "copyright&quot;:"Copyright (c) 2013 QuoteMedia, Inc.", "symbolcount&quot;:1, "quotedata&quot;:[ { "symbol":"AGF2107&quot;, "datatype";:"mutual fund", "entitlement&quot;:"EOD", "delaymin";:null, "datetime";:"2013-01-17T20:00:00-05:00", "pricedata&quot;:{ "last":"15.81", "change":"0.11", "changepercent":"0.700637", "sharevolume&quot;:"0" } } ] } );

So items out of that can be extracted.

But I don't see any of the additional items you mention shown there, and if I remember correctly, the main page was dynamically displayed, so the data couldn't be extracted there either.

If the data you want is available elsewhere, I'm not aware of it.

Hmmm. Took another look. Raw data appears to be here:

http://app.quotemedia.com/quotetools/fundataModule.go?overviewChartLink=off&ents=wmonly&showCommas=true&toolWidth=740&webmasterId=101020&chgrd=D8DCE5&;chbdr=D8DCE5&amp;chfill2=6d9641&chfill=cc6d9641&amp;chln=313942&chaaon=true&cp=off&symbol=AGF2107&amp;hiddenTabs=topnav&action=showDetailedQuote&targetURL=http://tmx.quotemedia.com/funds-ca-quote.php&locale=en

...so you could extract it from there. For example, if that URL is in cell C2:

=smfGetTagContent($C$2,"div",1,"Type:")
=0+smfGetTagContent($C$2,"div",1,"High:")

On Fri, Jan 18, 2013 at 8:23 AM, iamruf <iamruf@yahoo.com> wrote:
Hi Randy,
The formula at the bottom is getting prices although I don`t understand how it works.
Is it possible to adapt the formula to get other data on this page.
Fund Type: Global Equity
52 Week High: 16.05
52 Week Low: 14.34
YTD Return (as of December 31, 2012): 11.69%
Load Type: Choice of Front or Back
MER: 2.94%
Eligiblity: RRSP
Who Should Invest
Consider this Fund if: the tax consequences of a mutual fund corporation are more suitable to your investment program or that of your registered plan; you want the growth potential of equity securities of foreign companies; you're investing for the longer term; you tolerate medium risk; with respect to Series T and Series V securities, you prefer monthly distribution of capital.(This is a box varies in length)

=RCHGetWebData("http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba\ck=jsonp1358089488792&symbols=AGF2107&amp;webmasterId=101020&_=1358089550952&quot;,1,1000)

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Apparently. I no longer have the info on what you were trying to extract,
> and from where.
>
> On Fri, Mar 15, 2013 at 9:19 AM, iamruf <iamruf@...> wrote:
>
> >
> > Yes, you found these two URL's for me back on Jan 18 (working then).
> > Have they been changed?
> >
>

Fri Mar 15, 2013 3:45 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

None of those URLs are valid any more.

Have you gone back to the original web page URL to see if you can still
view the data?

On Fri, Mar 15, 2013 at 3:39 PM, iamruf <iamruf@yahoo.com> wrote:

> Hi Randy,
> The following is the info/content of our message exchanged on Jan 18.
> Will this help?
>
> The RCHGetWebData() is just returning this JavaScript data:
>
> ( { "copyright&quot;:"Copyright (c) 2013 QuoteMedia, Inc.", "symbolcount&quot;:1,
> "quotedata&quot;:[ { "symbol":"AGF2107&quot;, "datatype";:"mutual fund",
> "entitlement&quot;:"EOD", "delaymin";:null,
> "datetime";:"2013-01-17T20:00:00-05:00", "pricedata&quot;:{ "last":"15.81",
> "change":"0.11", "changepercent":"0.700637", "sharevolume&quot;:"0" } } ] } );
>
> So items out of that can be extracted.
>
> But I don't see any of the additional items you mention shown there, and
> if I remember correctly, the main page was dynamically displayed, so the
> data couldn't be extracted there either.
>
> If the data you want is available elsewhere, I'm not aware of it.
>
> Hmmm. Took another look. Raw data appears to be here:
>
>
> http://app.quotemedia.com/quotetools/fundataModule.go?overviewChartLink=off&ents=wmonly&showCommas=true&toolWidth=740&webmasterId=101020&chgrd=D8DCE5&;chbdr=D8DCE5&amp;chfill2=6d9641&chfill=cc6d9641&amp;chln=313942&chaaon=true&cp=off&symbol=AGF2107&amp;hiddenTabs=topnav&action=showDetailedQuote&targetURL=http://tmx.quotemedia.com/funds-ca-quote.php&locale=en
>
> ...so you could extract it from there. For example, if that URL is in cell
> C2:
>
> =smfGetTagContent($C$2,"div",1,"Type:")
> =0+smfGetTagContent($C$2,"div",1,"High:")
>
> On Fri, Jan 18, 2013 at 8:23 AM, iamruf <iamruf@yahoo.com> wrote:
> Hi Randy,
> The formula at the bottom is getting prices although I don`t understand
> how it works.
> Is it possible to adapt the formula to get other data on this page.
> Fund Type: Global Equity
> 52 Week High: 16.05
> 52 Week Low: 14.34
> YTD Return (as of December 31, 2012): 11.69%
> Load Type: Choice of Front or Back
> MER: 2.94%
> Eligiblity: RRSP
> Who Should Invest
> Consider this Fund if: the tax consequences of a mutual fund corporation
> are more suitable to your investment program or that of your registered
> plan; you want the growth potential of equity securities of foreign
> companies; you're investing for the longer term; you tolerate medium risk;
> with respect to Series T and Series V securities, you prefer monthly
> distribution of capital.(This is a box varies in length)
>
> =RCHGetWebData("
> http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba\ck=jsonp1358089488792&symbols=AGF2107&amp;webmasterId=101020&_=1358089550952
> ",1,1000)
>
> --- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
> >
> > Apparently. I no longer have the info on what you were trying to extract,
> > and from where.
> >
> > On Fri, Mar 15, 2013 at 9:19 AM, iamruf <iamruf@...> wrote:
> >
> > >
> > > Yes, you found these two URL's for me back on Jan 18 (working then).
> > > Have they been changed?
> > >
> >
>

Fri Mar 15, 2013 4:06 pm (PDT) . Posted by:

"iamruf" iamruf

Hi Randy,When I query the symbol BNS, this is the URL that appears.I
don't know how to get the other
one.http://web.tmxmoney.com/quote.php?qm_symbol=BNS

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...>
wrote:
>
> None of those URLs are valid any more.
>
> Have you gone back to the original web page URL to see if you can
still
> view the data?
>
> On Fri, Mar 15, 2013 at 3:39 PM, iamruf iamruf@... wrote:
>
> > Hi Randy,
> > The following is the info/content of our message exchanged on Jan
18.
> > Will this help?
> >
> > The RCHGetWebData() is just returning this JavaScript data:
> >
> > ( { "copyright&quot;:"Copyright (c) 2013 QuoteMedia, Inc.",
"symbolcount&quot;:1,
> > "quotedata&quot;:[ { "symbol":"AGF2107&quot;, "datatype";:"mutual fund",
> > "entitlement&quot;:"EOD", "delaymin";:null,
> > "datetime";:"2013-01-17T20:00:00-05:00", "pricedata&quot;:{
"last":"15.81",
> > "change":"0.11", "changepercent":"0.700637", "sharevolume&quot;:"0" } } ]
} );
> >
> > So items out of that can be extracted.
> >
> > But I don't see any of the additional items you mention shown there,
and
> > if I remember correctly, the main page was dynamically displayed, so
the
> > data couldn't be extracted there either.
> >
> > If the data you want is available elsewhere, I'm not aware of it.
> >
> > Hmmm. Took another look. Raw data appears to be here:
> >
> >
> >
http://app.quotemedia.com/quotetools/fundataModule.go?overviewChartLink=\
off&ents=wmonly&showCommas=true&toolWidth=740&webmasterId=101020&chgrd=D&#92;
8DCE5&chbdr=D8DCE5&chfill2=6d9641&amp;chfill=cc6d9641&chln=313942&chaaon=tru&#92;
e&cp=off&symbol=AGF2107&amp;hiddenTabs=topnav&action=showDetailedQuote&targe\
tURL=http://tmx.quotemedia.com/funds-ca-quote.php&locale=en

> >
> > ...so you could extract it from there. For example, if that URL is
in cell
> > C2:
> >
> > =smfGetTagContent($C$2,"div",1,"Type:")
> > =0+smfGetTagContent($C$2,"div",1,"High:")
> >
> > On Fri, Jan 18, 2013 at 8:23 AM, iamruf iamruf@... wrote:
> > Hi Randy,
> > The formula at the bottom is getting prices although I don`t
understand
> > how it works.
> > Is it possible to adapt the formula to get other data on this page.
> > Fund Type: Global Equity
> > 52 Week High: 16.05
> > 52 Week Low: 14.34
> > YTD Return (as of December 31, 2012): 11.69%
> > Load Type: Choice of Front or Back
> > MER: 2.94%
> > Eligiblity: RRSP
> > Who Should Invest
> > Consider this Fund if: the tax consequences of a mutual fund
corporation
> > are more suitable to your investment program or that of your
registered
> > plan; you want the growth potential of equity securities of foreign
> > companies; you're investing for the longer term; you tolerate medium
risk;
> > with respect to Series T and Series V securities, you prefer monthly
> > distribution of capital.(This is a box varies in length)
> >
> > =RCHGetWebData("
> >
http://tmx.quotemedia.com/json/getQuotesMini.json.php?jsoncallba\ck=json&#92;
p1358089488792&symbols=AGF2107&amp;webmasterId=101020&_=1358089550952
> > ",1,1000)
> >
> > --- In smf_addin@yahoogroups.com, Randy Harmelink rharmelink@ wrote:
> > >
> > > Apparently. I no longer have the info on what you were trying to
extract,
> > > and from where.
> > >
> > > On Fri, Mar 15, 2013 at 9:19 AM, iamruf iamruf@ wrote:
> > >
> > > >
> > > > Yes, you found these two URL's for me back on Jan 18 (working
then).
> > > > Have they been changed?
> > > >
> > >
> >
>

Fri Mar 15, 2013 4:23 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

So what's wrong with just using:

=RCHGetTableCell("http://web.tmxmoney.com/quote.php?qm_symbol=BNS
",1,">High:")

On Fri, Mar 15, 2013 at 4:06 PM, iamruf <iamruf@yahoo.com> wrote:

>
> *Hi Randy,*
> *When I query the symbol BNS, this is the URL that appears.*
> *I don't know how to get the other one.*
> *http://web.tmxmoney.com/quote.php?qm_symbol=BNS*
>

Fri Mar 15, 2013 6:59 pm (PDT) . Posted by:

"jsmetank74" jsmetank74



I have had success by setting up a Dropbox folder in the SMFAddin folder on two different machines. All my .xls and .xla files are in the Dropbox folder. This allows me to update my research sheets either on my laptop when I'm at the coffee shop or when I'm using my home computer. Good luck!

Fri Mar 15, 2013 8:53 pm (PDT) . Posted by:

"weekeewawa" weekeewawa

hi

in fact, the w command is to point to the ''weekly&#39;' extraction of period historical data

i would in fact like to extract datas based on my customization of daily, weekly, monthly and dividend data extraction based on period.

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> Unless w is a named range, it is what is causing your problem. Otherwise,
> It needs to be a string literal, with double quotes around it.
>
> Did you check the documentation on the function for those other parameters?
>
> To point to a cell, you do just like you would in any other function. Just
> use the cell reference in place of the literal.
>
> On Fri, Mar 15, 2013 at 10:14 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > when i was entering the formula below
> > =RCHGetYahooHistory("IBM",2007,1,3,2008,1,3,w,"DOHLCVA&quot;,0)
> >
> > i have encountered a #VALUE# error, is there any problem with it?
> >
> > also,
> >
> > in the formula, what should be input in the ''IBM&#39;' column to point it to
> > a specific cell, eg, Cell A1
> >
> > lastly, in the syntax,
> >
> > what exactly is [Header Line] and [Resort]
> >
>

Fri Mar 15, 2013 9:16 pm (PDT) . Posted by:

"weekeewawa" weekeewawa

hi, i have a few problems in extract data from certain yahoo sources

how do i extract the table data from

1) http://finance.yahoo.com/marketpulse/IBM

''Market Pulse for IBM'' and ''Trending Tickers on Market Pulse'&#39; tables?

2) http://biz.yahoo.com/ic/l/pip.html
''Leaders in Price Performance (Intraday)&#39;' and ''Laggards in Price Performance (Intraday)&#39;' data?

3) http://finance.yahoo.com/q/h?s=IBM+Headlines
where i can extract headlines data to the excel sheet

4) http://finance.yahoo.com/q/co?s=IBM+Competitors
where ''Computer Hardware (US) Ranked by Sales'&#39; table may vary depending on the industry such as for perhaps GM, it will show ''Auto (US) Ranked By Sales

and i would like to point the ticker to a specific cell A1 instead of IBM

thanks

Tidak ada komentar:

Posting Komentar