SPDR Advertisement SureTrader SureTrader 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,611
Boards Moderated 1
Alias Born 01/31/02
160x600 placeholder
Advertisement
Greek, German Tensions Turn to Open Resentment
At newspaper kiosks in Greece, ahead of Sunday's referendum, some front pages this week showed swastikas and the word "OXI", Greek for "no." On the streets of Athens, a poster showed German Finance Minister Wolfgang Schäuble with the words: "He's been sucking your blood for five years. Now tell him NO."
Electrolux's Plan to Buy GE's Appliances Unit Doesn't Worry Major Customers
Antitrust Cops Swing A Big Stick
BP Turns Page on a Dark Chapter
Aetna to Buy Humana -- 4th Update
Intel President Renée James to Leave as Others Also Depart -- Update
Centene to Buy Health Net for $6.3 Billion
Brazil Federal Police Arrest Another Former Petrobras Executive
Train Carrying Toxic Gas Derails in Tennessee
Donald Trump Dropped by NBC After Anti-Immigrant Remarks
lostcowboy Member Level  Friday, 12/16/11 11:28:59 PM
Re: PraveenP post# 172
Post # of 258 
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