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 Close Higher
U.S. stocks eked out record highs, as investors continued to cheer easy-money policies globally. The DJIA added eight points to 17818, while the S&P tacked on six points to 2069, both closing highs. The Nasdaq rose 42 points to 4755.
More Top Equities Stories Of The Day
BlackBerry Targets iPhone Users With Promotion
Faith-Based Shareholders Prepare Day of Reckoning for Bank of America
Intel Projects More Growth in 2015 -- Update
Wireless Carriers Bid Up US Airwaves To Record
Appeals Court Grants TV Programmers Stay in FCC Dispute -- Update
Messaging App Yik Yak Draws $300 Million-$400 Million Valuation - Sources
GameStop's Earnings, Holiday-Quarter Forecast Disappoint
U.S. Stocks Close Higher
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