Registered User
Joined: 3/6/2009
Posts: 78
|
Hi Bruce, when I am running a scan and it has several stocks in the result that I wish to buy, I like to allocate a certain dollar amount to each trade. Lets say I wish to buy 10 thousand dollars of each stock. What is the formula to calculate the number of stocks to buy rounded off to eliminate the decimal? Also how can I display this in a column of the scan list.? Thanks
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The closest thing I can come up with would be:
(10000 / C - .499999) \ 1
There might be some cases where it will round the wrong direction, but I haven't found any yet.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 3/6/2009
Posts: 78
|
Works great
Thank You
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
You're welcome.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|