InvestorsHub Logo
Boards
News
Market Data
Markets
Discover
Discover
AI Subscribe Login/Register account icon
S&P 500
5,719.52
(
-0.23%
)
US TECH 100
19,425.20
(
0.05%
)
Dow Jones
41,916.67
(
-0.69%
)
Brent Oil
73.00
(
-2.09%
)
Bitcoin
63,250.77
(
-1.58%
)
Post# of 289
Next 10
Reply Private New
Public Reply Private Reply New Post
Keep Last Read
Replies (1) Keep Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next

lostcowboy

Send PM Follow Ignore
Followers 24
Posts 1677
Boards Moderated 1
Alias Born 01/31/2002

lostcowboy

Member Level

Re: PraveenP post# 172

Friday, 12/16/2011 11:28:59 PM

Friday, December 16, 2011 11:28:59 PM

Post# of 289
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 New Post
Keep Last Read
Replies (1) Keep Last Read Next 10 Report Keyboard Shortcuts
Replies (1) Next 10 Prev Next
Join InvestorsHub

Join the InvestorsHub Community

Register for free to join our community of investors and share your ideas. You will also get access to streaming quotes, interactive charts, trades, portfolio, live options flow and more tools.

Sign Up