lucid
11-26-2006, 09:06 PM
Hi,
I am wondering if anyone can help me out with this. I have been asked by a professor to create an excel sheet that allows students to trade stocks with fake money. To do this, an excel sheet is linked to Thomson One software (can do that no probs). What I need VBA code for buttons for is:
1) To open up a box that asks the student to type in a stock symbol and quantity to be purchased. Once Ok is clicked, the symbol and quantity are placed in their approrpiate cells and Thomson One is called up to provide the real-time price at which the security is bought.
2) a button the same as number 1, but sells the secuirty (or sells short).
What would be pretty sweet would be to not have the first button complete the trade, but only preview it. Then, a third button would have to be clicked to complete the trade, which would then lock in the numbers and not allow for changes (except for reversal of the trade (e.g. sell if a stock was bought)). Would this be possible?
Any help will be much appreciated!
I am wondering if anyone can help me out with this. I have been asked by a professor to create an excel sheet that allows students to trade stocks with fake money. To do this, an excel sheet is linked to Thomson One software (can do that no probs). What I need VBA code for buttons for is:
1) To open up a box that asks the student to type in a stock symbol and quantity to be purchased. Once Ok is clicked, the symbol and quantity are placed in their approrpiate cells and Thomson One is called up to provide the real-time price at which the security is bought.
2) a button the same as number 1, but sells the secuirty (or sells short).
What would be pretty sweet would be to not have the first button complete the trade, but only preview it. Then, a third button would have to be clicked to complete the trade, which would then lock in the numbers and not allow for changes (except for reversal of the trade (e.g. sell if a stock was bought)). Would this be possible?
Any help will be much appreciated!