Messages In This Digest (8 Messages)
- 1a.
- Re: trying to get stock opion from barchart.com From: NicholasDavid
- 1b.
- Re: trying to get stock opion from barchart.com From: Randy Harmelink
- 1c.
- Preventing RCHGetQuote From: John Zman
- 1d.
- Re: Preventing RCHGetQuote From: Randy Harmelink
- 2a.
- Open Order Book Data From: ronmac17
- 2b.
- Re: Open Order Book Data From: Randy Harmelink
- 3a.
- RCH History for High and Low price From: bliu88
- 3b.
- Re: RCH History for High and Low price From: Randy Harmelink
Messages
- 1a.
-
Re: trying to get stock opion from barchart.com
Posted by: "NicholasDavid" nicholasdavid@comcast.net dnicholas4967
Sun Nov 13, 2011 4:25 am (PST)
Thanks, Randy. I can use this in my worksheet. But, why won't it work when I put Ticker108 instead of the actual symbol? And, how should I have known that 0 is the right number?
----- Original Message -----
From: "Randy Harmelink" <rharmelink@gmail.com >
To: "smf addin" <smf_addin@yahoogroups.com >
Sent: Saturday, November 12, 2011 6:36:59 PM
Subject: Re: [smf_addin] trying to get stock opion from barchart.com
The URL you have below is not a valid one. I think you want something like:
=RCHGetTableCell(" http://www.barchart .com/quotes/ ",0,"background-stocks/MMM color")
However, you may want to take a look at this template, which has more of the buy/sell information:
RCHGetTableCell-Template- BarChart- Technical- Signals.xls
On Sat, Nov 12, 2011 at 4:40 PM, David < nicholasdavid@comcast.net > wrote:
=RCHGetTableCell( http://www.barchart.com/quotes/ "bar chart opinion")stocks/ticker108 ,2,
barchart.com gives buy/sell/hold opinion on this site.
I'm searching for the correct syntax and am at a loss.
- 1b.
-
Re: trying to get stock opion from barchart.com
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Nov 13, 2011 7:20 am (PST)
Ticker108 as a literal is not a valid ticker symbol. You would need to
concatenate it if it is a cell reference:
"http://www.barchart.com/quotes/ "&ticker108stocks/
The 0 value (as well as the search string) is something you would need to
figure out by actually looking at the source code of the web page, to
determine the best search string to use and how to skip table cells and, if
necessary, table rows, to get to the actual data.
On Sun, Nov 13, 2011 at 5:25 AM, NicholasDavid <nicholasdavid@comcast.net >wrote:
>
> Thanks, Randy. I can use this in my worksheet. But, why won't it work when
> I put Ticker108 instead of the actual symbol? And, how should I have known
> that 0 is the right number?
>
> --------------------- ---------
> *From: *"Randy Harmelink" <rharmelink@gmail.com >
> *To: *"smf addin" <smf_addin@yahoogroups.com >
> *Sent: *Saturday, November 12, 2011 6:36:59 PM
> *Subject: *Re: [smf_addin] trying to get stock opion from barchart.com
>
>
> The URL you have below is not a valid one. I think you want something like:
>
> =RCHGetTableCell("http://www.barchart .com/quotes/ stocks/MMM
> ",0,"background-color")
>
> However, you may want to take a look at this template, which has more of
> the buy/sell information:
>
> RCHGetTableCell-Template- BarChart- Technical- Signals.xls
>
- 1c.
-
Preventing RCHGetQuote
Posted by: "John Zman" john.zman@yahoo.com john.zman
Sun Nov 13, 2011 9:01 am (PST)
Hi All:
I tried to use appllication.enableevents = False to prevent execution, but it doesn't seem to work. Is there a way to control when execution occurs?
Thanks
--- On Sun, 11/13/11, Randy Harmelink <rharmelink@gmail.com > wrote:
From: Randy Harmelink <rharmelink@gmail.com >
Subject: Re: [smf_addin] trying to get stock opion from barchart.com
To: smf_addin@yahoogroups.com
Date: Sunday, November 13, 2011, 3:20 PM
Ticker108 as a literal is not a valid ticker symbol. You would need to concatenate it if it is a cell reference:
"http://www.barchart.com/quotes/ "&ticker108stocks/
The 0 value (as well as the search string) is something you would need to figure out by actually looking at the source code of the web page, to determine the best search string to use and how to skip table cells and, if necessary, table rows, to get to the actual data.
On Sun, Nov 13, 2011 at 5:25 AM, NicholasDavid <nicholasdavid@comcast.net > wrote:
Thanks, Randy. I can use this in my worksheet. But, why won't it work when I put Ticker108 instead of the actual symbol? And, how should I have known that 0 is the right number?
From: "Randy Harmelink" <rharmelink@gmail.com >
To: "smf addin" <smf_addin@yahoogroups.com >
Sent: Saturday, November 12, 2011 6:36:59 PM
Subject: Re: [smf_addin] trying to get stock opion from barchart.com
The URL you have below is not a valid one. I think you want something like:
=RCHGetTableCell("http://www.barchart .com/quotes/ ",0,"background-stocks/MMM color")
However, you may want to take a look at this template, which has more of the buy/sell information:
RCHGetTableCell-Template- BarChart- Technical- Signals.xls
- 1d.
-
Re: Preventing RCHGetQuote
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Nov 13, 2011 12:05 pm (PST)
In what context?
The RCHGetYahooQuotes() formula is non-volatile unless you make it volatile.
I use the smfForceRecalculation macro to control when my updates occur.
On Sun, Nov 13, 2011 at 10:01 AM, John Zman <john.zman@yahoo.com > wrote:
>
> I tried to use appllication.enableevents = False to prevent execution, but
> it doesn't seem to work. Is there a way to control when execution occurs?
>
- 2a.
-
Open Order Book Data
Posted by: "ronmac17" ronmac17@yahoo.com ronmac17
Sun Nov 13, 2011 10:11 am (PST)
Good article on "Analyzing an Electronic Limit Order Book" using R. http://journal.r-project. I would like to find a (free) source for Open Order Book Data that I can retrieve with RCH. Historical data is ok until l can get the code functioning properly. I don't think the BATS file still works, have to try it tomorrow.org/archive/ 2011-1/RJournal_ 2011-1_Kane~ et~al.pdf
- 2b.
-
Re: Open Order Book Data
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Nov 13, 2011 10:26 am (PST)
The BATS template was pulled because it no longer worked -- it's in the
"Need to be looked at" sub-folder of the "Works in Progress" folder. IIRC,
it was because the BATS site started to dynamically load the data, so it
was no longer available within the source code of the web page, which is
where the add-in needs the data to be in order to extract it:
http://batstrading.com/book/ MMM/
Originally, the template got the data from the Yahoo page, but I converted
it to the BATS site because they had more detailed info. My plan was to
convert it back to the Yahoo page:
http://finance.yahoo.com/ q/ecn?s=MMM
If I remember, I'll take a look at it tomorrow...
On Sun, Nov 13, 2011 at 11:11 AM, ronmac17 <ronmac17@yahoo.com > wrote:
> Good article on "Analyzing an Electronic Limit Order Book" using R.
> http://journal.r-project. would like to find a (free) source for Open Order Book Data that I canorg/archive/ 2011-1/RJournal_ 2011-1_Kane~ et~al.pdfI
> retrieve with RCH. Historical data is ok until l can get the code
> functioning properly. I don't think the BATS file still works, have to try
> it tomorrow.
>
- 3a.
-
RCH History for High and Low price
Posted by: "bliu88" bliu88@yahoo.com bliu88
Sun Nov 13, 2011 8:31 pm (PST)
I'm trying to use RCHGetYahooHistory to get high or low price for a particular stock on a particular date. What is the parameter I should use?
- 3b.
-
Re: RCH History for High and Low price
Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink
Sun Nov 13, 2011 8:34 pm (PST)
Something similar to this should work:
=RCHGetYahooHistory("MMM",2011, 11,10,2011, 11,10,"d" ,"HL",0,0)
On Sun, Nov 13, 2011 at 9:28 PM, bliu88 <bliu88@yahoo.com > wrote:
> I'm trying to use RCHGetYahooHistory to get high or low price for a
> particular stock on a particular date. What is the parameter I should use?
>
Need to Reply?
Click one of the "Reply" links to respond to a specific message in the Daily Digest.
MARKETPLACE
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Individual | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
Tidak ada komentar:
Posting Komentar