SureTrader Advertisement PRTC
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,620
Boards Moderated 1
Alias Born 01/31/02
160x600 placeholder
Bank of America Relaunches Sale of Credit-Card Issuer MBNA
Bank of America Corp. has relaunched the sale of one of the U.K.'s biggest credit card companies MBNA, according to people familiar with the matter.
Culligan International Explores a Sale
Correction to Microsoft Smartphone Article on Wednesday
Facebook and Microsoft To Build Fiber Optic Cable Across Atlantic
Silicon Valley Driverless-Car Startup Raises Fresh Capital
ADRs End Mostly Lower; Alibaba, Baidu Trade Actively
Valeant Rejected Joint Takeover Approach From Takeda, TPG
Correction to Valeant CEO Article on April 21
Thermo Fisher Scientific to Buy FEI for $4.2 Billion
Shire Files 8K - Other Events
lostcowboy Member Level  Friday, 12/16/11 11:28:59 PM
Re: PraveenP post# 172
Post # of 269 
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.
SureTrader
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