14 New Messages
Digest #2516
1b
Re: Am I using a sledgehammer when a tack driver might be better? by "Randy Harmelink" rharmelink
1d
Re: Am I using a sledgehammer when a tack driver might be better? by "Randy Harmelink" rharmelink
1g
Re: Am I using a sledgehammer when a tack driver might be better? by "Randy Harmelink" rharmelink
3b
Re: Is it possible to reference stock symbol in =RCHGetElementNumber by "Randy Harmelink" rharmelink
Messages
Wed Feb 20, 2013 1:02 pm (PST) . Posted by:
"alexcomp1" alexcomp1
It used to be that there was a standard Excel add-in that would allow you to retrieve stock pricing data. I'm pretty sure that it went away so I stumbled upon this tool. It seems there may be several thousand "arguments" to retrieve a wealth of different statistics.
I might want to do that at some point in time but for now, all I would like to do is retrieve the bare minimum like "last trade" from Yahoo or MSN. Am I on the wrong track here or can this be done with the SMF addin? The way that the element definition spreadsheet is laid out seems somewhat inhospitable to a simple search.
I might want to do that at some point in time but for now, all I would like to do is retrieve the bare minimum like "last trade" from Yahoo or MSN. Am I on the wrong track here or can this be done with the SMF addin? The way that the element definition spreadsheet is laid out seems somewhat inhospitable to a simple search.
Wed Feb 20, 2013 1:06 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
You want the RCHGetYahooQuotes() function. For example, to get the last
price for IBM:
=RCHGetYahooQuotes("IBM","l1")
There are a large number of functions. Which one to use depends on what you
need to retrieve.
On Wed, Feb 20, 2013 at 2:00 PM, alexcomp1 sgg@alexcomp.com > wrote:
> It used to be that there was a standard Excel add-in that would allow you
> to retrieve stock pricing data. I'm pretty sure that it went away so I
> stumbled upon this tool. It seems there may be several thousand
> "arguments" to retrieve a wealth of different statistics.
>
> I might want to do that at some point in time but for now, all I would
> like to do is retrieve the bare minimum like "last trade" from Yahoo or
> MSN. Am I on the wrong track here or can this be done with the SMF addin?
> The way that the element definition spreadsheet is laid out seems somewhat
> inhospitable to a simple search.
>
price for IBM:
=RCHGetYahooQuotes(
There are a large number of functions. Which one to use depends on what you
need to retrieve.
On Wed, Feb 20, 2013 at 2:00 PM, alexcomp1 sgg@alexcomp.
> It used to be that there was a standard Excel add-in that would allow you
> to retrieve stock pricing data. I'm pretty sure that it went away so I
> stumbled upon this tool. It seems there may be several thousand
> "arguments&quo
>
> I might want to do that at some point in time but for now, all I would
> like to do is retrieve the bare minimum like "last trade" from Yahoo or
> MSN. Am I on the wrong track here or can this be done with the SMF addin?
> The way that the element definition spreadsheet is laid out seems somewhat
> inhospitable to a simple search.
>
Wed Feb 20, 2013 1:56 pm (PST) . Posted by:
"Steve Garrison" alexcomp1
That works but I'm still searching for a list of ALL the possible values to retrieve. I see that l1 is last trade but what about the other stuff like volume, open, high, bid, etc? There must be a list somewhere.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Wednesday, February 20, 2013 3:06 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Am I using a sledgehammer when a tack driver might be better?
You want the RCHGetYahooQuotes() function. For example, to get the last price for IBM:
=RCHGetYahooQuotes("IBM","l1")
There are a large number of functions. Which one to use depends on what you need to retrieve.
On Wed, Feb 20, 2013 at 2:00 PM, alexcomp1 sgg@alexcomp.com > wrote:
It used to be that there was a standard Excel add-in that would allow you to retrieve stock pricing data. I'm pretty sure that it went away so I stumbled upon this tool. It seems there may be several thousand "arguments" to retrieve a wealth of different statistics.
I might want to do that at some point in time but for now, all I would like to do is retrieve the bare minimum like "last trade" from Yahoo or MSN. Am I on the wrong track here or can this be done with the SMF addin? The way that the element definition spreadsheet is laid out seems somewhat inhospitable to a simple search.
From: smf_addin@yahoogrou
Sent: Wednesday, February 20, 2013 3:06 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Am I using a sledgehammer when a tack driver might be better?
You want the RCHGetYahooQuotes(
=RCHGetYahooQuotes(
There are a large number of functions. Which one to use depends on what you need to retrieve.
On Wed, Feb 20, 2013 at 2:00 PM, alexcomp1 sgg@alexcomp.
It used to be that there was a standard Excel add-in that would allow you to retrieve stock pricing data. I'm pretty sure that it went away so I stumbled upon this tool. It seems there may be several thousand "arguments&quo
I might want to do that at some point in time but for now, all I would like to do is retrieve the bare minimum like "last trade" from Yahoo or MSN. Am I on the wrong track here or can this be done with the SMF addin? The way that the element definition spreadsheet is laid out seems somewhat inhospitable to a simple search.
Wed Feb 20, 2013 1:57 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Take a look in the "Documentation" folder of the FILES area. All of the
documentation for the various functions is there.
On Wed, Feb 20, 2013 at 2:56 PM, Steve Garrison sgg@alexcomp.com > wrote:
>
> That works but I'm still searching for a list of ALL the possible values
> to retrieve. I see that l1 is last trade but what about the other stuff
> like volume, open, high, bid, etc? There must be a list somewhere.
>
documentation for the various functions is there.
On Wed, Feb 20, 2013 at 2:56 PM, Steve Garrison sgg@alexcomp.
>
> That works but I'm still searching for a list of ALL the possible values
> to retrieve. I see that l1 is last trade but what about the other stuff
> like volume, open, high, bid, etc? There must be a list somewhere.
>
Wed Feb 20, 2013 2:05 pm (PST) . Posted by:
"Steve Garrison" alexcomp1
Got it. Sorry I wasn't more thorough in reading the documentation. I'm assuming there's no place to get real-time data with these functions. I might ask my Etrade rep if there's any possibility of querying their server.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf Of Randy Harmelink
Sent: Wednesday, February 20, 2013 3:58 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Am I using a sledgehammer when a tack driver might be better?
Take a look in the "Documentation" folder of the FILES area. All of the documentation for the various functions is there.
On Wed, Feb 20, 2013 at 2:56 PM, Steve Garrison sgg@alexcomp.com > wrote:
That works but I'm still searching for a list of ALL the possible values to retrieve. I see that l1 is last trade but what about the other stuff like volume, open, high, bid, etc? There must be a list somewhere.
From: smf_addin@yahoogrou
Sent: Wednesday, February 20, 2013 3:58 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Am I using a sledgehammer when a tack driver might be better?
Take a look in the "Documentation
On Wed, Feb 20, 2013 at 2:56 PM, Steve Garrison sgg@alexcomp.
That works but I'm still searching for a list of ALL the possible values to retrieve. I see that l1 is last trade but what about the other stuff like volume, open, high, bid, etc? There must be a list somewhere.
Wed Feb 20, 2013 2:16 pm (PST) . Posted by:
"Taral Pandya" taral_26
Hey Steve,
I have looked into querying from e-trade. They don't support this kind of
querying. You have to call their API and then store the json sent back in a
db and then extract it to excel. Very time consuming.
Sent from my iPhone
On Feb 20, 2013, at 5:06 PM, Steve Garrison sgg@alexcomp.com > wrote:
Got it. Sorry I wasn�t more thorough in reading the documentation. I�m
assuming there�s no place to get real-time data with these functions. I
might ask my Etrade rep if there�s any possibility of querying their server.
*From:* smf_addin@yahoogroups.com
[mailto:smf_addin@yahoogroups.com smf_addin@yahoogroups.com >]
*On Behalf Of *Randy Harmelink
*Sent:* Wednesday, February 20, 2013 3:58 PM
*To:* smf_addin@yahoogroups.com
*Subject:* Re: [smf_addin] Am I using a sledgehammer when a tack driver
might be better?
Take a look in the "Documentation" folder of the FILES area. All of the
documentation for the various functions is there.
On Wed, Feb 20, 2013 at 2:56 PM, Steve Garrison sgg@alexcomp.com > wrote:
That works but I�m still searching for a list of ALL the possible values to
retrieve. I see that l1 is last trade but what about the other stuff like
volume, open, high, bid, etc? There must be a list somewhere.
I have looked into querying from e-trade. They don't support this kind of
querying. You have to call their API and then store the json sent back in a
db and then extract it to excel. Very time consuming.
Sent from my iPhone
On Feb 20, 2013, at 5:06 PM, Steve Garrison sgg@alexcomp.
Got it. Sorry I wasn�t more thorough in reading the documentation. I�m
assuming there�s no place to get real-time data with these functions. I
might ask my Etrade rep if there�s any possibility of querying their server.
*From:* smf_addin@yahoogrou
[mailto:smf_addin@yahoogrou
*On Behalf Of *Randy Harmelink
*Sent:* Wednesday, February 20, 2013 3:58 PM
*To:* smf_addin@yahoogrou
*Subject:* Re: [smf_addin] Am I using a sledgehammer when a tack driver
might be better?
Take a look in the "Documentation
documentation for the various functions is there.
On Wed, Feb 20, 2013 at 2:56 PM, Steve Garrison sgg@alexcomp.
That works but I�m still searching for a list of ALL the possible values to
retrieve. I see that l1 is last trade but what about the other stuff like
volume, open, high, bid, etc? There must be a list somewhere.
Wed Feb 20, 2013 3:14 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
It's my understanding that the data returned by RCHGetYahooQuotes() can
return real-time quotes if you are signed up for them on Yahoo and logged
into IE so that the proper security cookie exists.
Otherwise, you can get real-time quotes using the add-in, but only one web
page at a time, so the process isn't good if you want to get a lot of
quotes.
On Wed, Feb 20, 2013 at 3:05 PM, Steve Garrison sgg@alexcomp.com > wrote:
>
> Got it. Sorry I wasn't more thorough in reading the documentation. I'm
> assuming there's no place to get real-time data with these functions. I
> might ask my Etrade rep if there's any possibility of querying their server.
>
return real-time quotes if you are signed up for them on Yahoo and logged
into IE so that the proper security cookie exists.
Otherwise, you can get real-time quotes using the add-in, but only one web
page at a time, so the process isn't good if you want to get a lot of
quotes.
On Wed, Feb 20, 2013 at 3:05 PM, Steve Garrison sgg@alexcomp.
>
> Got it. Sorry I wasn't more thorough in reading the documentation. I'm
> assuming there's no place to get real-time data with these functions. I
> might ask my Etrade rep if there's any possibility of querying their server.
>
Wed Feb 20, 2013 4:45 pm (PST) . Posted by:
"Steve Garrison" alexcomp1
I can extract a cvs file from Etrade Pro and get data that way but, as you
say, time consuming and clumsy.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Taral Pandya
Sent: Wednesday, February 20, 2013 4:10 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Am I using a sledgehammer when a tack driver might
be better?
Hey Steve,
I have looked into querying from e-trade. They don't support this kind of
querying. You have to call their API and then store the json sent back in a
db and then extract it to excel. Very time consuming.
Sent from my iPhone
On Feb 20, 2013, at 5:06 PM, Steve Garrison sgg@alexcomp.com > wrote:
Got it. Sorry I wasn't more thorough in reading the documentation. I'm
assuming there's no place to get real-time data with these functions. I
might ask my Etrade rep if there's any possibility of querying their server.
From: smf_addin@yahoogroups.com [mailto:smf_addin@yahoogroups.com ] On Behalf
Of Randy Harmelink
Sent: Wednesday, February 20, 2013 3:58 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Am I using a sledgehammer when a tack driver might
be better?
Take a look in the "Documentation" folder of the FILES area. All of the
documentation for the various functions is there.
On Wed, Feb 20, 2013 at 2:56 PM, Steve Garrison sgg@alexcomp.com > wrote:
That works but I'm still searching for a list of ALL the possible values to
retrieve. I see that l1 is last trade but what about the other stuff like
volume, open, high, bid, etc? There must be a list somewhere.
say, time consuming and clumsy.
From: smf_addin@yahoogrou
Of Taral Pandya
Sent: Wednesday, February 20, 2013 4:10 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Am I using a sledgehammer when a tack driver might
be better?
Hey Steve,
I have looked into querying from e-trade. They don't support this kind of
querying. You have to call their API and then store the json sent back in a
db and then extract it to excel. Very time consuming.
Sent from my iPhone
On Feb 20, 2013, at 5:06 PM, Steve Garrison sgg@alexcomp.
Got it. Sorry I wasn't more thorough in reading the documentation. I'm
assuming there's no place to get real-time data with these functions. I
might ask my Etrade rep if there's any possibility of querying their server.
From: smf_addin@yahoogrou
Of Randy Harmelink
Sent: Wednesday, February 20, 2013 3:58 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Am I using a sledgehammer when a tack driver might
be better?
Take a look in the "Documentation
documentation for the various functions is there.
On Wed, Feb 20, 2013 at 2:56 PM, Steve Garrison sgg@alexcomp.
That works but I'm still searching for a list of ALL the possible values to
retrieve. I see that l1 is last trade but what about the other stuff like
volume, open, high, bid, etc? There must be a list somewhere.
Wed Feb 20, 2013 1:34 pm (PST) . Posted by:
"alexcomp1" alexcomp1
Hopefully this post will be slightly more intelligent than the last one. I now understand how to retrieve "last price" from Msn. Unfortunately, that does not seem to be updated more than once per day.
I have scanned through the Excel file with the element definitions and don't find a last price element for Yahoo finance. Am I missing something? I have a real-time data feed from E*TRADE. Is there any way of accessing that?
I have scanned through the Excel file with the element definitions and don't find a last price element for Yahoo finance. Am I missing something? I have a real-time data feed from E*TRADE. Is there any way of accessing that?
Wed Feb 20, 2013 1:56 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, as of early last year, the "Last Price" that MSN posts is
actually the previous day's closing price. I have no idea why.
You should use the RCHGetYahooQuotes() function to get quotes data.
I don't know if you can get real-time data from E*TRADE. I don't have
access to it to try. But they probably use their own API or interface.
On Wed, Feb 20, 2013 at 2:34 PM, alexcomp1 sgg@alexcomp.com > wrote:
> Hopefully this post will be slightly more intelligent than the last one.
> I now understand how to retrieve "last price" from Msn. Unfortunately,
> that does not seem to be updated more than once per day.
>
> I have scanned through the Excel file with the element definitions and
> don't find a last price element for Yahoo finance. Am I missing something?
> I have a real-time data feed from E*TRADE. Is there any way of accessing
> that?
>
actually the previous day's closing price. I have no idea why.
You should use the RCHGetYahooQuotes(
I don't know if you can get real-time data from E*TRADE. I don't have
access to it to try. But they probably use their own API or interface.
On Wed, Feb 20, 2013 at 2:34 PM, alexcomp1 sgg@alexcomp.
> Hopefully this post will be slightly more intelligent than the last one.
> I now understand how to retrieve "last price" from Msn. Unfortunately,
> that does not seem to be updated more than once per day.
>
> I have scanned through the Excel file with the element definitions and
> don't find a last price element for Yahoo finance. Am I missing something?
> I have a real-time data feed from E*TRADE. Is there any way of accessing
> that?
>
Thu Feb 21, 2013 5:07 am (PST) . Posted by:
"Tze Wei," tzewei_79
Hi,
I tried =RCHGetTableCell("http://www.sectorspdr.com/eqsnaps/?do=snapshot&symbol= "&A67,1,"Sector SPDR") where A67 = WIN, and the results is "15,693,991Volume"
Actually I wanted to capture the sector of a stock now but I can't get this to work. Is there any way to display the Sector SPDR?
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> That also would just be a normal EXCEL operation, of concatenation:
>
> =RCHGetTableCell("
> http://investing.money.msn.com/investments/stock-income-statement/?symbol= "&A1,1,"Total
> Revenue")
>
> On Sun, Feb 10, 2013 at 4:42 AM, Tze Wei, wrote:
>
> >
> > I meant:
> >
> > Cell A1 = IBM
> > Cell B1 = =RCHGetTableCell("
> > http://investing.money.msn.com/investments/stock-income-statement/?symbol=A1 ",1,"Total
> > Revenue")
> >
> > Actually I wanted to do something similar to
> > "SMF-Template-Yahoo-Key-Statistics.xls" but using =RCHGetTableCell as only
> > some data are available only in MSN but not in Yahoo.
> >
> > Is that possible?
> >
>
I tried =RCHGetTableCell(
Actually I wanted to capture the sector of a stock now but I can't get this to work. Is there any way to display the Sector SPDR?
--- In smf_addin@yahoogrou
>
> That also would just be a normal EXCEL operation, of concatenation:
>
> =RCHGetTableCell(
> http://investing.
> Revenue"
>
> On Sun, Feb 10, 2013 at 4:42 AM, Tze Wei, wrote:
>
> >
> > I meant:
> >
> > Cell A1 = IBM
> > Cell B1 = =RCHGetTableCell(
> > http://investing.
> > Revenue"
> >
> > Actually I wanted to do something similar to
> > "SMF-Template-
> > some data are available only in MSN but not in Yahoo.
> >
> > Is that possible?
> >
>
Thu Feb 21, 2013 7:05 am (PST) . Posted by:
"Randy Harmelink" rharmelink
That's because "Sector SPDR" is in the title of the web page, and elsewhere
before you get to where you want it to be, so you end up getting the first
table cell after that.
You'll need to do something like:
=RCHGetTableCell("http://www.sectorspdr.com/eqsnaps/?do=snapshot&symbol= "&A67,0,">Sector
SPDR")
...but then you'll need to parse it out because they have the label and the
sector in the same table cell.
You do sometimes need to look at the source code of the web page to see how
things are coded, instead of just guessing what you might need.
On Thu, Feb 21, 2013 at 6:06 AM, Tze Wei, tzewei_79@yahoo.com.sg > wrote:
>
> I tried =RCHGetTableCell("
> http://www.sectorspdr.com/eqsnaps/?do=snapshot&symbol= "&A67,1,"Sector
> SPDR") where A67 = WIN, and the results is "15,693,991Volume"
>
> Actually I wanted to capture the sector of a stock now but I can't get
> this to work. Is there any way to display the Sector SPDR?
>
before you get to where you want it to be, so you end up getting the first
table cell after that.
You'll need to do something like:
=RCHGetTableCell(
SPDR")
...but then you'll need to parse it out because they have the label and the
sector in the same table cell.
You do sometimes need to look at the source code of the web page to see how
things are coded, instead of just guessing what you might need.
On Thu, Feb 21, 2013 at 6:06 AM, Tze Wei, tzewei_79@yahoo.
>
> I tried =RCHGetTableCell(
> http://www.sectorsp
> SPDR") where A67 = WIN, and the results is "15,693,
>
> Actually I wanted to capture the sector of a stock now but I can't get
> this to work. Is there any way to display the Sector SPDR?
>
Thu Feb 21, 2013 6:40 am (PST) . Posted by:
"JCHyjun" JCHyjun
Dear Randy,
Somehow =RCHGetElementNumber(ANF,1285) also stopped to work for me.
Yahoo shows earnings date for ANF as 2/22/2013 at
http://biz.yahoo.com/research/earncal/a/anf.html (not at http://finance.yahoo.com/q/ae?s=ANF as follows from your reply)
Does 1285 element link with http://biz.yahoo.com/research/earncal/ pages?
Sincerely,
J. Chang Hyjun
--- In smf_addin@yahoogroups.com , Randy Harmelink wrote:
>
> Yahoo doesn't show the date on the sourced web page unless earnings are in
> the near future. For example:
>
> http://finance.yahoo.com/q/ae?s=AVA
>
> On Tue, Feb 12, 2013 at 6:35 AM, freddie_carroll
> wrote:
>
> > does the RCH code 1285 still work? I get N/A for every stock symbol I
> > tried. I've entered
> >
> > =RCHGetElementNumber(A3,1285)
> >
> > where A3 contains the stock symbol
> >
> > in a spreadsheet with other SMF Add-In functions that work.
> >
>
Somehow =RCHGetElementNumbe
Yahoo shows earnings date for ANF as 2/22/2013 at
http://biz.yahoo.
Does 1285 element link with http://biz.yahoo.
Sincerely,
J. Chang Hyjun
--- In smf_addin@yahoogrou
>
> Yahoo doesn't show the date on the sourced web page unless earnings are in
> the near future. For example:
>
> http://finance.
>
> On Tue, Feb 12, 2013 at 6:35 AM, freddie_carroll
> wrote:
>
> > does the RCH code 1285 still work? I get N/A for every stock symbol I
> > tried. I've entered
> >
> > =RCHGetElementNumbe
> >
> > where A3 contains the stock symbol
> >
> > in a spreadsheet with other SMF Add-In functions that work.
> >
>
Thu Feb 21, 2013 7:09 am (PST) . Posted by:
"Randy Harmelink" rharmelink
That's because Yahoo doesn't update it on the "Analyst Estimates" web page
as regularly as they used to, now that it's also on the main quotes page.
On Thu, Feb 21, 2013 at 7:40 AM, JCHyjun jchyjun@yahoo.com > wrote:
>
> Somehow =RCHGetElementNumber(ANF,1285) also stopped to work for me.
>
> Yahoo shows earnings date for ANF as 2/22/2013 at
> http://biz.yahoo.com/research/earncal/a/anf.html (not at
> http://finance.yahoo.com/q/ae?s=ANF as follows from your reply)
>
> Does 1285 element link with http://biz.yahoo.com/research/earncal/ pages?
>
as regularly as they used to, now that it's also on the main quotes page.
On Thu, Feb 21, 2013 at 7:40 AM, JCHyjun jchyjun@yahoo.
>
> Somehow =RCHGetElementNumbe
>
> Yahoo shows earnings date for ANF as 2/22/2013 at
> http://biz.yahoo.
> http://finance.
>
> Does 1285 element link with http://biz.yahoo.
>
Tidak ada komentar:
Posting Komentar