|
PureBytes Links
Trading Reference Links
|
Ooops.. Forgot to attach Test.iqy
Dale
> -----Original Message-----
> From: owner-metastock@xxxxxxxxxxxxx
> [mailto:owner-metastock@xxxxxxxxxxxxx]On Behalf Of Dale Wingo
> Sent: Saturday, March 13, 1999 11:08 PM
> To: metastock@xxxxxxxxxxxxx
> Subject: RE: downloads
>
>
> 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
>
>
>
>
>
>
Attachment Converted: "c:\eudora\attach\Test.iqy"
|