10 New Messages
Digest #2599
3b
Re: Retrieve De-listed Date / Last Date Traded with get rchgetyahooq by "Randy Harmelink" rharmelink
4a
Re: [NEWBIE] Can NASDAQ Real-Time data be captured ? by "jshgfhjsgdfhjgsdfutef" jshgfhjsgdfhjgsdfutef
5a
Simple Method For Auto-Refresh of YahooGetQuotes() function by "jshgfhjsgdfhjgsdfutef" jshgfhjsgdfhjgsdfutef
Messages
Mon Apr 29, 2013 3:15 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Take a look at the smfGetOptionQuotes() function...
Yahoo's CSV file hasn't worked for options since they option symbology
changed a few years ago.
If you want to get them yourself, I'd suggest getting it from one of the
quotes VIEW pages. For example:
=RCHGetTableCell("http://finance.yahoo.com/quotes/BAC140118C00012000/view/v1
",
2,">Symbol",">BAC140118C00012000")
The advantage of getting the data from a VIEW page is that you can get
multiple quotes with a single Internet access. For example (note the URLs
are the same):
=RCHGetTableCell("
http://finance.yahoo.com/quotes/BAC140118C00012000,BAC150117C00012000/view/v1
",
2,">Symbol",">BAC140118C00012000")
=RCHGetTableCell("
http://finance.yahoo.com/quotes/BAC140118C00012000,BAC150117C00012000/view/v1
",
2,">Symbol",">BAC150117C00012000")
Or, you can pick up the whole table at once, by array-entering:
=RCHGetHTMLTable("
http://finance.yahoo.com/quotes/BAC140118C00012000,BAC150117C00012000/view/v1
",
">Symbol",-1,"",1)
On Sun, Apr 28, 2013 at 11:35 PM, aviadmfi <yinonari@yahoo.com > wrote:
>
> I need to read an option last price from Yahoo Finance. I'm trying
> something like
> http://download.finance.yahoo.com/d/quotes.csv?f=sl1c4p0&s=bac140118c00012000but it retrun a price of '0' (for stocks it work).
>
> Does anyone know how to fix that?
>
Yahoo's CSV file hasn't worked for options since they option symbology
changed a few years ago.
If you want to get them yourself, I'd suggest getting it from one of the
quotes VIEW pages. For example:
=RCHGetTableCell(
",
2,">
The advantage of getting the data from a VIEW page is that you can get
multiple quotes with a single Internet access. For example (note the URLs
are the same):
=RCHGetTableCell(
http://finance.
",
2,">
=RCHGetTableCell(
http://finance.
",
2,">
Or, you can pick up the whole table at once, by array-entering:
=RCHGetHTMLTable(
http://finance.
",
">Symbol&qu
On Sun, Apr 28, 2013 at 11:35 PM, aviadmfi <yinonari@yahoo.
>
> I need to read an option last price from Yahoo Finance. I'm trying
> something like
> http://download.
>
> Does anyone know how to fix that?
>
Mon Apr 29, 2013 3:29 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Ah, you're right. You'll need to use the source files they're loaded from:
http://financials.morningstar.com/valuation/valuation-history.action?&t=C&type=price-earnings
http://financials.morningstar.com/valuation/valuation-history.action?&t=C&type=price-book
http://financials.morningstar.com/valuation/valuation-history.action?&t=C&type=price-sales
http://financials.morningstar.com/valuation/valuation-history.action?&t=C&type=price-cash
All four files contain the same data, just in a different order.
I've been trying to decide if it's worth the effort to redefine the
elements back to the source of the dynamic web pages' displays. I'd hate to
put in the effort only to see MorningStar change things (again).
On Mon, Apr 29, 2013 at 1:16 AM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> for the page you referred, i could not find any of the datas below
>
> what i would like specifically are the 10 year p/e, p/s, p/b and p/cf data
> which used to have a rchelement number.
>
> tried using page source method but it just shows me a blank screen
>
> was wondering is there any other tricks to get the data?
>
http://financials.
http://financials.
http://financials.
http://financials.
All four files contain the same data, just in a different order.
I've been trying to decide if it's worth the effort to redefine the
elements back to the source of the dynamic web pages' displays. I'd hate to
put in the effort only to see MorningStar change things (again).
On Mon, Apr 29, 2013 at 1:16 AM, weekeewawa <weekeewawa@yahoo.
>
> for the page you referred, i could not find any of the datas below
>
> what i would like specifically are the 10 year p/e, p/s, p/b and p/cf data
> which used to have a rchelement number.
>
> tried using page source method but it just shows me a blank screen
>
> was wondering is there any other tricks to get the data?
>
Mon Apr 29, 2013 1:26 pm (PDT) . Posted by:
"weekeewawa" weekeewawa
hello randy
when i used this code,
=RCHGetHTMLTable("http://financials.morningstar.com/valuation/valuation-history.action?&t= "&A2,"&type=price-cash>Price/Cash Flow",-1,"",1)
it shows me an empty space.
is there anything wrong with it?
also, i think it will be easier for everyone if morningstar can be integrated in RCHelement format
but like what u said, morningstar may change though...
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> Ah, you're right. You'll need to use the source files they're loaded from:
>
> http://financials.morningstar.com/valuation/valuation-history.action?&t=C&type=price-earnings
> http://financials.morningstar.com/valuation/valuation-history.action?&t=C&type=price-book
> http://financials.morningstar.com/valuation/valuation-history.action?&t=C&type=price-sales
> http://financials.morningstar.com/valuation/valuation-history.action?&t=C&type=price-cash
>
> All four files contain the same data, just in a different order.
>
> I've been trying to decide if it's worth the effort to redefine the
> elements back to the source of the dynamic web pages' displays. I'd hate to
> put in the effort only to see MorningStar change things (again).
>
> On Mon, Apr 29, 2013 at 1:16 AM, weekeewawa <weekeewawa@...> wrote:
>
> >
> > for the page you referred, i could not find any of the datas below
> >
> > what i would like specifically are the 10 year p/e, p/s, p/b and p/cf data
> > which used to have a rchelement number.
> >
> > tried using page source method but it just shows me a blank screen
> >
> > was wondering is there any other tricks to get the data?
> >
>
when i used this code,
=RCHGetHTMLTable(
it shows me an empty space.
is there anything wrong with it?
also, i think it will be easier for everyone if morningstar can be integrated in RCHelement format
but like what u said, morningstar may change though...
--- In smf_addin@yahoogrou
>
> Ah, you're right. You'll need to use the source files they're loaded from:
>
> http://financials.
> http://financials.
> http://financials.
> http://financials.
>
> All four files contain the same data, just in a different order.
>
> I've been trying to decide if it's worth the effort to redefine the
> elements back to the source of the dynamic web pages' displays. I'd hate to
> put in the effort only to see MorningStar change things (again).
>
> On Mon, Apr 29, 2013 at 1:16 AM, weekeewawa <weekeewawa@
>
> >
> > for the page you referred, i could not find any of the datas below
> >
> > what i would like specifically are the 10 year p/e, p/s, p/b and p/cf data
> > which used to have a rchelement number.
> >
> > tried using page source method but it just shows me a blank screen
> >
> > was wondering is there any other tricks to get the data?
> >
>
Mon Apr 29, 2013 1:51 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
You're doing the concatenation wrong:
=RCHGetHTMLTable("
http://financials.morningstar.com/valuation/valuation-history.action?&t= "&A2&"&type=price-cash",">Price/Cash
Flow",-1,"",1)
On Mon, Apr 29, 2013 at 1:26 PM, weekeewawa <weekeewawa@yahoo.com > wrote:
>
> when i used this code,
>
> =RCHGetHTMLTable("
> http://financials.morningstar.com/valuation/valuation-history.action?&t= "&A2,"&type=price-cash>Price/Cash
> Flow",-1,"",1)
>
> it shows me an empty space.
>
> is there anything wrong with it?
>
> also, i think it will be easier for everyone if morningstar can be
> integrated in RCHelement format
>
> but like what u said, morningstar may change though...
>
=RCHGetHTMLTable(
http://financials.
Flow",-
On Mon, Apr 29, 2013 at 1:26 PM, weekeewawa <weekeewawa@yahoo.
>
> when i used this code,
>
> =RCHGetHTMLTable(
> http://financials.
> Flow",-
>
> it shows me an empty space.
>
> is there anything wrong with it?
>
> also, i think it will be easier for everyone if morningstar can be
> integrated in RCHelement format
>
> but like what u said, morningstar may change though...
>
Mon Apr 29, 2013 6:27 am (PDT) . Posted by:
"curls07" curls07
Hi Guys,
I'm trying to do some research on stocks by comparing the dates that they were de-listed. So far, I've only been able to tell whether the equity in question was traded/listed at a given date by using rchgetyahoohistory for that date and then seeing if it returns a price or not.
What I would like to do is to pull the last date the stock was traded/listed from rchgetyahoohistory. Is this possible? if so, any ideas on how to make it so?
Thanks a lot!
I'm trying to do some research on stocks by comparing the dates that they were de-listed. So far, I've only been able to tell whether the equity in question was traded/listed at a given date by using rchgetyahoohistory for that date and then seeing if it returns a price or not.
What I would like to do is to pull the last date the stock was traded/listed from rchgetyahoohistory. Is this possible? if so, any ideas on how to make it so?
Thanks a lot!
Mon Apr 29, 2013 10:39 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
Not possible from Yahoo, as far as I know...
On Mon, Apr 29, 2013 at 6:27 AM, curls07 <agc11d@gmail.com > wrote:
>
> I'm trying to do some research on stocks by comparing the dates that they
> were de-listed. So far, I've only been able to tell whether the equity in
> question was traded/listed at a given date by using rchgetyahoohistory for
> that date and then seeing if it returns a price or not.
>
> What I would like to do is to pull the last date the stock was
> traded/listed from rchgetyahoohistory. Is this possible? if so, any ideas
> on how to make it so?
>
On Mon, Apr 29, 2013 at 6:27 AM, curls07 <agc11d@gmail.
>
> I'm trying to do some research on stocks by comparing the dates that they
> were de-listed. So far, I've only been able to tell whether the equity in
> question was traded/listed at a given date by using rchgetyahoohistory for
> that date and then seeing if it returns a price or not.
>
> What I would like to do is to pull the last date the stock was
> traded/listed from rchgetyahoohistory. Is this possible? if so, any ideas
> on how to make it so?
>
Mon Apr 29, 2013 11:31 am (PDT) . Posted by:
"jshgfhjsgdfhjgsdfutef" jshgfhjsgdfhjgsdfutef
Hi Randy
Was looking on Yahoo to see if I could find where to sign up for the real-time quotes, but wasn't successful, although I'm sure I sure it is there somewhere with an offer of 30 days free - any idea as to where the sign-up can be found + how does this integrate with the GetYQ() function ?
Many thanks
Dave
PS Tremendous work - many thanks
--- In smf_addin@yahoogroups.com , Randy Harmelink <rharmelink@...> wrote:
>
> The RCHGetYahooQuotes() function can't get FREE real-time quotes.
>
> On Fri, Apr 19, 2013 at 5:37 AM, cybersurferuk <cybersurferuk@...
> > wrote:
>
> >
> > Thanks again Randy, I will look at the getquotes function which I was
> > going to use only with the nasdaq or nyse stocks as these seem to be
> > realtime for free - or am I mistaken ?
> >
>
Was looking on Yahoo to see if I could find where to sign up for the real-time quotes, but wasn't successful, although I'm sure I sure it is there somewhere with an offer of 30 days free - any idea as to where the sign-up can be found + how does this integrate with the GetYQ() function ?
Many thanks
Dave
PS Tremendous work - many thanks
--- In smf_addin@yahoogrou
>
> The RCHGetYahooQuotes(
>
> On Fri, Apr 19, 2013 at 5:37 AM, cybersurferuk <cybersurferuk@
> > wrote:
>
> >
> > Thanks again Randy, I will look at the getquotes function which I was
> > going to use only with the nasdaq or nyse stocks as these seem to be
> > realtime for free - or am I mistaken ?
> >
>
Mon Apr 29, 2013 1:44 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
This link is at the bottom of any stock quote page:
http://billing.finance.yahoo.com/realtime_quotes/signup?.src=quote&.refer=quote
I don't use real-time quotes myself. It's my understanding that it just
uses the real-time feed for all of their quote tools, including the CSV
file used by RCHGetYahooQuotes(). So there should be no change for you,
other than having to make sure you create the IE security cookie...
On Mon, Apr 29, 2013 at 11:31 AM, jshgfhjsgdfhjgsdfutef <
cybersurferuk@googlemail.com > wrote:
>
> Was looking on Yahoo to see if I could find where to sign up for the
> real-time quotes, but wasn't successful, although I'm sure I sure it is
> there somewhere with an offer of 30 days free - any idea as to where the
> sign-up can be found + how does this integrate with the GetYQ() function ?
>
http://billing.
I don't use real-time quotes myself. It's my understanding that it just
uses the real-time feed for all of their quote tools, including the CSV
file used by RCHGetYahooQuotes(
other than having to make sure you create the IE security cookie...
On Mon, Apr 29, 2013 at 11:31 AM, jshgfhjsgdfhjgsdfut
cybersurferuk@
>
> Was looking on Yahoo to see if I could find where to sign up for the
> real-time quotes, but wasn't successful, although I'm sure I sure it is
> there somewhere with an offer of 30 days free - any idea as to where the
> sign-up can be found + how does this integrate with the GetYQ() function ?
>
Mon Apr 29, 2013 12:47 pm (PDT) . Posted by:
"jshgfhjsgdfhjgsdfutef" jshgfhjsgdfhjgsdfutef
This assumes that you have created the array function with "quotes(x---,Now())" as per the notes.
Add the following to the workbook code area ->
Private Sub Workbook_Open()
Application.OnTime Now + TimeValue("00:00:10"), "Auto_Refresh"
End Sub
Add somewhere in a code module
Sub Auto_Refresh()
Dim a As Range, sht As Worksheet
Application.ScreenUpdating = False
If ThisWorkbook.Worksheets(CTRL_SHT).Range(REFRESH_ON).Value Then
Set sht = ActiveSheet: Set a = ActiveCell
ThisWorkbook.Worksheets(SRVR_SHT).Select: ActiveSheet.Calculate
sht.Activate: If a Is Nothing Then Else a.Activate
End If
Application.ScreenUpdating = True
Application.OnTime Now + TimeValue(REFRESH_TIME), "Auto_Refresh"
End Sub
"CTRL_SHT"; is a sheet where a value is stored : TRUE for auto refresh on
"REFRESH_ON" is the cell which contains the auto refresh flag
"SRVR_SHT"; is the sheet where the getquotes function stores it's results
"REFRESH_TIME" is a string which I have as "00:00:03" for refresh every 3 seconds
I have a tick box which sets/unsets the auto refresh flag
also a button which calls auto-refresh (if I'm editing the code while the refresh is running)
Hope this is of some use / any suggestions for improvement ?
Add the following to the workbook code area ->
Private Sub Workbook_Open(
Application.
End Sub
Add somewhere in a code module
Sub Auto_Refresh(
Dim a As Range, sht As Worksheet
Application.
If ThisWorkbook.
Set sht = ActiveSheet: Set a = ActiveCell
ThisWorkbook.
sht.Activate: If a Is Nothing Then Else a.Activate
End If
Application.
Application.
End Sub
"CTRL_SHT"
"REFRESH_
"SRVR_SHT"
"REFRESH_
I have a tick box which sets/unsets the auto refresh flag
also a button which calls auto-refresh (if I'm editing the code while the refresh is running)
Hope this is of some use / any suggestions for improvement ?
Mon Apr 29, 2013 1:48 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Have you looked at the template in the FILES area of the group?
On Mon, Apr 29, 2013 at 12:47 PM, jshgfhjsgdfhjgsdfutef <
cybersurferuk@googlemail.com > wrote:
> This assumes that you have created the array function with
> "quotes(x---,Now())" as per the notes.
>
> Add the following to the workbook code area ->
>
> Private Sub Workbook_Open()
> Application.OnTime Now + TimeValue("00:00:10"), "Auto_Refresh"
> End Sub
>
> Add somewhere in a code module
>
> Sub Auto_Refresh()
>
> Dim a As Range, sht As Worksheet
>
> Application.ScreenUpdating = False
>
> If ThisWorkbook.Worksheets(CTRL_SHT).Range(REFRESH_ON).Value Then
> Set sht = ActiveSheet: Set a = ActiveCell
> ThisWorkbook.Worksheets(SRVR_SHT).Select: ActiveSheet.Calculate
> sht.Activate: If a Is Nothing Then Else a.Activate
> End If
>
> Application.ScreenUpdating = True
>
> Application.OnTime Now + TimeValue(REFRESH_TIME), "Auto_Refresh"
>
> End Sub
>
>
> "CTRL_SHT"; is a sheet where a value is stored : TRUE for auto refresh on
> "REFRESH_ON" is the cell which contains the auto refresh flag
>
> "SRVR_SHT"; is the sheet where the getquotes function stores it's results
>
> "REFRESH_TIME" is a string which I have as "00:00:03" for refresh every 3
> seconds
>
> I have a tick box which sets/unsets the auto refresh flag
> also a button which calls auto-refresh (if I'm editing the code while the
> refresh is running)
>
> Hope this is of some use / any suggestions for improvement ?
>
On Mon, Apr 29, 2013 at 12:47 PM, jshgfhjsgdfhjgsdfut
cybersurferuk@
> This assumes that you have created the array function with
> "quotes(
>
> Add the following to the workbook code area ->
>
> Private Sub Workbook_Open(
> Application.
> End Sub
>
> Add somewhere in a code module
>
> Sub Auto_Refresh(
>
> Dim a As Range, sht As Worksheet
>
> Application.
>
> If ThisWorkbook.
> Set sht = ActiveSheet: Set a = ActiveCell
> ThisWorkbook.
> sht.Activate: If a Is Nothing Then Else a.Activate
> End If
>
> Application.
>
> Application.
>
> End Sub
>
>
> "CTRL_SHT"
> "REFRESH_
>
> "SRVR_SHT"
>
> "REFRESH_
> seconds
>
> I have a tick box which sets/unsets the auto refresh flag
> also a button which calls auto-refresh (if I'm editing the code while the
> refresh is running)
>
> Hope this is of some use / any suggestions for improvement ?
>
Tidak ada komentar:
Posting Komentar