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
Stocks End Mixed; OPEC Sinks Energy Sector
U.S. stocks posted a mixed finish in a holiday-shortened session Friday as energy shares got slammed a day after the Organization of the Petroleum Exporting Countries did nothing to alleviate a global supply glut.
Top Equities Stories Of The Day
How to X-Ray Your Portfolio
Canada Resident Caught Up in China Corruption Probe
Hutchison Whampoa Prepping Bid for U.K.'s EE or O2 -Reuters
Correction to La Compagnie Fares Story
London Oil Stocks Extend Losses On OPEC Target Decision
SEC Grants Bank of America Short-Term Waiver from Hedge-Fund Restrictions
Samsung to Buy Back $2 Billion Worth of Shares -- Update
European Oil Stocks Finish Lower After OPEC Holds Production Target
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