Fidelity
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 20
Posts 1,606
Boards Moderated 1
Alias Born 01/31/02
160x600 placeholder
Morgan Stanley's Profit Rises 56%
Morgan Stanley's profit rose to $1.51 billion as it posted higher revenue in each of its major businesses, including surprisingly good results from its fixed-income trading arm. Shares rose 3% as results beat analyst estimates.
More Top Equities Stories Of The Day
Client Balances at Morgan Stanley Wealth Management Near Merrill Lynch
Treasury Turns Its Gaze to Municipal-Bond Market
Citi Picks Dewilde to Lead Asia Markets and Investor Services Business
SanDisk, Weibo Gains Pace Tech Stocks
Fast-Rising Costs Erode Google's Profits -- 3rd Update
U.S. Hot Stocks: Hot Stocks to Watch
European Stocks Turn Higher, But Rémy, Diageo Lag
Microsoft Sells More Than 5 Million Xbox Ones
lostcowboy Member Level  Friday, 12/16/11 11:28:59 PM
Re: PraveenP post# 172
Post # of 239 
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