Search:

Doogle,

When I finally got time to examine the code in detail, per your last message, I found you were exactly correct in pinpointing the origin of the order of magnitude error. Correcting that...

OK, I'm here. Wow -- a PowerPoster! I'm impressed, but really shouldn't be. Have to sign off for the night (and tomorrow) as I leave early in the AM. Will check my email on Sunday (I have a really...

Spoo

You son-of-a-gun. Over the past 3 yrs I've tried to reach you via email. No response. Please contact me privately. My emails are the same.

6rtury
P.S. I think Doogle has the answer. Was...

Doogle,

The code you are looking at is one of the troubleshooting revisions I tried and which I obviously sent in error. My declarations for the prices are:

Dim LastFirstPrice As Single,...

Doogle,

Well, it's certainly worth a try. Back in a minute....

That's interesting. I've attached the file. All the correct values are expressed as dollars, with a dollar sign attached. The...

MarkT,

I had not tried that, but after reading your reply did put the currency format in the print statement. It made no difference. The file still shows the same errors in the same place.
...

MarkT:
I changed the variables to currency from single, including the calculated ADRatio, and the errors still appear -- in the same places.

Rhinobull:

With the debug.print I saw exactly the...

It looks like my attachment didn't go. Will try again with a zip file.

Thanks

Rhinobull: I have already looked at each ADRatio as it was calculated, in the watch window, and ALL the calculated values were correct -- including the ones at are incorrect in the output file. On...

Yes, here it is. Don't know if the indents will hold..Have attached a BAS file
------------------------------------------

thanks

This is the craziest problem I've ever seen. I have a text file containing a line of financial data for each minute of the trading day -- 400/day. I extract 4 data for each minute, calculate a ratio...

Lando:

Understand your problem. I've been doing genealogy for some years and know what you're facing. There's absolutely no package that will map sloppily entered data to the proper fields, nor...

Lando -
I'm new to this thread, so pardon me if you've already explained this.

Why are you going through this tortuous exercise -- attempting to parse a GEDCOM file? GEDCOMs are meant to...