Dynamic and static loadings both need to be calculated. Dynamic load ratings are usually based on a given load that can be moved for a million revolutions. Moment loads are also important, with particular focus on the direction in which they occur because they are likely to reduce the efficiency of the ball screw.
https://www.matara.com/product....s/linear-motion/ball