loss

Calculate puts needed to insure against stock market loss..

I am a self-taught excel user, and have tried to build a macros to do this, and failed! I am looking for every minute detail about how to do this (I have already added the developer tab but where to go from there, I need to clarify). I have three workbooks/tabs: Raw Data, Referral...

Hi there, I have four squares on a sheet each entitled 1-purchase Price 2-current price 3-purchase price stop loss 4 - current price stop loss. In a fifth square I want to automatically put the current stop loss. Square 3 is the key. If square 2 is below 3 then I would want to highlight that...

I need someone to produce a spreadsheet to manage the following problem for us through providing a spreadsheet. "We are 3 people with 3 different bank accounts, we have decided to share the expenses and profits between us 30%, 35% and 35%. So what we need is an excel where we can enter the...

I am creating an excel file in order to track the history of our football team. The excel sheet has the name of our opponents as well as the score for our team and the score for the opponent. I want to have another column that has a formula to calculate, based on the score, the result with a...

Hi, I'm creating a business plan for a start-up publishing house. I have to calculate gross profit and gross margin for each of the three books that will be launched, based on three separate sales scenarios. I then have to calculate gross profit and gross margin for the business as a whole...

I am trying to figure out a way to keep track of a win lost streak for a basketball league I run. I have win column and a lost column next to each team name with a w/l column after that. I would like the W/L column to auto update when I updated each teams wins and losses. Example. If team a had...