Sabtu, 18 April 2015

[smf_addin] Digest Number 3384

6 Messages

Digest #3384

Messages

Fri Apr 17, 2015 12:03 pm (PDT) . Posted by:

option2z

Randy,
Magician or wizard comes to mind. It just never occurred to me to reverse engineer a chart to obtain the price of a stock for a minute of a given day.


And more thanks for taking the time to not just outline, but hand over the solution. I'll tackle it this weekend!


Pete A

Fri Apr 17, 2015 7:22 pm (PDT) . Posted by:

option2z

Upon experimentation, I found that it APPEARS that there were some hard coded dates in the string. It worked for the 16th, but not the 17th. For the record, this simplified formula seems to do the trick (find a stock price at any minute for the previous 5 days): (D4 has the symbol, E4 the oddly formatted date/time, like:
Fri. Apr 17, 2015 10:57:00 )


=smfConvertData(smfWord(RCHGetWebData("http://www.barchart.com/chart.php?sym=" & D4 & "&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&fpage=&txtDate=",E4,100),4,"', '"))
Anyway, it works for me. A thousand thanks!
Pete A
---In smf_addin@yahoogroups.com, <optionzz@...> wrote :


Randy,
Magician or wizard comes to mind. It just never occurred to me to reverse engineer a chart to obtain the price of a stock for a minute of a given day.


And more thanks for taking the time to not just outline, but hand over the solution. I'll tackle it this weekend!


Pete A


Fri Apr 17, 2015 7:31 pm (PDT) . Posted by:

option2z

One more note. Just found that some stocks don't appear to have one minute quotes, for instance ARII only seems to go down to 5 minute. Nothing is TOO easy, is it :)
Pete A

Fri Apr 17, 2015 7:40 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

The "oddly formatted" date can be produced with:

=TEXT(E4,"ddd. mmm dd, yyyy hh:mm:ss")

...where E10 contains an EXCEL date/time value.

On Fri, Apr 17, 2015 at 7:22 PM, optionzz@... wrote:

> Upon experimentation, I found that it APPEARS that there were some hard
> coded dates in the string. It worked for the 16th, but not the 17th. For
> the record, this simplified formula seems to do the trick (find a stock
> price at any minute for the previous 5 days): (D4 has the symbol, E4 the
> oddly formatted date/time, like:
> Fri. Apr 17, 2015 10:57:00
>
> )
>
>
> =smfConvertData(smfWord(RCHGetWebData("
> http://www.barchart.com/chart.php?sym=" & D4 &
> "&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&fpage=&txtDate=",E4,100),4,"',
> '"))
> Anyway, it works for me. A thousand thanks!
> Pete A
> ---In smf_addin@yahoogroups.com, <optionzz@...> wrote :
>
> Randy,
>
> Magician or wizard comes to mind. It just never occurred to me to
> reverse engineer a chart to obtain the price of a stock for a minute of a
> given day.
>
>
> And more thanks for taking the time to not just outline, but hand over the
> solution. I'll tackle it this weekend!
>
>
> Pete A
>
>
>
>

Fri Apr 17, 2015 7:42 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

I was able to get a 1 minute chart for 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&indicators=&addindicator=&submitted=1&fpage=&txtDate=

However, many minutes are missing? Maybe there has to be trading volume
during that minute?

On Fri, Apr 17, 2015 at 7:31 PM, optionzz@outlook.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

> One more note. Just found that some stocks don't appear to have one
> minute quotes, for instance ARII only seems to go down to 5 minute.
> Nothing is TOO easy, is it :)
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar