Search results

Just in case someone comes looking here, I found what I needed: =SUM(INDIRECT(<start cell here> & ":" & <end cell here>)) Thanks again for the help.

Thanks tiddlywinks. I am looking at that. The array is actually contiguous - it is a section of one column, but which section of the column that is the array keeps moving down. I would just like to have the first cell and the last cell of the column/array be identified by the contents of two...

Thanks Tom. What I want to do seems like it should be simple - use the contents of one cell to identify the first cell of the array, and the contents of the 2nd cell to identify the last cell in the array. I've tried Cell, Cellcontents, Address, Concantenate, etc., but I haven't been able to...

Is it possible to create an array using the value in a cell as the first cell of the array and the value in another cell as the last cell of the array? For example, if I have a formula in D1 (or some other cell) that gives a result of $B$3, and a formula in D2 (or some other cell) that give a...

Thanks for the offer Mark. If I could just get back 10 years or so I would be okay. Doesn't look like esignal has more that about 120 days of intraday.

I really appreciate the suggestion, but it looks like esignal's intraday data only goes back 120 days. There would also be the problem of making a continuous future out of the various contract, but I could deal with that if they had the data...

I would think that there would be plenty of companies with good index futures historical data, but I have been having real difficulty finding them. The quote I got from CQG Data Factory was over $8,000. I'm glad to hear that it is good data, but I don't know if I can get myself to pay that...

Thanks for the input Mark. Did you find the quality of the historical data to be good other than being "on close"? Their videos make it sound like you can choose Open or Close, but I could probably adapt if needed. I am really only in need of accurate historical data for backtesting.

Thanks Kevin. I would like to send you a PM. I hate to show my ignorance, but do I do that by starting a "private thread"?

Anyone know anything about CQG's Portara? I have been looking for a source of 1-min. historical data for index futures, and this looks interesting. I called CQG for some info. I spoke with a very polite young man, but he sent me info on Data Factory instead of Portara… If anyone has any...

Thanks for the tip!

Maybe I'll have to take another look at laptops. I haven't purchased a personal computer since I built my current one about 5 years ago. At that point, I got a lot more for my money building a small desktop than buying a full-featured laptop. Times change though...

Thanks Evan! I'm checking those out.

I have monitors and peripherals in my home office and at my work office, so I only have to transport the computer. I am looking at getting three of the ASUS portable monitors that are only 1/2" thick for when I travel so I can put everything in a reasonably sized case. I really like having...

Thanks Dave. I didn't realize that they have desktops that small. I will check it out.

I am about to make a final decision on what data to buy. My best bet seems to be AlgoSeek. I'm not totally thrilled with what I see there, but it seems to be about the best at this point. If anyone has any new ideas, I would love to hear...

Thanks for the suggestion. I think this might be a little out of my league...

Thanks for the suggestion Mark. I am trying to avoid using a graphics card so that I can make this computer as small as possible. Without a graphics card, I think I can get it down to 8"x11"x2.5" or a little less which would make it real easy to transport with 3 portable monitors. That way I...

Thanks for the replies. Looks like I should be good to go...

Thanks Dave. I am building because I want to make it as small and portable as possible so I will be making the case. I built my current one based on ATX Micro board about 5 years ago, but I want to go even smaller this time - and not leave room for graphics cards...