strategy

Every year our organization holds a large concours car show. Every year "they" change something in the format in some way that requires me to tweak my spreadsheet. I am looking for a strategy were I am not renaming ranges etc. I am looking for labeling/name strategy that is more flexible. Any...

Hi I wanna make/find the ultimate BlackJack software to beat online live BlackJack. What I want it to have: Let's you input: - All the relevant rules for the online casino in question - You can press a button of card value and suit and register it as it is dealt via buttons - True count and...

Hello, I stand before a task to create a dashboard showing several metrics derived from a single large (expanding 100s rows x 300 fixed collums of data) table. I do have an idea which metrics I need to track, and how to individually get them from the data, but I struggle with defining a...

Hi, I am trying to ascertain the number of days it would take the Firm to exit each stock held across two strategies (each with a number of portfolios), given the percentage weight holding in each of the portfolios in the strategy, the value of each portfolio in dollars, the average daily $...

Hi Folks, I have a problem to solve. I have a spreadsheet that selects two funds based upon an algorithm that is applied to a basket of funds. At the close of the last trading day of the month, the new fund selections are made (sometimes they change, sometimes they remain the same...

I have always written my VBA code using absolute cell references. A problem arises when I find it necessary to add a row or column after the program has been finished. The spreadsheet updates but the code behind it does not. This requires much rewriting of the code. There must be a better way...

Hey guys, I am currently backtesting a volatility strategy in Excel 2007 and have stumbled upon some problems automating things. Seems hard to post a snapshot so I'm just gonna describe my sheet and problem... Column 1: 20 day moving average of volatility Column 2: 50 day moving average of...