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,608
Boards Moderated 1
Alias Born 01/31/02
160x600 placeholder
S&P 500 Advance Biggest In 4 Weeks
The U .S. equity market ended Tuesday's session higher, sending the Dow Jones Industrial Average to an intraday record high, while the S&P 500 recorded its biggest one-day gain in 4 weeks.
Top Equities Stories Of The Day
Microsoft, Pandora Lead Tech Higher
China Foreign Direct Investment at Four-Year Low -- Update
U.S., EU Widen Sanctions on Russia
U.S. Hot Stocks: Hot Stocks to Watch
Correction to China Mining Story on Sept. 11
U.S. Steel Canada to Seek Creditor Protection -- Update
U.S. Livestock Futures Prices Mostly Lower On Demand Caution
U.S. stocks were mixed, but technology stocks suffered sharp losses in cautious trading
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