|
PureBytes Links
Trading Reference Links
|
> I'll figure out something more straight forward. Hopefully by V8.5
Now you have your daily returning tedious Convert task automated.
Your (automating) wish has come tru, see below (and attached zip).
Since you are comfortable with VBA and Excel, will leave that part
in automating (of the nightly returning conversion) up to yourselves.
Script can be used by others as well, eg just Remark out the not required lines
(and/or change the here used names and locations).
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying.
Homepage http://home.planet.nl/~anthmaas
----- Original Message -----
From: "Walter Lake" <wlake@xxxxxxxxx>
To: <metastock@xxxxxxxxxxxxx>
Sent: maandag 20 maart 2000 1:45
Subject: Re: computers
> Hi Ton
>
> Column A ... the Name ... was not included.
>
> I copied Columns B to H (<Ticker> to <Vol>) from Excel2000 to a separate XL
> workbook and saved as ".csv" file.
>
> I opened the CSV file with "Quick View Plus" and copied to Notebook ".txt"
> file.
>
> Metastock opened it without "sneezing" or errors.
>
> Maybe, when I am feeling more charitable towards this program, I'll figure
> out something more straight forward. Hopefully by V8.5
>
> Thanks for all of your help and great emails over the years.
>
> Best regards
>
> Walter
=====================///////////////////////========================
'Creating a Task for the TASK Manager
'Double click the TASK Manager's Icon in the TaskBar's SysTray
' click Add New Task
' Name The TASK Manager's task + task's scheme's + settings:
' TAB Task: Run: C:\Windows\Batches\MyFunds.bat
' Path: C:\Windows\Batches
' Remarks: CANFDS
' check On(scheduled task starts on the set time)
' TAB Scheme: Schedule task: Weekly
' Start time: 20:30
' Run task weekly: Every: 1 week on check monday
' check tuesday
' check wednesday
' check thursday
' check friday
' TAB Settings: {check your preferences here}
'Click OK
'----------------------------------------------------------
'Creating the BATCH file
'click Start|Programs|Windows Explorer
'click C:
'switch to the Windows Explorer's right pane
'doubleclick the Windows folder
'scroll down to the bottom of the Windows folder
'in a blank area do 1x rightclick
'in the Small Context Menu click New
' click Folder
'name the new folder Batches
'click 1x somewhere in a blank area to have the name accepted
'doubleclick the new Batches folder
'in a blank area do 1x rightclick
'in the Small Context Menu click New
' click Textdocument
'name the new textdocument MyFunds.txt
'click 1x somewhere in a blank area to have the name accepted
'doubleclick the new MyFunds.txt file (file will be run in NotePad)
'for the BATCH file's command lines, type the following lines that
'are below printed between the breaking (horizontal) lines, thus do
'not place the lines themselves in the BATCH file as well as that
'you must NOT place the upper commas, eg the remark ' character at
'the first position on the lines.
'========================================================
'ECHO OFF
' REM using the ECHO OFF command will prefent the display of the
' REM results of a BATCH file's executed command and the REM command
' REM is used for placing comments in the BATCH file and on execution
' REM of the file will be ignored.
'CALL C:\PROGRA~1\OUTLOO~1\MSIMN.EXE
' REM using the CALL command will have the batchfile wait until
' REM the OUTLOOK EXPRESS(OE) program has been closed by user, before
' REM continuing executing the next command line
'CALL EXCEL C:\temp\data\Mar16#1.dat
' REM the C:\temp\data and the Mar16#1.dat are here fixious names for
' REM your datafile's drive+path+folder+file names and should be
' REM replaced with your datafile's actual drive+path+folder+file name
' REM and using the CALL command will have the batchfile wait until
' REM the EXCEL program has been closed by user, thus giving user the
' REM to run the macro in EXCEL
'REN C:\temp\data\*.CSV *.TXT
' REM using the REN command and the astrix * character will have all
' REM the CSV files (Colon Separated Values) for extension be renamed
' REM to TXT files (Textdocuments)
'C:\Windows\ScriptIT\Scriptit.exe MyFndScr.txt
' REM using this command line is used to have the ScripIT program to run
' REM this file you are now reading.
' REM To download the ScriptIT-program see my Homepage
' REM http://home.planet.nl/~anthmaas
'========================================================
'
'Finaly (and still in NotePad) after creating the BATCH file
'click Close
'click OK when asked to Save the changes (made to the BATCH file)
'back in the Windows Explorer and in the right pane
'rightclick the file MyFunds.txt
'rename the MyFunds.txt file to MyFunds.bat
'close the Windows Explorer
'----------------------------------------------------------
'Creating the SCRIPIT file
'All the statement's lines below are the script's commands in the above,
'in the BATCH procedure, mentioned MyFndScr.txt script.
'Statements that start with the [SCRIPT] section-marker, and of which
'most that are used here are for sending the keystrokes to
'the Downloader's Convert session.
'Note that any lines placed above the [SCRIPT] marker, are ignored
'by the script, as well as that the uppercase commas ' characters
'remark out any line's comments, as would the REM command do in BATCH
'and in INI (script) files.
'
[SCRIPT]
REM When this script is started, I go out to make myself a cup of
REM coffee and when finished (coffee+script), only to return to a fresh,
REM new and clean desktop!!
REM
run=c:\equis\dlwin\dlwin.exe
REM Pause
The DownLoader=
REM Tools
The DownLoader=!t
REM Convert
The DownLoader=o
REM Source type ASCI
Convert Securities=as
Convert Securities=!f
REM Source folder
Convert Securities=C:\temp\data
Convert Securities=!n
Convert Securities=""*.txt""
REM Destination type MetaStock
Convert Securities=!y
Convert Securities=M
Convert Securities=!r
REM Destination folder
Convert Securities=C:\mydata\
Convert Securities=~
Conversion Report=~
REM Pause
The DownLoader=
The DownLoader=~winclose
REM End of Script
REM
REM Should you want MetaStock to open straight after
REM than remove each line below's first REM command
REM
REM run=c:\equis\mswin\mswin.exe
REM MetaStock=
REM MetaStock=!f
REM MetaStock=o
REM REM Display the Open dialog window
REM Open=
REM End of script
Attachment Converted: "f:\eudora\attach\MyFndScr.zip"
|