Windows Forum

Ask something
Question Locked

Manipulating A Trading System

0 helpful
9 replies

by aedgar

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I'm trying to manipulate a trading system that was created by my old boss. He has multiple tabs of the same trading system for the different portfolios, but I want to establish just 1 tab where you can switch between the portfolios in one swift click.

I know you can create combo boxes or by simply having all information link up to a cell that holds Portfolio (A, B, C, etc...) that it would work. However, there is one bit of information that is still hand entered, which is it's ID or properly called, CUSIP. I need to find a method to find the CUSIP (on another tab) and pull it in the right place.

It seems like a simple VLOOKUP, but I have many different funds for each portfolio and many times the same fund used in multiple portfolios. I need the CUSIP cell's to give me the values of the respective portfolio so when I click portfolio A I will get all the funds CUSIPS in their proper position.

I'm sorry I can't give screen shots as assistance.

What I should also mention is that the portfolios have different # of funds. One can have 15 while the other only 10. They also can be different funds in each respective portfolio. While many will be the same, some will vary.

That is where my problems lie. I know if the funds were the same from portfolio to portfolio it would be easy, but I'm not sure how to solve this issue with different funds and different # of funds.

If anybody can help me with this dillemma I would greatly appreciate it.

Andrew

9 replies

by older mycroft

You're looking for a solution to a problem that doesn't exist.

You very well may end up with a [i]"trading system that was created by my old boss"[/i] that fails to work at all.

What are you gonna tell your new boss about that?

by cg it

While Techrepublic has IT Pros, and some might be hacks, this isn't the old IRC hackers haven.

by cg it

that could make a real catchy song for it...

Get Nickleback or 3 Doors Down to put some music to it....

by aedgar

Sorry if this is the wrong place for excel discussion. I had seen some financial templates/models and thought maybe I could get some assistance. I am new to this community and did not realize that this is strictly IT and you don't deal with anything excel.

As for the 1st reply, the model already works, but its split into 20 different tabs for our portfolios and i want it to be in 1 tab so it looks better and is easier to access.

Its just getting that setup the correct way in excel that is the problem. And my new boss is looking for something more simplistic.

by older mycroft

Perhaps you should leave it running as is.

Then start from scratch with a new design - you might find it easier or you may find it is impossible.

Your old boss maybe decided that too. ;)

by robo_dev

Be more specific in terms of what methods you have tried, and how the data exists in the current system.

The types of questions/answers you see here are more geared toward how a specific single task/problem is addressed, not overall program design or architecture, since you really need diagrams/drawings for that.

Not sure if that helps you though....

This discussion is closed to new replies.