can u guide me to write formula on stocks in excel
2006-09-28 22:59:57 · 5 answers · asked by Anonymous in Business & Finance ➔ Investing
Stock data in historical lists have items like date, Open, High, Low, Close, Volume and sometimes Adjusted Close. I have found the important bits are Date, Close and Volume.
You can create additional columns to calculate the amount of change in price and the amount of change in volume. Then you have to decide how much change in these will indicate buy signals or sell signals. If anyone comes up with the definitive signal pattern to buy and/or sell, either it doesn't work or they won't share it, so you'll have to decide on your own.
2006-09-30 02:04:57 · answer #1 · answered by Ken C. 6 · 0⤊ 0⤋
Don't know what you're looking for, but may be theres some templates online somewhere or at Microsoft website. Or buy Mathematica.
2006-09-28 23:07:39 · answer #2 · answered by Anonymous · 0⤊ 0⤋
i have an e-book i can mail you if you want (might be useful)
2006-09-28 23:13:13 · answer #3 · answered by Ðêù§ 5 · 0⤊ 0⤋
what exactly r u attempting?
2006-09-28 23:50:40 · answer #4 · answered by slimshady3in 4 · 0⤊ 0⤋
I am not familiar with it sorry
2006-09-28 23:06:32 · answer #5 · answered by Anonymous · 0⤊ 2⤋