Sorry, cancel that, error in formula, should be
=IF(SUM(COUNTIF(A$1:A2,{"S","B"})*{1,-1}),"",SUMPRODUCT((A$1:A2={"S","B"})*{1,-1}*C$1:C2*B$1:B2)*10)
regards, barry
Sorry, to further explain, I would get a sum of 4 because the contract has a multiplier of 10. Forgot to mention that....so, -825.2 + 824.8=.4 and .4 is really 4 because of the multiplier inherent in the contract traded.
Our Dev teams are like yours. Theyâ€™re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. Itâ€™s complex. So, we thought youâ€™d like to see whatâ€™s working for us.
I am sorry. The way I explained it is confusing. The short means I sold a contract whose value was 825.2 and later I bought a contract at 824.8, liquidating my position and giving me a net gain of .4 or 4. The way I illustrated it earlier was not correct.
Next thing, I am pretty excel ignorant, so how do I apply the formulat? I copy/pasted it into E, row 2 and get a -4, but am finding that any row I paste it, it gives the same answer, so I am assuming I am applying the formula incorrectly. Do I need to insert it somewhere? I am using MS Office 2007.
I took a picture of what I am getting. Notice column D info changed, not sure why. Also, notice I am copying/pasting the formula into E2 and then drag/copying down from there. 2011-03-01-1731.png
I think your formula is working, as row 24 is correct, I was up 30 at that time. Not sure what to make of the number that appears on every odd row in Column E
OK, I hesitate to say this but aren't they the correct values? Presumably the large positive or negative values are unexpected but they just indicate that you have bought without yet selling....or vice versa, perhaps you can only show the value if the number of Bs and Ss are the same (although does that necessarily apply to the same contract?), e.g. formula could be
With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option
David Miller (dlmille)
Intro
Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associateâ€¦
Do you use a spreadsheet like Microsoft's Excel? Have you ever wanted to link out to a non excel file on your computer or network drive? This is the way I found to do it!
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaacâ€¦
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templaâ€¦