|
PureBytes Links
Trading Reference Links
|
In Step 12 Equis Support suggested to set the Source Type: to ASCII.
By default, ASCII for Type: will not accept semi-colons ??
Instead, you must use commas ??
Should Equis Support have advised you to also use the Excel option for Source Type:
than (most likely) your CSV-file would have converted, eg being Office97-comp. and so on
but..................in the end you too have had to find out that for format and being compatable
these files are not ever one and the same.
Ever since the DOS-era, CSV stands for Comma Separated Values.
Meaning what it implies: commas dividing the file's data sections("values").
However, I was also surprised to see official Windows-comp. programs like Excel, Word
+ MetaStock not sticking by this official format for CSV-files (eg the comma for separator
and NOT the semi-colon).
And hardly any software program will give 'true commas' for results, in fact most programs
most of the time (thus not always) will expect semi-colons, and on the side will "also"
(but not always) accept "true commas".
Confusing ???? YES INDEED !!!!!
SeveraI times I have forwarded this bug to the Microsoft + Equis Support dep.'s,
but have never received a very satisfying answer. "It is up the manufacturers"
is all that they've had to say for a solution + the answer to my questioning.
-------------------------------------------------
Adjusting the files.
I was going to send you an additional follow-up mail, explaining that there is an easy
work-around for adjusting these files, eg by-passing the use of Excel, and noticed in your
reply mail that you are also capable to use the "Find+Replace"-routine in your Q-program
and also very easy for me to do here in Word97 (for the Downloader files+in general) and
in Excel97.
Downloader Data Files are TAB-dillimited.
The Data copied (the Clipboard contents) from the Downloader's Data File
is TAB-dillimited (see also your original "test1.txt"-file).
You too then can also immediatly 'gain' from this F+R routine when creating your
own 10min Downloader-ready-files, eg by NOT Pasting the Clipboard contents
to Excel but instead, by directly Pasting the contents to your Q-Program's file.
Than, when Downloader Data is Pasted into your Q-Program, Select by dragging the
mousepointer over the blanc white area between any 2 columns, and click Copy
(or "CTRL+C").
Next, open up your F+R dialog window and Paste this copied selection (eg the
invisable "tab") into the Find+Replace dialog window.
-First place the mousepointer in the Find box and than hit the "CTRL+V" keys.
-Second, switch to and place the mousepointer in the Replace box and type a ","
eg the comma-character.
-Third, Click to "Replace All" (eg that is one of the options' button-name that is
available in Word97).
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying and
note the new address change. Also for my Homepage
http://home.planet.nl/~anthmaas
----- Original Message -----
From: Glen Wallace
To: A.J. Maas
Sent: maandag 13 september 1999 3:42
Subject: Re: Data conversion - a solution?
> Ton:
>
> It worked perfectly. Curiously though, your .csv file was semi-colon
> delimited. This was easy to change to commas with a global
> search-and-replace.
>
> Joe Ehardt kindly sent me the intraday data I was missing, but thanks for
> the offer.
>
> Again, thanks for all your help and your suggestions.
>
> Glen
>
>
> ----- Original Message -----
> From: A.J. Maas
> To: Glen Wallace
> Sent: September 12, 1999 17:12
> Subject: Re: Data conversion - a solution?
>
> > Creating the CSV-file worked like a charm (using the instructions).
> >
> > The reason why it will not Paste in the Downloader is that there is indeed
> > (and naturaly) the Time column to be considdered, eg present in the
> > txt-file and thus also present in the Clipboard, but which is
> > (here <in my Downloader EOD> absent, eg and) absent in the all other
> > common Downloader's Data Files.
> >
> > Obviously the Downloader will automaticaly give your (new) security's Data
> > File a 10min interval, once the Map1.csv file has been converted. I
> suspect
> > it will detect the 10min interval "automaticaly", else you will be asked
> to
> > provide for the correct interval-factor.
> >
> > Let me know how you went...............
> >
> > Regarding your question on receiving the SP500+T-Bond data, please provide
> > the full Reuters tickers for these contracts and I will try to download
> > them along when I log in to update my RTD data.
> >
> > Regards,
> > Ton Maas
> > ms-irb@xxxxxxxxxxxxxxxx
> > Dismiss the ".nospam" bit (including the dot) when replying and
> > note the new address change. Also for my Homepage
> > http://home.planet.nl/~anthmaas
> >
> >
> > ----- Original Message -----
> > From: Glen Wallace
> > To: A.J. Maas
> > Sent: zondag 12 september 1999 21:35
> > Subject: Re: Data conversion - a solution?
> >
> >
> > > Ton:
> > >
> > > It was close, but not quite. The 10-minute data copied nicely to the new
> > > Downloader file, but the time for each bar didn't paste for some reason
> > > (although it gets copied when you dump the data into a text file). Oh
> > > well....
> > >
> > > Attached is a text file created by right clicking and copying 10-minute
> bars
> > > created from tick data. Below are Equis's step-by-step instructions. I
> > > have completed steps 1 through 6, and if you could do steps 7 through 11
> > > and return the file to me, I'll finish it off.
> > >
> > > Thanks a lot. I appreciate the help.
> > >
> > >
> > > 1. Start MetaStock.
> > > 2. Display a tick chart.
> > > 3. Click Format|X-Axis.
> > > 4. Click the Compression tab.
> > > 5. Select Intra-day and type 5, 10 or 30 into the minute field and
> click
> > > OK. The chart will now appear as a 5, 10 or 30 minute chart.
> > > 6. Right click the 5, 10 or 30 minute price graph and select Copy
> from
> > > the menu that appears.
> > > 7. Start Excel.
> > > 8. Right click an empty cell in The Excel fill and select Paste. The
> 5,
> > > 10 or 30 minute data will appear in the Excel file.
> > > 9. Click File|Save As.
> > > 10. Set the Save As Type field to Comma Separated (CSV).
> > > 11. Type a name for the file into the name field and click Save.
> > > 12. Then use the ASCII to MetaStock conversion in The DownLoader to
> convert
> > > the CSV file into a MetaStock 5, 10 or 30 minute file.
> > >
> > >
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: A.J. Maas
> > > To: <metastock@xxxxxxxxxxxxx>
> > > Sent: September 11, 1999 13:37
> > > Subject: Re: Data conversion - a solution?
> > >
> > >
> > > > With the faq printed below and replacing the EOD-sequence(d to w) by
> your
> > > RT-sequence
> > > > (RT to 5min or RT to 10min) you should get away with it, eg
> improvising a
> > > bit that is.
> > > >
> > > > What can be pasted in Excel stemming from Downloader Data Files can
> also
> > > be pasted
> > > > (back) into the Downloader, eg create a few new (test-)securities and
> > > start copying+pasting.
> > > >
> > > > (Else, feel free to send the file incl. the instructions.......)
> > > >
> > > > Regards,
> > > > Ton Maas
> > > > ms-irb@xxxxxxxxxxxxxxxx
> > > > Dismiss the ".nospam" bit (including the dot) when replying and
> > > > note the new address change. Also for my Homepage
> > > > http://home.planet.nl/~anthmaas
> > > >
> > > >
> > > > How can I take a daily data file and make a new weekly data file out
> of it
> > > without destroying the daily file?
> > > >
> > > > msg00045.htm
> > > >
> > > > To do the following you must be using MetaStock 5.1 and The DownLoader
> 4.1
> > > or higher.
> > > >
> > > > Open the security in MetaStock and change the compression to Weekly.
> > > > Right Click on the X-Axis, select Properties and write down the first
> date
> > > loaded, then close X-Axis Properties.
> > > > Right click on the Security's weekly price bars and select Copy.
> > > > Open The DownLoader.
> > > > Click File | New | Security
> > > > Enter the Name and Symbol.
> > > > Select Weekly as the periodicity and enter in the first date you wrote
> > > down from above.
> > > > If the original daily file included Open and Open Interest make sure
> these
> > > two boxes are checked. If not un-check them.
> > > > Click the Data Sheet button to open up the data sheet window.
> > > > Make sure the cell cursor is positioned in the upper left cell.
> > > > Click on the Edit menu and select Paste. This will paste the weekly
> prices
> > > into the new security.
> > > > Close the security and select Yes to save changes.
> > > > You will now have a new weekly data file and your daily data file will
> > > remain intact.
> > > >
> > >
> > >
> > >
> > >
> >
> >
>
>
>
>
>
|