Search results

Kind of ... I've thought about parts of the list (calculated 5 year annualized returns, for example) and bringing that back in - which is fine, but I do need to keep a list of the month by month returns. Maybe if I make a cross tab out of the cross tab I can convert it back?

Well I have solved it to some extent. I am able to run my script without crashing and get the values I need. It just takes 2 - 3 hours, where I clocked it and getting it from Access to Excel & calculated takes under 3 minutes, if I can get it back into Access to resume my calculations, I can...

Are there a fixed number of fields between the opening and closing numbers?

tinkering I've returned to this problem with a fresh eye. An earlier poster proposed exporting the data to excel for calculations, the problem I had at the time was inconsistant start dates. Having gotten my mind around exporing the data as a crosstab query has opened me up to what appears to...

still confused I'm not sure how that is going to help me convert the data from crosstab to a "normal" table, though. Is the idea that I rearrange the data in excel before I bring it back into access?

I've mastered steps 1 & 2 - no sweat, step 3 is what is baffling me. I'm going to try that code in excel - but I'm not sure I understand what it is doing. Thanks for the quick response. -A

bump ... anyone, anyone? bump ... love an answer

I'm posting this here because I'd love to be able to automate an export to excel, where I can use multiple sheets to calculate returns, then import the new numbers back into access as a new table. Is there a way to tell Access to import from a sheet where the fields are made up of 1) The row...

My Fix I've found the other codes here really helpful, thought I would add the one I used. This is from the knowldege base at Microsoft. Option Explicit Private Type STARTUPINFO cb As Long lpReserved As String lpDesktop As String lpTitle As String dwX As Long dwY As Long...

Oh, I don't doubt there is bad coding in there - I've hobbled this thing together from imported macros and MS access help forums. There is a lot I don't know and coming here has helped tremendously. My short term solution is to try and figure out how to make the shell...wait command work...

still plugging away I'm not sure how I could go about doing it in excel. I've got just about enough vb skills to make myself dangerous, and I'm not sure I can get up to speed with doing vb in excel by the time our next production cycle comes along. I originally had the numbers exported to...

I don't think Excel can hold the amount of data I need. Also, there aren't multiple users, it is just me. Once the final numbers are produced, I export just the core data to a new database and send that off to our web developers who import it into mysql. The core problem is coming up with the...

The data is never delivered in a printed report - the numbers are the basis for a whole host of other calculations as well as to plot graphs. Having the numbers in a table is crucial.

Great ideas - still no solution Thanks guy, these are great ideas, I'm going to try and work my way through them and see what sticks. I can't do this as a series of select queries because I need to keep a table with the running monthly return values. What drives me the most crazy is that I...

Hi Roy, thanks for the quick answer - I mistyped, I know what is creating the bloat, I've never found a fantastic, simple way to create five year monthly returns for a universe of 15,000 funds. So what I do is create one month's return for 1/10th of database, paste it into a new table, calcuate...

I have a module that maxes out my database about 2/3 of the way through running it. I then have to compact and try and pick up where I left off. The total time is close to 5 hours. I thought if I broke up the module into different databases and then linked them back to one shell, I'd stop...

Sample Table This is what the table looks like before I begin running my script: Manager Month End % Ch MarketValue M1 01/31/2000 3 10000 M1 02/28/2000 2 M1 03/31/2000 1 M1 04/30/2000 3 M1 05/31/2000 2 M1 06/30/2000 1 M2 01/31/2000 3 10000 M2 02/28/2000 2 M2 03/31/2000 1...

I've been trying for two years to find a fast way to calculate montly returns for a universe of financial figures. I start out at a set value, (say $10,000) calculate a return based on that month's price change, then paste that number into a table. For the next month, I take that new value...

First time poster, can't believe it took me this long to find the forum, already gained lots of knowledge in the 5 minute tour. I am designing a scatter graph. I have 10 data sets and want one point where the X & Y intersect and I want to have a label (or legand entry) for a third column...