|
PureBytes Links
Trading Reference Links
|
Take the attached test.iqy and put it in your web queries folder. Then
in excel from Data/Get External Data/Run Web Query choose the
test.iqy file and it will load the file for 990312 into the
spreadsheet.
The contents of Test.iqy are:
WEB
1
http://router.minot.com/~bohl/history/990312
I'm assuming that the 990312 will have to be changed upon each use. If
this is the case then I can write you a macro that will allow you to
enter the appropriate date and then it will build the iqy file and
then execute the query which will load the sheet.
I presume that after the above then all except corn will have to be
discarded?
Dale
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Walter Lake
> Sent: Saturday, March 13, 1999 8:56 PM
> To: Metastock bulletin board
> Subject: downloads
>
>
> Hi Dale
>
> Thanks for your email
>
> By synchronous, I mean that the code does not proceed past
> the statement
> until the transfer is complete. Asynchronous transfer
> refers to issuing the
> request then moving on to the next line of code.
> Synchronous is the simpler
> code but I believe is slower because concurrent transfers
> don't occur.
>
> As far as my own download needs, my commodities downloader
> stopped working
> and I need to download historical and end-of-day Corn
> contracts etc. C=
> corn, 0= year 2000, K = May
>
> Contract Months are
> Dec (Z), Mar (H), May (K), Jul (N), Sep (U)
>
> C0H 990312 2500 2516 2500 2500 1551 9328 5
> C0K 990312 2552 2560 2546 2552 25 683 5
> C0N 990312 2584 2596 2576 2582 206 2343 5
> C0Z 990312 2580 2584 2580 2582 176 2061 5
> C9H 990312 2170 2176 2154 2156 4570 5128 5
> C9K 990312 2244 2246 2220 2226 33167 134420 5
> C9N 990312 2296 2304 2274 2290 10713 102617 5
> C9U 990312 2360 2366 2340 2350 924 24124 5
> C9Z 990312 2440 2444 2424 2426 10047 70082 5
>
> either from
> http://router.minot.com/~bohl/index.html
> http://router.minot.com/~bohl/history/990312
>
> CH99,d,03/12/99,2170,2176,2154,2156,,
> CK99,d,03/12/99,2244,2246,2220,2226,,
> CN99,d,03/12/99,2296,2304,2274,2290,,
> CU99,d,03/12/99,2360,2366,2340,2350,,
> CZ99,d,03/12/99,2440,2444,2424,2426,,
> CH00,d,03/12/99,2500,2516,2500,2500,,
> CK00,d,03/12/99,2552,2560,2546,2552,,
> CN00,d,03/12/99,2584,2596,2576,2582,,
> CZ00,d,03/12/99,2580,2584,2580,2582,,
>
> or from http://www.jackcarl.com/ascii/dailyhist.asc
>
>
> The ".igy" file listed at
> http://officeupdate.microsoft.com/excel/webquery/samples.htm
>
> only contains a few commodity markets (not corn) at
>
http://cnnfn.com/markets/commodities.html
So this is what I have to set up.
Other commodity markets can be added once the initial template is
organized.
Best regards
Walter
|