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
U.S. Stocks: Futures Up Ahead Of Home Prices, Consumer Confidence
U.S. stock futures rose on Tuesday, as another fall in eurozone inflation put pressure on the European Central Bank ahead of this week's meeting and investors waited for updates on home prices and consumer confidence.
Top Equities Stories Of The Day
JAL Customer Data Target of Cyber Attack
IPO Scorecard: Update on Selected Initial Stock Offerings
Shire, AstraZeneca Fall In London After U.S. Tax Move
Starboard Pushes For Potential Yahoo-AOL Tie-Up -- 5th Update
Bank Branches in U.S. Dip to Lowest Since 2005
ADR Shares End Lower; Petrobras, Itau Unibanco Trade Actively
UniCredit CEO Confirms Bank to Enter Talks With Santander
Judge Rules Businesses Don't Have to Return BP Payouts
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