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
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 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@
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
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
>
>
>
>
=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@
>
> 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 :)
>
>
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