Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm building a spreadsheet to track Certificate of Deposit (CD) rates from various banks. CD rates can be vastly different per bank: term length (3 months, 6 months, 60 months, etc.), and number of different rates (a rate for 3 month CDs and 6 month CDs for one bank, where another bank offers different rates for 1, 3, 6, 11, 16, and 60 months). My question is, how can I track this information in Excel?

Preferably, I'd like to have a row for each bank, as the sheet will need to track other bank information (bank name, URL, etc.). I figured that I'd need one cell to hold multiple values (an array), or an id to another table (such as a relational database).

share|improve this question

migrated from stackoverflow.com Aug 10 '11 at 3:08

This question came from our site for professional and enthusiast programmers.

    
Do you need to track historical data (e.g. bank X had a rate of Y for a 1 month CD on July 1st 2011) or do you only want to store the current rate for each bank/term length combination? –  barrowc Aug 10 '11 at 0:12
    
I'm not looking to track any on-going data, just the most up-to-date. Although, being able to see how the rates change over time would be nice. Perhaps I'll tackle that next. –  Akaishen Aug 10 '11 at 1:21

1 Answer 1

This is like trying to draw with ASCII art when Microsoft Word has a draw tool. Do yourself a favor and break down the problem into layers.

For one, I have no idea why you need everything on one row?? Excel formulas can reference whole spreadsheets at a time and calculate all that data into a single cell.

Two, you need to sit down and figure out exactly what you want. If all you need is to track CDs from different banks, there already are templates out there you can download that not only track CDs and their rates, but will also do fancy graphs and cook your breakfast. . .

You should probably sit down and write specifically what you want. It will make writing formulas and macros much much easier, rather than trying to plug in functionality piecemeal (the bane of all developers!! ie the ever changing specs).

share|improve this answer
    
Thanks for your reply Surfasb. I suppose the reason I was looking for a one-row solution is due to my lack of experience. From your reply, I gather that I can setup something akin to a relational database (holding the data in various places and gluing together the parts I want, when I want them). I'll start learning more about formulas and macros. I'll also see if I can find a template to cook my breakfast; that seems awesome. ;) –  Akaishen Aug 10 '11 at 6:28
    
Yeah, Excel can pretty much do anything you throw at it. A good place to browse for templates is the Microsoft Office website. –  surfasb Aug 10 '11 at 6:30

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.