Fidelity SPDR Advertisement
Home > Boards > Free Zone > A.I.M. > The "Stock Trading Riches" Investment System

I don't know how to do that in Excel.

Public Reply | Private Reply | Keep | Last ReadPost New MsgReplies (1) | Next 10 | Previous | Next
lostcowboy Member Profile
Member Level 
Followed By 21
Posts 1,610
Boards Moderated 1
Alias Born 01/31/02
160x600 placeholder
U.s. Stocks Jump On Fed Reassurance
Stocks extended their gains into afternoon trading, boosted for a second session by reassurances from the Federal Reserve that it is in no rush to raise interest rates. The Dow industrials were up 270 points.
More Top Equities Stories Of The Day
Deezer Names New CEO Before Full U.S. Launch
Repsol to Buy Talisman Energy for $8.3 Billion --Update
BofA Whistleblower to Get Nearly $58 Million--Filing
Sprint to Face Record Fine Over Unauthorized Customer Charges
ADR Shares End Lower; BT Group Shares Trade Actively
U.S. Hot Stocks: Hot Stocks to Watch
U.K. to Sell Part of Lloyds Stake--2nd Update
Oracle Beats Street View for First Time in a Year
lostcowboy Member Level  Friday, 12/16/11 11:28:59 PM
Re: PraveenP post# 172
Post # of 248 
I don't know how to do that in Excel.

=IF(Q5<0;B5;IF(Q5>0;B5;N4))

Hi PraveenP, this is a bit of code from my Hi/Low demo spreadsheet. Column N is my last buy/sell price. Row 4 is just setting everything up, the action starts in row 5. column B is where you input the stock price. Column Q is where I determine if I have bought or sold any shares. If that number is zero, the number in (N5) is pulled down from (N4). IF I had a buy or a sell in (Q5), then the number in (N5 is gotten from (B5) the stock price that was inputed.

Hope this helps
Clifford

Come see me at Systematic Investing group #board-966 lets talk formula plans.
Public Reply | Private Reply | Keep | Last ReadPost New MsgReplies (1) | Next 10 | Previous | Next
Follow Board Follow Board Keyboard Shortcuts Report TOS Violation
X
Current Price
Change
Volume
Detailed Quote - Discussion Board
Intraday Chart
+/- to Watchlist