6 Messages
Digest #3385
Messages
Sat Apr 18, 2015 12:20 pm (PDT) . Posted by:
"Pete A" option2z
RE: I was able to get a 1 minute chart for ARII:
http://www.barchart.com/chart.php?sym=ARII
<http://www.barchart.com/chart.php?sym=ARII&style=technical&template=&p=I&d=
L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&i
ndicators=&addindicator=&submitted=1&fpage=&txtDate>
&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&e
vnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=
&txtDate=
However, many minutes are missing? Maybe there has to be trading volume
during that minute?
Here's one that doesn't work. I may well have something wrong, but the same
format works for other tickers.
=smfConvertData(smfWord(RCHGetWebData("http://www.barchart.com/chart.php?sym
=ARII&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&
g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&f
page=&txtDate=","Fri. Apr 17, 2015 12:03:00",100),4,"', '"))
Note that I'm asking for 12:03:00. See below to see that it is returning
15:53:00 to 15:58:00
There is time shifting going on, but seems to be an adjustment for PDT,
shifting to EDT at 15:xx time. What makes NO sense to me, is that it is
doing the minutes xx:53:xx to xx:59:xx when I ask for xx:03:xx
I think you might be right.there just isn't a trade at that time (thinly
traded stocks). OTOH, there is an example that has 000 volume, but still
quotes prices (15:53:00).
See yellow highlight below. But maybe you can shed light on the time issues.
And here's the data from the page retrieved:
<area shape="rect" coords="453,131,539,259"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'ARII', '52.2400000', '52.2900000', '52.2100000', '52.2100000')">
<area shape="rect" coords="364,68,450,211"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'ARII', '52.2400000', '52.3300000', '52.2400000', '52.2600000')">
<area shape="rect" coords="276,20,362,131"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'ARII', '52.2900000', '52.3600000', '52.2900000', '52.3000000')">
<area shape="rect" coords="188,115,274,211"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'ARII', '52.2400000', '52.3000000', '52.2400000', '52.3000000')">
<area shape="rect" coords="99,179,185,290"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'ARII', '52.1900000', '52.2600000', '52.1900000', '52.2600000')">
<area shape="rect" coords="11,36,97,163" onmousemove="showOHLCTooltip(event,
'A', '[Fri. Apr 17, 2015 15:53:00]', 'ARII', '52.3100000', '52.3500000',
'52.2700000', '52.2700000')">
<area shape="rect" coords="551,467,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="463,467,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="374,467,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="286,467,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="198,447,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '1200.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="21,467,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="551,408,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '3154.0000000')">
<area shape="rect" coords="463,459,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '600.0000000')">
<area shape="rect" coords="374,461,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '500.0000000')">
<area shape="rect" coords="286,467,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="198,467,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '200.0000000')">
<area shape="rect" coords="21,465,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '300.0000000')">
<area shape="rect" coords="551,467,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="463,467,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="374,467,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="286,453,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '900.0000000')">
<area shape="rect" coords="198,467,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="21,467,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '0.0000000')">
Thanks, Randy, and please don't put this on top burner. I've learned a
bunch about how the SMF function works
Pete A
<http://www.ttp-s.com/> TtP-S Investing
http://www.barchart.com/chart.php?sym=ARII
<http://www.barchart.com/chart.php?sym=ARII&style=technical&template=&p=I&d=
L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&i
ndicators=&addindicator=&submitted=1&fpage=&txtDate>
&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&e
vnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=
&txtDate=
However, many minutes are missing? Maybe there has to be trading volume
during that minute?
Here's one that doesn't work. I may well have something wrong, but the same
format works for other tickers.
=smfConvertData(smfWord(RCHGetWebData("http://www.barchart.com/chart.php?sym
=ARII&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&
g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&f
page=&txtDate=","Fri. Apr 17, 2015 12:03:00",100),4,"', '"))
Note that I'm asking for 12:03:00. See below to see that it is returning
15:53:00 to 15:58:00
There is time shifting going on, but seems to be an adjustment for PDT,
shifting to EDT at 15:xx time. What makes NO sense to me, is that it is
doing the minutes xx:53:xx to xx:59:xx when I ask for xx:03:xx
I think you might be right.there just isn't a trade at that time (thinly
traded stocks). OTOH, there is an example that has 000 volume, but still
quotes prices (15:53:00).
See yellow highlight below. But maybe you can shed light on the time issues.
And here's the data from the page retrieved:
<area shape="rect" coords="453,131,539,259"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'ARII', '52.2400000', '52.2900000', '52.2100000', '52.2100000')">
<area shape="rect" coords="364,68,450,211"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'ARII', '52.2400000', '52.3300000', '52.2400000', '52.2600000')">
<area shape="rect" coords="276,20,362,131"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'ARII', '52.2900000', '52.3600000', '52.2900000', '52.3000000')">
<area shape="rect" coords="188,115,274,211"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'ARII', '52.2400000', '52.3000000', '52.2400000', '52.3000000')">
<area shape="rect" coords="99,179,185,290"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'ARII', '52.1900000', '52.2600000', '52.1900000', '52.2600000')">
<area shape="rect" coords="11,36,97,163" onmousemove="showOHLCTooltip(event,
'A', '[Fri. Apr 17, 2015 15:53:00]', 'ARII', '52.3100000', '52.3500000',
'52.2700000', '52.2700000')">
<area shape="rect" coords="551,467,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="463,467,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="374,467,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="286,467,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="198,447,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '1200.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="21,467,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="551,408,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '3154.0000000')">
<area shape="rect" coords="463,459,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '600.0000000')">
<area shape="rect" coords="374,461,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '500.0000000')">
<area shape="rect" coords="286,467,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="198,467,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '200.0000000')">
<area shape="rect" coords="21,465,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '300.0000000')">
<area shape="rect" coords="551,467,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="463,467,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="374,467,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="286,453,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '900.0000000')">
<area shape="rect" coords="198,467,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="21,467,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '0.0000000')">
Thanks, Randy, and please don't put this on top burner. I've learned a
bunch about how the SMF function works
Pete A
<http://www.ttp-s.com/> TtP-S Investing
Sat Apr 18, 2015 12:48 pm (PDT) . Posted by:
"Pete A" option2z
ARGGGHHHH. Do you ever wish you'd waited for one more experiment before
sending? I do. Please don't waste time with the stuff below.
I cannot repeat the stuff below, but when I created a link directly to what
I'm after, I get completely different results
And it bears out your (Randy's) thought that they don't show quotes for
certain minutes (maybe because of no activity, not sure). Here's a snippit
of the ARII for that period and it shows missing data for lots of minutes.
For Query:
=smfConvertData(smfWord(RCHGetWebData("http://www.barchart.com/chart.php?sym
=ARII&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&
g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&f
page=&txtDate=","Fri. Apr 17, 2015 12:03:00",100),4,"', '"))
These are the Price Records (note there is NO xx:03:xx price record, but
there IS an 05. And the same query with 05 works as expected)
<area shape="rect" coords="16,67,20,90" onmousemove="showOHLCTooltip(event,
'A', '[Fri. Apr 17, 2015 12:08:00]', 'ARII', '52.5300000', '52.5300000',
'52.4700000', '52.5100000')">
<area shape="rect" coords="11,34,15,39" onmousemove="showOHLCTooltip(event,
'A', '[Fri. Apr 17, 2015 12:05:00]', 'ARII', '52.6100000', '52.6100000',
'52.6100000', '52.6100000')">
These are the Volume Records:
<area shape="rect" coords="150,467,153,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 13:05:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="144,467,147,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 13:03:00]',
'Volume', '0.0000000')">
Note that my requested 03 is one of the missing ones in the price data.
=smfConvertData(smfWord(RCHGetWebData("http://www.barchart.com/chart.php?sym
=ARII&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&
g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&f
page=&txtDate=","Fri. Apr 17, 2015 12:05:00",100),4,"', '"))
Returns the price as 52.61 as it should.
SO, it IS true that price is not reported for every minute, but NOT because
of volume being zero. (In the example above, the 05 also has a zero volume,
but shows the price record. No idea WHY they skip some minutes.
SIGH. Fun as this is, please close this discussion unless you have a good
way of just taking the nearest quote.
Pete A
<http://www.ttp-s.com/> TtP-S Investing
From: Pete A [mailto:optonzz@outlook.com]
Sent: Saturday, April 18, 2015 12:20 PM
To: 'smf_addin@yahoogroups.com'
Subject: Re: How to lookup a stock price given Ticker, Date and Time
RE: I was able to get a 1 minute chart for ARII:
http://www.barchart.com/chart.php?sym=ARII
<http://www.barchart.com/chart.php?sym=ARII&style=technical&template=&p=I&d=
L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&i
ndicators=&addindicator=&submitted=1&fpage=&txtDate>
&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&e
vnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=
&txtDate=
However, many minutes are missing? Maybe there has to be trading volume
during that minute?
Here's one that doesn't work. I may well have something wrong, but the same
format works for other tickers.
=smfConvertData(smfWord(RCHGetWebData("http://www.barchart.com/chart.php?sym
=ARII
<http://www.barchart.com/chart.php?sym=ARII&style=technical&template=&p=I&d=
L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&i
ndicators=&addindicator=&submitted=1&fpage=&txtDate=>
&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&e
vnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=
&txtDate=","Fri. Apr 17, 2015 12:03:00",100),4,"', '"))
Note that I'm asking for 12:03:00. See below to see that it is returning
15:53:00 to 15:58:00
There is time shifting going on, but seems to be an adjustment for PDT,
shifting to EDT at 15:xx time. What makes NO sense to me, is that it is
doing the minutes xx:53:xx to xx:59:xx when I ask for xx:03:xx
I think you might be right.there just isn't a trade at that time (thinly
traded stocks). OTOH, there is an example that has 000 volume, but still
quotes prices (15:53:00).
See yellow highlight below. But maybe you can shed light on the time issues.
And here's the data from the page retrieved:
<area shape="rect" coords="453,131,539,259"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'ARII', '52.2400000', '52.2900000', '52.2100000', '52.2100000')">
<area shape="rect" coords="364,68,450,211"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'ARII', '52.2400000', '52.3300000', '52.2400000', '52.2600000')">
<area shape="rect" coords="276,20,362,131"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'ARII', '52.2900000', '52.3600000', '52.2900000', '52.3000000')">
<area shape="rect" coords="188,115,274,211"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'ARII', '52.2400000', '52.3000000', '52.2400000', '52.3000000')">
<area shape="rect" coords="99,179,185,290"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'ARII', '52.1900000', '52.2600000', '52.1900000', '52.2600000')">
<area shape="rect" coords="11,36,97,163" onmousemove="showOHLCTooltip(event,
'A', '[Fri. Apr 17, 2015 15:53:00]', 'ARII', '52.3100000', '52.3500000',
'52.2700000', '52.2700000')">
<area shape="rect" coords="551,467,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="463,467,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="374,467,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="286,467,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="198,447,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '1200.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="21,467,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="551,408,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '3154.0000000')">
<area shape="rect" coords="463,459,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '600.0000000')">
<area shape="rect" coords="374,461,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '500.0000000')">
<area shape="rect" coords="286,467,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="198,467,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '200.0000000')">
<area shape="rect" coords="21,465,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '300.0000000')">
<area shape="rect" coords="551,467,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="463,467,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="374,467,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="286,453,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '900.0000000')">
<area shape="rect" coords="198,467,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="21,467,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '0.0000000')">
Thanks, Randy, and please don't put this on top burner. I've learned a
bunch about how the SMF function works
Pete A
<http://www.ttp-s.com/> TtP-S Investing
sending? I do. Please don't waste time with the stuff below.
I cannot repeat the stuff below, but when I created a link directly to what
I'm after, I get completely different results
And it bears out your (Randy's) thought that they don't show quotes for
certain minutes (maybe because of no activity, not sure). Here's a snippit
of the ARII for that period and it shows missing data for lots of minutes.
For Query:
=smfConvertData(smfWord(RCHGetWebData("http://www.barchart.com/chart.php?sym
=ARII&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&
g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&f
page=&txtDate=","Fri. Apr 17, 2015 12:03:00",100),4,"', '"))
These are the Price Records (note there is NO xx:03:xx price record, but
there IS an 05. And the same query with 05 works as expected)
<area shape="rect" coords="16,67,20,90" onmousemove="showOHLCTooltip(event,
'A', '[Fri. Apr 17, 2015 12:08:00]', 'ARII', '52.5300000', '52.5300000',
'52.4700000', '52.5100000')">
<area shape="rect" coords="11,34,15,39" onmousemove="showOHLCTooltip(event,
'A', '[Fri. Apr 17, 2015 12:05:00]', 'ARII', '52.6100000', '52.6100000',
'52.6100000', '52.6100000')">
These are the Volume Records:
<area shape="rect" coords="150,467,153,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 13:05:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="144,467,147,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 13:03:00]',
'Volume', '0.0000000')">
Note that my requested 03 is one of the missing ones in the price data.
=smfConvertData(smfWord(RCHGetWebData("http://www.barchart.com/chart.php?sym
=ARII&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&
g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&f
page=&txtDate=","Fri. Apr 17, 2015 12:05:00",100),4,"', '"))
Returns the price as 52.61 as it should.
SO, it IS true that price is not reported for every minute, but NOT because
of volume being zero. (In the example above, the 05 also has a zero volume,
but shows the price record. No idea WHY they skip some minutes.
SIGH. Fun as this is, please close this discussion unless you have a good
way of just taking the nearest quote.
Pete A
<http://www.ttp-s.com/> TtP-S Investing
From: Pete A [mailto:optonzz@outlook.com]
Sent: Saturday, April 18, 2015 12:20 PM
To: 'smf_addin@yahoogroups.com'
Subject: Re: How to lookup a stock price given Ticker, Date and Time
RE: I was able to get a 1 minute chart for ARII:
http://www.barchart.com/chart.php?sym=ARII
<http://www.barchart.com/chart.php?sym=ARII&style=technical&template=&p=I&d=
L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&i
ndicators=&addindicator=&submitted=1&fpage=&txtDate>
&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&e
vnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=
&txtDate=
However, many minutes are missing? Maybe there has to be trading volume
during that minute?
Here's one that doesn't work. I may well have something wrong, but the same
format works for other tickers.
=smfConvertData(smfWord(RCHGetWebData("http://www.barchart.com/chart.php?sym
=ARII
<http://www.barchart.com/chart.php?sym=ARII&style=technical&template=&p=I&d=
L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&evnt=1&late=1&o1=&o2=&o3=&sh=100&i
ndicators=&addindicator=&submitted=1&fpage=&txtDate=>
&style=technical&template=&p=I&d=L&im=1&sd=&ed=&size=M&log=0&t=BAR&v=1&g=1&e
vnt=1&late=1&o1=&o2=&o3=&sh=100&indicators=&addindicator=&submitted=1&fpage=
&txtDate=","Fri. Apr 17, 2015 12:03:00",100),4,"', '"))
Note that I'm asking for 12:03:00. See below to see that it is returning
15:53:00 to 15:58:00
There is time shifting going on, but seems to be an adjustment for PDT,
shifting to EDT at 15:xx time. What makes NO sense to me, is that it is
doing the minutes xx:53:xx to xx:59:xx when I ask for xx:03:xx
I think you might be right.there just isn't a trade at that time (thinly
traded stocks). OTOH, there is an example that has 000 volume, but still
quotes prices (15:53:00).
See yellow highlight below. But maybe you can shed light on the time issues.
And here's the data from the page retrieved:
<area shape="rect" coords="453,131,539,259"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'ARII', '52.2400000', '52.2900000', '52.2100000', '52.2100000')">
<area shape="rect" coords="364,68,450,211"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'ARII', '52.2400000', '52.3300000', '52.2400000', '52.2600000')">
<area shape="rect" coords="276,20,362,131"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'ARII', '52.2900000', '52.3600000', '52.2900000', '52.3000000')">
<area shape="rect" coords="188,115,274,211"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'ARII', '52.2400000', '52.3000000', '52.2400000', '52.3000000')">
<area shape="rect" coords="99,179,185,290"
onmousemove="showOHLCTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'ARII', '52.1900000', '52.2600000', '52.1900000', '52.2600000')">
<area shape="rect" coords="11,36,97,163" onmousemove="showOHLCTooltip(event,
'A', '[Fri. Apr 17, 2015 15:53:00]', 'ARII', '52.3100000', '52.3500000',
'52.2700000', '52.2700000')">
<area shape="rect" coords="551,467,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="463,467,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="374,467,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="286,467,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="198,447,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '1200.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="21,467,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="551,408,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '3154.0000000')">
<area shape="rect" coords="463,459,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '600.0000000')">
<area shape="rect" coords="374,461,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '500.0000000')">
<area shape="rect" coords="286,467,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="198,467,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '200.0000000')">
<area shape="rect" coords="21,465,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '300.0000000')">
<area shape="rect" coords="551,467,616,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:59:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="463,467,528,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:58:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="374,467,439,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:57:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="286,453,351,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:56:00]',
'Volume', '900.0000000')">
<area shape="rect" coords="198,467,263,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:55:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="109,467,174,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:54:00]',
'Volume', '0.0000000')">
<area shape="rect" coords="21,467,86,471"
onmousemove="showStudyTooltip(event, 'A', '[Fri. Apr 17, 2015 15:53:00]',
'Volume', '0.0000000')">
Thanks, Randy, and please don't put this on top burner. I've learned a
bunch about how the SMF function works
Pete A
<http://www.ttp-s.com/> TtP-S Investing
Sat Apr 18, 2015 1:17 pm (PDT) . Posted by:
rr76012
Hello Climbermel,
Do you know of a rchgetelementnumber # for getting the % Growth Rate -- Dividends (5-Year Annual Average) -- Company?
I can not find one.
thanks,
rr76012
Do you know of a rchgetelementnumber # for getting the % Growth Rate -- Dividends (5-Year Annual Average) -- Company?
I can not find one.
thanks,
rr76012
Sat Apr 18, 2015 1:57 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Try element #13674 from Reuters...
On Sat, Apr 18, 2015 at 1:17 PM, rr76012@... wrote:
>
> Do you know of a rchgetelementnumber # for getting the % Growth Rate --
> Dividends (5-Year Annual Average) -- Company?
>
> I can not find one.
>
>
On Sat, Apr 18, 2015 at 1:17 PM, rr76012@... wrote:
>
> Do you know of a rchgetelementnumber # for getting the % Growth Rate --
> Dividends (5-Year Annual Average) -- Company?
>
> I can not find one.
>
>
Sat Apr 18, 2015 2:24 pm (PDT) . Posted by:
rr76012
4/18/2015
Re: SmfUpdateDownloadTable - Sample
Hello Randy,
To run the macro on your SmfUpdateDownload Table - you use = Ctrl+Shift+J to update table.
How does one - STOP - the update right in the middle of updating, what command do you use?
I sometimes prematurely press the ctrl+shift+J before I am ready.
Thank you.
rr76012.
Re: SmfUpdateDownloadTa
Hello Randy,
To run the macro on your SmfUpdateDownload Table - you use = Ctrl+Shift+J to update table.
How does one - STOP - the update right in the middle of updating, what command do you use?
I sometimes prematurely press the ctrl+shift+J before I am ready.
Thank you.
rr76012.
Sat Apr 18, 2015 4:26 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
I've not found a reliable way to stop VBA processing. In older versions of
EXCEL, Ctrl+Break and sometimes ESC would stop it from running. But they no
longer work for me in EXCEL 2007.
On Sat, Apr 18, 2015 at 2:24 PM, rr76012@... wrote:
>
> Re: SmfUpdateDownloadTable - Sample
>
> To run the macro on your SmfUpdateDownload Table - you use = Ctrl+Shift+J
> to update table.
>
> How does one - STOP - the update right in the middle of updating, what
> command do you use?
>
> I sometimes prematurely press the ctrl+shift+J before I am ready.
>
>
EXCEL, Ctrl+Break and sometimes ESC would stop it from running. But they no
longer work for me in EXCEL 2007.
On Sat, Apr 18, 2015 at 2:24 PM, rr76012@... wrote:
>
> Re: SmfUpdateDownloadTa
>
> To run the macro on your SmfUpdateDownload Table - you use = Ctrl+Shift+J
> to update table.
>
> How does one - STOP - the update right in the middle of updating, what
> command do you use?
>
> I sometimes prematurely press the ctrl+shift+J before I am ready.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar