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,608
Boards Moderated 1
Alias Born 01/31/02
160x600 placeholder
U.S. Evacuates Embassy in Libya
Officials said the evacuation was conducted over land, with the State Department driving personnel from the American embassy in Tripoli to Tunisia. U.S. military units provided security, flying fighter jets, surveillance planes and positioning response forces in V-22 tilt rotor aircraft in the area to respond to potential threats, officials said. The evacuation was completed without incident, officials said.
Fox's Bid for Time Warner Includes Voice on the Board
Investigators Probe Whether Flight 5017 Brought Down by Storms -- 2nd Update
U.K. Equities Take the Limelight in European Markets
Have Big-Screen Smartphones Crashed the Tablet Party?
Google Grants Over Half of 'Right to Be Forgotten' Requests Processed So Far, Source Says -- 2nd Update
Greenlight Notes Short Positions in Safeway, Lorillard -Reuters
BofA to Pay $16.6 Million to Settle Alleged Sanctions Violations
U.S. Hot Stocks: Hot Stocks to Watch
H-P, Hortonworks Extend Partnership on Big Data
lostcowboy Member Level  Friday, 12/16/11 11:28:59 PM
Re: PraveenP post# 172
Post # of 245 
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