StockFetcher Forums · Filter Exchange · Logic statement<< >>Post Follow-up
calhawk01
135 posts
msg #101375
Ignore calhawk01
6/27/2011 10:30:46 PM

Anyone here good at excel? I have a large amount of data in excel file of my backtest results and i want to use excel to come up with a logic statement that tells me how many stocks at the moment I would have with a given capital. Essentially I am looking for a IF statement. Here are the tabs i'm working with:

Symbol Trigger Date Entry Price Exit Date Exit Price Days Held Gain/Loss Capital

I understand that in backtesting results I can view how many stocks would be in the portfolio on stockfetcher java feed, but i have over 12000 trades ...





calhawk01
135 posts
msg #101377
Ignore calhawk01
6/27/2011 10:36:56 PM

For example:

Symbol Trigger Date Entry Price Exit Date Exit Price Days Held # in portfolio
SNDK 12/31/2002 10.15 1/2/2003 10.27 0 x
NBL 1/7/2003 18.28 1/15/2003 17.56 5 x
APA 1/7/2003 26.6 1/9/2003 26.87 1 x
BTU 1/8/2003 6.77 1/9/2003 6.84 0 x

So in the above statement:
12/31/2002 x= 1
1/2/2003 x=0
1/7/2003 x= 2
1/8/2003 x=3
1/9/2003 x=1

so on..




four
4,005 posts
msg #101386
Ignore four
modified
6/28/2011 3:22:44 PM

See [ CLICK ] image:
Top half is the result

Bottom half shows the functions in columns I and J

- - -



Uploaded with ImageShack.us

StockFetcher Forums · Filter Exchange · Logic statement<< >>Post Follow-up

*** Disclaimer *** StockFetcher.com does not endorse or suggest any of the securities which are returned in any of the searches or filters. They are provided purely for informational and research purposes. StockFetcher.com does not recommend particular securities. StockFetcher.com, Vestyl Software, L.L.C. and involved content providers shall not be liable for any errors or delays in the content, or for any actions taken based on the content.


Copyright 2016 - Vestyl Software L.L.C.Terms of Service | License | Questions or comments? Contact Us
EOD Data sources: DDFPlus & CSI Data Quotes delayed during active market hours. Delay times are at least 15 mins for NASDAQ, 20 mins for NYSE and Amex. Delayed intraday data provided by DDFPlus