create a spreadsheet and vba algorithm that trades according to the decision rules

/in /by

The case involves accepting or rejecting a series of institutional orders. Your decision rule for accepting or rejecting these orders is as follows:

 You will accept an institutional sell order if, following the acceptance of the order, you can instantly place a market sell order to reverse 65% of the share position at a volume-weighted average price that is greater than the price of the institutional sell order

 You will accept an institutional buy order if, following the acceptance of the order, you can instantly place a market buy order to reverse 65% of the share position at a volume-weighted average price that is less than the price of the institutional buy order.

After placing the large market order, the remaining position should be reversed algorithmically using smaller market orders of 500 shares per second. If your share position is close to zero but not divisible by 500, then your algorithm should place a market order such that you revert to a zero share position. As an example, suppose you had to decide whether to accept an institutional buy order for 80,000 shares at a price of $50 per share. While contemplating this decision, you examine the ask side of the limit order book and find that you can buy 52,000 shares at a volume-weighted average price of $49 per share. Because the VWAP of buying 52,000 shares is less than the price at which the institution sells you the shares, you would accept the institutional buy order for 80,000 shares and then quickly submit a market order to buy 52,000 shares to reverse 65% of your negative share position. The remaining position of negative 28,000 shares would then be reversed algorithmically by purchasing 500 shares per second.

Create a spreadsheet and VBA algorithm that trades according to the decision rules above. Information in your spreadsheet should be used to facilitate the decision of whether to accept or reject an order. The accept/reject decision can be executed manually or algorithmically (the latter is more challenging). Your spreadsheet should be organized so that the manual decision to accept an institutional order can be made quickly. The instructions for accepting or rejecting an order should be made very clear.

(Note: your solution to this question must as a spreadsheet with macros (i.e. an xlsm file) . Also make sure that the workings in your spreadsheet and VBA code are clear and easy to follow.)

 
Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.