12 New Messages
Digest #2364
| 9a Re: Newbie question: Are the quotes pulled in from Yahoo real time? by "Randy Harmelink" rharmelink |
Messages
Sat Oct 6, 2012 3:18 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
^DJI no longer works, because Yahoo is no longer licensed to provide files
of their quotes data.
You just need to use the Yahoo symbol lookup for the tickers you want --
S&P 500 would be ^GSPC, NASDAQ 100 would be ^NDX, etc. But Yahoo may not
have historical data for the lesser indexes.
On Thu, Oct 4, 2012 at 12:49 PM, ntknow <livinsfun@hotmail.com > wrote:
> New to this but have the individual stock prices working. Can some one
> tell me the symbols to use for the Dow, S&P500, NASDAQ, and Philadelphia
> Gold & Silver Index. The Yahoo ^symbols don't seem to work.
>
of their quotes data.
You just need to use the Yahoo symbol lookup for the tickers you want --
S&P 500 would be ^GSPC, NASDAQ 100 would be ^NDX, etc. But Yahoo may not
have historical data for the lesser indexes.
On Thu, Oct 4, 2012 at 12:49 PM, ntknow <livinsfun@hotmail.
> New to this but have the individual stock prices working. Can some one
> tell me the symbols to use for the Dow, S&P500, NASDAQ, and Philadelphia
> Gold & Silver Index. The Yahoo ^symbols don't seem to work.
>
Sat Oct 6, 2012 3:21 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
They were undocumented, because I added them so I could use the functions
in VBA. Otherwise, pDim1 and pDim2 would just be the number of rows and
columns of data you want. If you array-enter the formula in a workbook,
those are automatically set.
On Mon, Oct 1, 2012 at 2:10 PM, David Brower <dbrower9@ix.netcom.com > wrote:
>
> What is the meaning of the two parameters PDim1 and PDim2. I can't seem to
> find this in the documentation?****
>
>
>
in VBA. Otherwise, pDim1 and pDim2 would just be the number of rows and
columns of data you want. If you array-enter the formula in a workbook,
those are automatically set.
On Mon, Oct 1, 2012 at 2:10 PM, David Brower <dbrower9@ix.
>
> What is the meaning of the two parameters PDim1 and PDim2. I can't seem to
> find this in the documentation?
>
>
>
Sat Oct 6, 2012 3:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
#N/A returns generally mean there was no way to fill the requested date
with a quote. Without more details, I can't give a more specific answer.
It could even be that Yahoo temporarily had historical quotes
unavailable...?
On Tue, Sep 25, 2012 at 6:23 AM, lexstar <lexstar@yahoo.com > wrote:
> I was using smfPricesByDates this past weekend and it works. Yesterday
> and today, when I went back to update my spreadsheet, it only gives me #NA.
>
> Something going on with this function?
>
> Everything was working fine before.
>
with a quote. Without more details, I can't give a more specific answer.
It could even be that Yahoo temporarily had historical quotes
unavailable.
On Tue, Sep 25, 2012 at 6:23 AM, lexstar <lexstar@yahoo.
> I was using smfPricesByDates this past weekend and it works. Yesterday
> and today, when I went back to update my spreadsheet, it only gives me #NA.
>
> Something going on with this function?
>
> Everything was working fine before.
>
Sat Oct 6, 2012 3:30 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
If you set the pRow parameter to a negative value, it gets cells based on
the end of the row that your search strings placed you in. For example:
=RCHGetTableCell("
http://www.federalreserve.gov/releases/h15/update/default.htm ",-1,"Baa")
...would get the value from the last table cell in the table row.
On Thu, Sep 27, 2012 at 1:45 PM, d.sweitzer22 <d.sweitzer22@yahoo.com >wrote:
> Hi. I am trying to get data from the Fed website using the
> RCHGetTableCell function. I am able to pull in the data from the table I
> want; however, my problem is that the table sometimes expands to more
> columns. I am trying to always pull in the data from the last column. I
> was wondering if there was some way to automate this instead of having to
> change the column in the function. Here is what I have.
>
> =RCHGetTableCell("
> http://www.federalreserve.gov/releases/h15/update/default.htm ",2,"Baa")
>
> Right now im pulling in data from column 2 but it expands to up to 5
> columns depending on the time and day of the week. Is there a way to have
> the function always search for the last column in the row?
>
the end of the row that your search strings placed you in. For example:
=RCHGetTableCell(
http://www.federalr
...would get the value from the last table cell in the table row.
On Thu, Sep 27, 2012 at 1:45 PM, d.sweitzer22 <d.sweitzer22@
> Hi. I am trying to get data from the Fed website using the
> RCHGetTableCell function. I am able to pull in the data from the table I
> want; however, my problem is that the table sometimes expands to more
> columns. I am trying to always pull in the data from the last column. I
> was wondering if there was some way to automate this instead of having to
> change the column in the function. Here is what I have.
>
> =RCHGetTableCell(
> http://www.federalr
>
> Right now im pulling in data from column 2 but it expands to up to 5
> columns depending on the time and day of the week. Is there a way to have
> the function always search for the last column in the row?
>
Sat Oct 6, 2012 3:39 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
It seems I did see something a while back on getting a file of intraday
data from Yahoo, but it's not something I would otherwise think was
available from Yahoo. I can't seem to find that info though.
There is a template to get such data from BarChart:
RCHGetWebData-Template-BarChart-Quotes-Extract.xls
On Thu, Sep 27, 2012 at 5:27 PM, andrewhills97 <andrewhills97@yahoo.com >wrote:
> Hi, Is there an Excel template which collects intraday price data from
> Yahoo Finance, say 5 min data. If so, is it delayed? Thanks and Regards
>
data from Yahoo, but it's not something I would otherwise think was
available from Yahoo. I can't seem to find that info though.
There is a template to get such data from BarChart:
RCHGetWebData-
On Thu, Sep 27, 2012 at 5:27 PM, andrewhills97 <andrewhills97@
> Hi, Is there an Excel template which collects intraday price data from
> Yahoo Finance, say 5 min data. If so, is it delayed? Thanks and Regards
>
Sat Oct 6, 2012 3:39 pm (PDT) . Posted by:
"dguillett1" donaldb36
You were missed. I even got a few personal inquires. Stay healthy!
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.com
From: Randy Harmelink
Sent: Saturday, October 06, 2012 4:25 PM
To: smf_addin@yahoogroups.com
Subject: Re: [smf_addin] Welcome back Randy!!!
Appreciate it. I was in the hospital for 4 days and then rehab for 17 days, because of a continuing leg/knee problem. Still not solved, and won't be unless I lose a lot of weight, but at least I can transfer well enough to get around.
On Sat, Oct 6, 2012 at 2:21 PM, Ron Spruell <hashky@yahoo.com > wrote:
I didn't know how long you were going to be AWOL, so I started trying to answer some of the questions that I thought I knew the answers.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguillett1@gmail.
From: Randy Harmelink
Sent: Saturday, October 06, 2012 4:25 PM
To: smf_addin@yahoogrou
Subject: Re: [smf_addin] Welcome back Randy!!!
Appreciate it. I was in the hospital for 4 days and then rehab for 17 days, because of a continuing leg/knee problem. Still not solved, and won't be unless I lose a lot of weight, but at least I can transfer well enough to get around.
On Sat, Oct 6, 2012 at 2:21 PM, Ron Spruell <hashky@yahoo.
I didn't know how long you were going to be AWOL, so I started trying to answer some of the questions that I thought I knew the answers.
Sat Oct 6, 2012 3:50 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
As noted, that data is not there. The Google address mentioned:
https://spreadsheets.google.com/spreadsheet/pub?hl=en&key=0An9cLcebwyomdHV4MHBRMUNQdk5xNVljQ2tqWW9iNGc&hl=en&chrome=false&gid=0
...contains the data and is display within a frame on the web page you
cited.
However, I would suspect that URL may change over time as a new copy of the
Google Document is published?
Extraction would be difficult though, since the Google Document is not
generated a valid HTML table (not ending any of the table cells).
On Wed, Oct 3, 2012 at 12:18 PM, tbrayman <tbrayman@yahoo.com > wrote:
>
> I was trying to get some information off this website:
>
> http://www.crossingwallstreet.com/buylist
>
> I tried to use both smfGetTagContent & RCHGetTableCell, but neither one is
> returning the web page contents. Is there a different method to do this?
>
https://spreadsheet
...contains the data and is display within a frame on the web page you
cited.
However, I would suspect that URL may change over time as a new copy of the
Google Document is published?
Extraction would be difficult though, since the Google Document is not
generated a valid HTML table (not ending any of the table cells).
On Wed, Oct 3, 2012 at 12:18 PM, tbrayman <tbrayman@yahoo.
>
> I was trying to get some information off this website:
>
> http://www.crossing
>
> I tried to use both smfGetTagContent & RCHGetTableCell, but neither one is
> returning the web page contents. Is there a different method to do this?
>
Sat Oct 6, 2012 3:54 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Unfortunately, Yahoo's 50- and 200-day moving averages are based on
calendar days and not trading days.
FinViz would be a good alternate source of the data, since you can return
data on multiple companies with a single Internet access -- see the FinViz
entries in the LINKS area of the group for more info.
On Thu, Oct 4, 2012 at 3:06 PM, Craig <craig.sander@comcast.net > wrote:
>
> I'd like to use the 50 day moving average, but when I use
> RCHGetYahooQuotes, the values are never quite correct. Anyone have any
> explanations or suggestions?
>
calendar days and not trading days.
FinViz would be a good alternate source of the data, since you can return
data on multiple companies with a single Internet access -- see the FinViz
entries in the LINKS area of the group for more info.
On Thu, Oct 4, 2012 at 3:06 PM, Craig <craig.sander@
>
> I'd like to use the 50 day moving average, but when I use
> RCHGetYahooQuotes, the values are never quite correct. Anyone have any
> explanations or suggestions?
>
Sat Oct 6, 2012 3:56 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I don't think Yahoo is supporting the ECN data elements, but I could be
wrong.
If you sign up for Yahoo' real-time quotes, it's my understanding that
RCHGetYahooQuotes() will use real-time quotes as long as you have create
the proper security cookie by logging in with IE or the EXCEL Web Query
process.
On Wed, Sep 19, 2012 at 9:52 PM, vancouvertesla <bclavette@gmail.com > wrote:
> For example if I enter:
>
> =rchgetyahooquotes("msn","k1") will I get back last trade and time of last
> trade?
>
> I realize I can wait till markets open tomorrow to figure this out...just
> wondering if anyone can answer me now :)
>
wrong.
If you sign up for Yahoo' real-time quotes, it's my understanding that
RCHGetYahooQuotes(
the proper security cookie by logging in with IE or the EXCEL Web Query
process.
On Wed, Sep 19, 2012 at 9:52 PM, vancouvertesla <bclavette@gmail.
> For example if I enter:
>
> =rchgetyahooquotes(
> trade?
>
> I realize I can wait till markets open tomorrow to figure this out...just
> wondering if anyone can answer me now :)
>
Sat Oct 6, 2012 4:04 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I would typically go to the AdvFN defined elements.
However, the add-in is NOT intended for creating databases, so I'm not
happy to hear a question about "large groups of stocks" -- to me, that is
abusing the providers of free data.
On Wed, Sep 26, 2012 at 12:36 PM, Gregory Clapper <gman1849@hotmail.com >wrote:
> Hi, new to the group and wondering if there is a location to pull
> historical financial report data for large groups of stocks, looking for 10
> years of annual EPS data for starters.
>
However, the add-in is NOT intended for creating databases, so I'm not
happy to hear a question about "large groups of stocks" -- to me, that is
abusing the providers of free data.
On Wed, Sep 26, 2012 at 12:36 PM, Gregory Clapper <gman1849@hotmail.
> Hi, new to the group and wondering if there is a location to pull
> historical financial report data for large groups of stocks, looking for 10
> years of annual EPS data for starters.
>
Sat Oct 6, 2012 5:26 pm (PDT) . Posted by:
"metastkuser100" metastkuser100
I would like to:
a) Screen scrape two numbers from a website, every 15 minutes, which then populate a table in Excel, throughout market hours, M-F.
b) Then plot an Excel chart based on the data in the table. As the day progresses, the table and the chart gets automatically updated every 15 minutes.
This is possibly way beyond my abilities, but I'm willing to give a real good try!
Can the first part be done by SMF plugin?
a) Screen scrape two numbers from a website, every 15 minutes, which then populate a table in Excel, throughout market hours, M-F.
b) Then plot an Excel chart based on the data in the table. As the day progresses, the table and the chart gets automatically updated every 15 minutes.
This is possibly way beyond my abilities, but I'm willing to give a real good try!
Can the first part be done by SMF plugin?
Sat Oct 6, 2012 5:47 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Yes, the add-in could probably facilitate the process if pulling the data
from the web page (it depends on how that data is presented), but you'd
still need to write your own VBA routine to handle the timing.
On Sat, Oct 6, 2012 at 5:26 PM, metastkuser100 <metastkuser100@yahoo.com >wrote:
> I would like to:
>
> a) Screen scrape two numbers from a website, every 15 minutes, which then
> populate a table in Excel, throughout market hours, M-F.
>
> b) Then plot an Excel chart based on the data in the table. As the day
> progresses, the table and the chart gets automatically updated every 15
> minutes.
>
> This is possibly way beyond my abilities, but I'm willing to give a real
> good try!
>
> Can the first part be done by SMF plugin?
>
from the web page (it depends on how that data is presented), but you'd
still need to write your own VBA routine to handle the timing.
On Sat, Oct 6, 2012 at 5:26 PM, metastkuser100 <metastkuser100@
> I would like to:
>
> a) Screen scrape two numbers from a website, every 15 minutes, which then
> populate a table in Excel, throughout market hours, M-F.
>
> b) Then plot an Excel chart based on the data in the table. As the day
> progresses, the table and the chart gets automatically updated every 15
> minutes.
>
> This is possibly way beyond my abilities, but I'm willing to give a real
> good try!
>
> Can the first part be done by SMF plugin?
>
Tidak ada komentar:
Posting Komentar