SI
SI
discoversearch

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor.  We ask that you disable ad blocking while on Silicon Investor in the best interests of our community.  If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.
Non-Tech : Quote.com QCharts -- Ignore unavailable to you. Want to Upgrade?


To: Kayaker who wrote (14639)7/30/2001 4:26:14 PM
From: Patrick Slevin  Respond to of 17977
 
Yeah, sounds like the reason but it is not.

What happened is, they made it more restrictive. The program used to work fine the way I typed it in the earlier post. Now, however, it appears to get data like that from the Dow Industrials you have to precede the symbol with the word INDEX

Like this,

=QLink|Bars!'INDEX:INDU,D,25,DTOHLC'


So if you select a block like before (the 25 rows down, 6 column wide block such as A1 through F25) and then type in the above then hitting <CRTL><SHIFT><ENTER> will give you the array for the INDU for the past 25 days.

Seems like a lot of grief but it was changing the format to include the word "INDEX:" that was the culprit.

Thanks for helping me walk through it.



To: Kayaker who wrote (14639)7/30/2001 4:32:54 PM
From: Patrick Slevin  Read Replies (1) | Respond to of 17977
 
Here is a sample.
--------------------------
______________Open____High____Low_____Close
06/25/01 09:30 10607.88 10644.24 10468.12 10504.22
06/26/01 09:30 10497.30 10534.21 10394.72 10472.48
06/27/01 09:30 10470.35 10531.19 10408.00 10434.84
06/28/01 09:30 10438.73 10646.45 10438.66 10566.21
06/29/01 09:30 10565.27 10605.59 10491.60 10502.40
07/02/01 09:30 10504.95 10638.87 10467.38 10593.72
07/03/01 09:30 10588.89 10595.13 10531.52 10571.11
07/05/01 09:30 10566.23 10567.64 10461.14 10479.86
07/06/01 09:30 10476.73 10476.73 10220.14 10252.68
07/09/01 09:30 10253.62 10323.11 10222.24 10299.40
07/10/01 09:30 10300.82 10335.63 10162.71 10175.64
07/11/01 09:30 10174.70 10274.02 10120.89 10241.02
07/12/01 09:30 10269.31 10496.64 10269.31 10478.99
07/13/01 09:30 10478.39 10549.76 10432.60 10539.06
07/16/01 09:30 10537.98 10568.69 10446.60 10472.12
07/17/01 09:30 10468.62 10628.48 10438.66 10606.39
07/18/01 09:30 10594.54 10594.54 10480.88 10569.83
07/19/01 09:30 10574.33 10679.12 10523.92 10610.00
07/20/01 09:30 10606.19 10606.19 10529.25 10576.65
07/23/01 09:30 10576.92 10595.40 10419.71 10424.42
07/24/01 09:30 10423.80 10423.80 10203.69 10241.12
07/25/01 09:30 10241.75 10405.67 10241.19 10405.67
07/26/01 09:30 10403.46 10459.02 10284.09 10455.63
07/27/01 09:30 10451.89 10460.12 10375.29 10416.67
07/30/01 09:30 10418.68 10440.48 10361.45 10401.72

Have a good trip!