Software creating exportable block trading entry

Project Overview: What we would be trying to accomplish is to import current financial client portfolio data from our client database (PortfolioCenter) and have the ability to automatically create new buy and sell orders based on signals received from a separate software package. The software would need to be able to identify, based on models we create and that is updated on a weekly basis – what new buy orders to place and what current securities to sell for all of our clients. Some clients have a single account; however the majority of them have multiple accounts that are combined into a single household group. It is critical to be able to run all households that were in similar models simultaneously. It would be of no value if each household needed to be run individually. The final result would need to export a CSV file that we could then upload to our broker for execution of the trades. In more detail: Clients currently hold a variety of stocks, ETFs and mutual funds. All of these clients are currently in models that allocate how much they should hold in each of these securities. Each week there is the possibility that we will be including new securities to buy and/or sell. Unlike rebalancing portfolios, unless we want to sell a security or buy one – we would not want to “rebalance” the portfolio each time we run the software. For example, if a stock has done very well – we do not want to trim the position, even though a model may call for a less percentage (and vice-versa). Buy orders: When placing a new buy order, each client will need to purchase that security at a value that is based on a certain percentage of their portfolio (based on which model they are in). Each client has a different market value and so the total number of shares purchased would need to change for each client. Also, since the market is constantly moving – the stock pricing would need to be based on some sort of real time stock feed. One caveat with this procedure is for clients who have multiple accounts assigned to a single model. If there is a buy signal, we would not want to buy the same security in each account – what we would want to accomplish is to have the software identify the group of accounts, determine the total market value of them all and base the shares of stock to buy based on the total value of all of their accounts. The software would then need to identify the best account to purchase the stock in (based on cash available, sizes of the accounts and keeping a balanced ratio of securities between them all) Sell Orders: Sell orders would need the ability to choose to either sell the entire amount in all client’s accounts or reduce all accounts by a certain percentage. Sell orders will not need to determine which account to pull it out of – as it is more of a global decision. Ideally, when sell orders are generated – we would want to create a way to alert us if there are any short term redemptions (mutual fund sold within 90 days of purchasing). Exceptions: There would need to be a way to lock certain accounts or securities within the software to avoid generating trade orders for certain clients. When a security is listed as an exception, it should be ignored from trading and when calculating percentages for buys. Models: There would need to be a way to modify/add/delete models and then link them up to clients, groups and households. It is important this is free of errors and works everytime. The more simple it is to run and the more automated, the better. We are looking to get something up and running quickly. Thanks!