Click here to Skip to main content
15,885,876 members
Home / Discussions / C#
   

C#

 
GeneralRe: Read comma delimited .txt file with large number of data - do search in column A Pin
lordoftrades18-Dec-13 2:48
lordoftrades18-Dec-13 2:48 
AnswerRe: Read comma delimited .txt file with large number of data - do search in column A Pin
Manfred Rudolf Bihy18-Dec-13 2:55
professionalManfred Rudolf Bihy18-Dec-13 2:55 
GeneralRe: Read comma delimited .txt file with large number of data - do search in column A Pin
lordoftrades18-Dec-13 3:03
lordoftrades18-Dec-13 3:03 
GeneralRe: Read comma delimited .txt file with large number of data - do search in column A Pin
Manfred Rudolf Bihy18-Dec-13 3:13
professionalManfred Rudolf Bihy18-Dec-13 3:13 
AnswerRe: Read comma delimited .txt file with large number of data - do search in column A Pin
BillWoodruff18-Dec-13 3:32
professionalBillWoodruff18-Dec-13 3:32 
GeneralRe: Read comma delimited .txt file with large number of data - do search in column A Pin
Manfred Rudolf Bihy18-Dec-13 3:53
professionalManfred Rudolf Bihy18-Dec-13 3:53 
GeneralRe: Read comma delimited .txt file with large number of data - do search in column A Pin
BillWoodruff18-Dec-13 4:30
professionalBillWoodruff18-Dec-13 4:30 
GeneralRe: Read comma delimited .txt file with large number of data - do search in column A Pin
lordoftrades18-Dec-13 4:12
lordoftrades18-Dec-13 4:12 
Hi
If I understand your question right:

1. Yes, i want the data to be: date,open,high,low,close
2. When the second column is 09:30:00 we know that this is the first row for this date. But sometimes there are no records the first minutes/hours, so it doesn't necessarily have to be true that 09:30:00 is the first row. It could be 10:15:00 in a stock with less trading activity. Anyhow, the first row as in your example:

Quote:
1/3/2012,09:30:00,409.3,410,409,409.79,657901


should return 409.3 as "Open" value.

3. The statements would be something like this:

startrow for date X
endrow for date X

Return:
1. date = X
2. Open= Column(3) value in startrow
3. High = search for higest value in range startrow to endrow, column(4)
4. Low = search for lowest value in range...... Column(5)
5. Close = Column (6) value in endrow

Kind regards
Espen
AnswerRe: Read comma delimited .txt file with large number of data - do search in column A Pin
jschell18-Dec-13 9:09
jschell18-Dec-13 9:09 
GeneralRe: Read comma delimited .txt file with large number of data - do search in column A Pin
lordoftrades18-Dec-13 9:59
lordoftrades18-Dec-13 9:59 
GeneralRe: Read comma delimited .txt file with large number of data - do search in column A Pin
jschell19-Dec-13 14:10
jschell19-Dec-13 14:10 
AnswerRe: Read comma delimited .txt file with large number of data - do search in column A Pin
BillWoodruff18-Dec-13 11:18
professionalBillWoodruff18-Dec-13 11:18 
GeneralRe: Read comma delimited .txt file with large number of data - do search in column A Pin
lordoftrades18-Dec-13 11:22
lordoftrades18-Dec-13 11:22 
QuestionZoom in and Zoom out feature in a picturebox Pin
alfie.max1518-Dec-13 0:00
alfie.max1518-Dec-13 0:00 
AnswerRe: Zoom in and Zoom out feature in a picturebox Pin
Richard MacCutchan18-Dec-13 1:22
mveRichard MacCutchan18-Dec-13 1:22 
AnswerRe: Zoom in and Zoom out feature in a picturebox Pin
JV999918-Dec-13 1:22
professionalJV999918-Dec-13 1:22 
AnswerRe: Zoom in and Zoom out feature in a picturebox Pin
Snehasish_Nandy18-Dec-13 1:41
professionalSnehasish_Nandy18-Dec-13 1:41 
AnswerRe: Zoom in and Zoom out feature in a picturebox Pin
BillWoodruff18-Dec-13 3:25
professionalBillWoodruff18-Dec-13 3:25 
QuestionStuck on delegates / events Pin
Member 1036998617-Dec-13 6:19
Member 1036998617-Dec-13 6:19 
AnswerRe: Stuck on delegates / events Pin
Pete O'Hanlon17-Dec-13 6:38
mvePete O'Hanlon17-Dec-13 6:38 
GeneralRe: Stuck on delegates / events Pin
jxfdasilva17-Dec-13 6:54
jxfdasilva17-Dec-13 6:54 
GeneralRe: Stuck on delegates / events Pin
Pete O'Hanlon17-Dec-13 6:59
mvePete O'Hanlon17-Dec-13 6:59 
GeneralRe: Stuck on delegates / events Pin
jxfdasilva17-Dec-13 7:07
jxfdasilva17-Dec-13 7:07 
GeneralRe: Stuck on delegates / events Pin
Pete O'Hanlon17-Dec-13 7:33
mvePete O'Hanlon17-Dec-13 7:33 
GeneralRe: Stuck on delegates / events Pin
jxfdasilva17-Dec-13 7:42
jxfdasilva17-Dec-13 7:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.