SureTrader Stock Hero Advertisement SureTrader
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
German Finance Minister Sees No Need to Discuss 'Alternatives' on Greece
German Finance Minister Wolfgang Schaeuble sees no need to discuss "alternatives" or disbursing further aid to Athens, since "Greece has to deliver what it promised" on its current bailout program first, he said in a radio interview.
Citi Hit With Setback in Commodities Repo Case
Altice in Advanced Talks to Buy Suddenlink -- Update
Spy Agencies Explored Tapping Google, Samsung App Servers
GE CEO Open to Intellectual Property Sales to Get Alstom Nod -- Update
Turkish Car Maker Tofas Says Has Resumed Production After Strike
Endo to Buy Generics Maker Par Pharma for $8 Billion -- 4th Update
Crystal Ball: Send Us Your Guess for H-P's Stock Price
Verizon's AOL Deal Aimed At Video Ads
New Computer Bug Exposes Broad Security Flaws
lostcowboy Member Level  Friday, 12/16/11 11:28:59 PM
Re: PraveenP post# 172
Post # of 256 
I don't know how to do that in Excel.


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

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
Current Price
Detailed Quote - Discussion Board
Intraday Chart
+/- to Watchlist