Backup Industry and sectoral classification data

[erukumk]

If i want to backup my industry classification data, backing up of broker.workspace file is sufficient? or any additional files are needed for a complete backup?

[Yogyatrader]

Run the below exploration and save the CSV file..

//Stock Information
Filter = Status("LastbarinRange");
SetOption("Nodefaultcolumns", True ); 
AddTextColumn(DateTimeFormat("%A %d %B %Y %H:%M:%S ", SelectedValue(DateTime())), "Date");
AddTextColumn( Interval(2), "Used TimeFrame", 1.2,colorDefault, colorDefault, 90);

//General Information
AddTextColumn( Name(), "Ticker Name", 1.2,colorDefault, colorDefault, 90);
AddTextColumn( FullName(), "Company Name", 1.2,colorDefault, colorDefault,90);
AddTextColumn( GetFnData("Alias"), "Alias",1,colorDefault, colorDefault, 90);//returns symbol alias - string) - 5.50 and above 
AddTextColumn( GetFnData("Address"), "Address",1,colorDefault, colorDefault, 90);//returns symbol address - string) - 5.50 and above 
AddTextColumn( GetFnData("Country"),"Country", 1,colorDefault, colorDefault, 90);//returns symbol country - string) - 5.60 and above 
AddTextColumn( GetFnData("Currency"), "Currency",1,colorDefault, colorDefault, 90);//returns full name of the symbol 
AddTextColumn( GetFnData("Webid"), "Web ID",1,colorDefault, colorDefault, 90);//returns full name of the symbol 
AddColumn(IsContinuous(), "Is Continuous");


//Categories
AddTextColumn( MarketID(Mode=1), "Market Name", 1.2,colorDefault, colorDefault,90);
AddColumn(MarketID(), "Market ID");
AddTextColumn( SectorID(Mode=1), "Sector Name", 1.2,colorDefault, colorDefault,90);
AddColumn(SectorID(), "Sector ID");
AddTextColumn( IndustryID(Mode=1), "Industry Name", 1.2,colorDefault, colorDefault,90);
AddColumn(IndustryID(), "Industry ID");
AddTextColumn( GicsID(0), "Gics Name", 1.2,colorDefault, colorDefault,90);
AddTextColumn( GicsID(1), "Gics Name", 1.2,colorDefault, colorDefault,90);
AddTextColumn( GicsID(2), "Gics Name", 1.2,colorDefault, colorDefault,90);
AddColumn(InGics(StrFormat("%02.0f", 10 ) ), "In Gics");
AddTextColumn( IcbID(0), "Icb Name", 1.2,colorDefault, colorDefault,90);
AddTextColumn( IcbID(1), "Icb Name", 1.2,colorDefault, colorDefault,90);
AddTextColumn( IcbID(2), "Icb Name", 1.2,colorDefault, colorDefault,90);
AddColumn(InIcb(StrFormat("%02.0f", 10 ) ), "In Icb");
AddColumn(IsFavorite(), "Is Favorite");
AddColumn(IsIndex(), "Is Index");
//Filter= InWatchListName( "My Hotlist" ) OR InWatchList( "My Second Hotlist" ); 
//Filter= InWatchList( 3 ) OR InWatchList( 5 );

//Contract Specification
AddColumn(RoundLotSize, "Lot Size");
AddColumn(MarginDeposit, "Margin Deposit");
AddColumn(TickSize, "Tick Size");
AddColumn(PointValue, "Point Value");


//Valuation

//Statistics
AddColumn( GetFnData("SharesOut"), "SharesOut",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("SharesFloat"), "SharesFloat",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("InsiderHoldPercent"), "InsiderHoldPercent",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("InstitutionHoldPercent"), "InstitutionHoldPercent",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("SharesShort"), "SharesShort",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("SharesShortPrevMonth"), "SharesShortPrevMonth",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("Beta"), "Beta",1,colorDefault, colorDefault, 90);
//Financial
AddColumn( GetFnData("EPS"),"EPS", 1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("EPSEstCurrentYear"), "EPSEstCurrentYear",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("EPSEstNextYear"), "EPSEstNextYear",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("EPSEstNextQuarter"), "EPSEstNextQuarter",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("ForwardEPS"), "ForwardEPS",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("BookValuePerShare"), "BookValuePerShare",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("PEGRatio"), "PEGRatio",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("ProfitMargin"), "ProfitMargin",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("OperatingMargin"), "OperatingMargin",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("OneYearTargetPrice"), "OneYearTargetPrice",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("ReturnOnAssets"), "ReturnOnAssets",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("ReturnOnEquity"), "ReturnOnEquity",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("QtrlyRevenueGrowth"), "QtrlyRevenueGrowth",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("GrossProfitPerShare"), "GrossProfitPerShare",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("SalesPerShare"), "SalesPerShare",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("EBITDAPerShare"), "EBITDAPerShare",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("QtrlyEarningsGrowth"), "QtrlyEarningsGrowth",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("OperatingCashFlow"), "OperatingCashFlow",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("LeveredFreeCashFlow"), "LeveredFreeCashFlow",1,colorDefault, colorDefault, 90);

//Dividend & Spllits
AddColumn( GetFnData("DividendPerShare"), "DividendPerShare",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("DividendPayDate"), "DividendPayDate",formatDateTimeISON,colorDefault, colorDefault, 90);
AddColumn( GetFnData("ExDividendDate"), "ExDividendDate",formatDateTimeISO,colorDefault, colorDefault, 90);
AddColumn( GetFnData("ForwardDividendPerShare"), "ForwardDividendPerShare",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("LastSplitRatio"), "LastSplitRatio",1,colorDefault, colorDefault, 90);
AddColumn( GetFnData("LastSplitDate"), "LastSplitDate",formatDateTime,colorDefault, colorDefault, 90);
AddColumn( GetFnData("DelistingDate"), "DelistingDate",formatDateTime,colorDefault, colorDefault, 90);//returns symbol delisting date (as datetime) - 5.70 and above 
AddColumn( GetFnData("PointValue"), "PointValue",1,colorDefault, colorDefault, 90);//returns symbols point value 

Later you can import using ASCII importer
Import from ASCII file (amibroker.com)

[Tomasz]

You need to read the manual:
https://www.amibroker.com/guide/h_workspace.html

and
https://www.amibroker.com/guide/x_files.html

The easiest way is just to copy entire database folder. At minimum you need broker.workspace and broker.master

[erukumk]

Thanks, i do backup regularly but i wanted to take a backup specifically of industry classification that way if something goes wrong after import, i can copy only those files rather than restoring the complete backup.

[Tomasz]

As I wrote: At minimum you need broker.workspace and broker.master