How to Cleanup Metastock database

#2
if u mean cleanup then delete the data in the which ever drive u have stored or u mean that adjusting data then do follow this ,

Adjusting data for Stock Splits and Bonus

Warning: - Backup you data before you perform a split.

Before you can perform a split, you need to know information on the split such as the ex date and the ratio of the stock split. The required information can be obtained from the web sites of the stock exchanges

What is an ex-date?
The first day of the no-delivery period is the ex- date. If there is any corporate benefits such as rights, bonus, dividend announced for which book closure/record date is fixed, the buyer of the shares on or after the ex -date will not be eligible for the benefits.

What is a split?
Split is book entry wherein the face value of the share is altered to create more number of shares outstanding without calling for fresh capital or without altering the share capital account. For example if a company announces a two-way split, it means that a share of the face value of Rs.10 is split into two shares of face value Rs.five each and a person holding one share now holds two shares.

What is a bonus issue?
While investing in shares the motive is not only capital gains but also proportionate share of surplus generated from the operations once all other stakeholders have been paid. But the distribution of this surplus to shareholders seldom happens. Instead, this is transferred to the reserves and surplus account. If the reserves and surplus amount becomes too large, the company may transfer some amount from the reserves account to the share capital account by a mere book entry. This is done by increasing the number of shares outstanding and every shareholder is given bonus shares in a ratio called the bonus ratio and such an issue is called bonus issue. If the bonus ratio is 1:2, it means that for every two shares held, the shareholder is entitled to one extra share. Thus a shareholder holding two shares, post bonus holds three shares of the company.















Procedure for adjusting data for stock splits.
1. Start the Downloader for Windows

2. Click the File Menu and open the stock you want to adjust the data for


3. Select the Adjust menu and then click on Split


4. On clicking split, the split dialogue box will open.


First Date. This is first date in the datasheet.
Last Date. This is the day before the security's price changed or the last date BEFORE the split (ie the date before ex date.)
Ratio. The SPLIT ratio

5. Click OK to perform the split operation.








Procedure for adjusting the data for Bonus.
1. Obtain split ratio
2. Split ratio in case bonus is calculated as follows:-
Bonus Ratio A : B. Split ratio A+B : B
Example
Price of stock ABC before bonus Rs 100/-
If Bonus ratio is 7:3, split ratio will be 10:3
Price of stock ABC after adjustment for bonus will be Rs 30. ( 100*3/10).
3. Follow the procedure specified in Adjusting data for stock splits.
 
#3
if u mean cleanup then delete the data in the which ever drive u have stored or u mean that adjusting data then do follow this ,
.
Hi,
Thanks for reply.BTW By cleaning up I meant removing selected scripts which are not being traded currently, or removing those scripts which have not been traded during last three months...
regards
Srivatava
 

Similar threads