Stock Database Manager Module (SDMDb)

The SDMDb module provides all the functions for you,
which handles all the data in your Stock Database.

SDM distinguishes between the three main data types:

Daily Data One bar for each trading day
(Accumulated to get for example monthly bars)
c:/sdm/data/daily
Intraday Data One bar for each trading minute
(Accumulated to get for example 10 minute bars)
c:/sdm/data/intra
Ticks One bar for each single trading tick
We have currently 1,048 Million Ticks available
See here for details
c:/sdm/data/ticks

To automate sequences SDM offers the command line Data manager (DataMgrC.exe).

Commands available:

DeleteData:Sym|Type| Delete all data for the specified symbol and type
(Example: Delete:MSFT|T
Download:{Sym|@Lst[/@LAST]}|Type|nBack Download new data of Type and nBack bars back
(Example: Download:@SP500/@LAST|I|1)
Exit Exits the program
Import:Sym|Type|File|[Range]|[TimeDiff]
Import data from other data formats
(Example: Import:ES|1 Min|d:/sdm/import/ES_20010212.csv||+3600
ImportRemove:Sym|Type|File|[Range]|[TimeDiff]
same as Import, but removes import file after sucessfull completion
InitBase:Folder Initialize new SDM database at specified location:
(Example: D:\SDM)
Login:Provider|username|password ogin to data provider
(Example: Login:MyTrack|usr1|mydata123
   
Quit Exit the program
PrintData:[-][!]{Sym|@ALL}|Type|[Range]|[File] Create text file with data from database in same place as data file.
- in front of the symbol/list  will only print the headers not each bar
! in from of the symbol will only print the overview for each symbol
Example: PrintData:-MSFT|I|8/1/2002 - 8/16/2002
creates: c:/sdm/data/Intra/M/MSFT.txt
If you sepecify an output file data will always be appended
@ALL will print all symbols for the specified data type
Refresh:{Sym|@Lst}|Type Refresh data for specified symbol of list and type
(Example: Refresh:@AMEX/@LAST|D   or  Refresh:MSFT|D)
   
   
   
   
   
   

Sym=Ticker Symbol
Type=Data Type (1 Min,Ticks,Daily)
@Lst=SYmbol List @IDX,@SP500,@NYSE,@AMEX,@NASDAQ

 

How to import from Trade Station:

Ticks: