Hello all,
I have been trying to solve this problem for a while with no results. In my search here, I did not find exactly what I was looking for but admit that I may have missed it.
Attached is a sample spreadsheet with data set up in a similar fasion to what my spreadsheet looks like. The data begins in 2007 and goes through April, 2011. I separate out the data by month from a dedicated data spreadsheet. Columns A:G are data entries. H and I are calculations. Columns R and S mimic D and F with the exception that they are neither day not year-specific - that is, whatever value is in HE 1 for AECo is the same value for every day in April and for each year of data.
Columns K and H are two of my attempts - not pretty.
Ideally, I would like to compare D2 and G2 with R2:S7 to return -1, which will then be used to calculate a daily profit from either "net profit long" or "net Profit short."
Thanks,
Chris
Bookmarks