Minggu, 19 April 2015

[smf_addin] Digest Number 3385

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

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

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

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.
>
>

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.

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.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Poskan Komentar