Tics to minuts

R

Rolf Edberg

What query can make these tics to minutes?



From this:

Date Time Low High

4/1/2004 8:51:40 1.2586 1.2588

4/1/2004 8:51:42 1.2585 1.2587

5/1/2004 8:00:03 1.2685 1.2687

5/1/2004 8:00:24 1.2686 1.2688

5/1/2004 8:01:07 1.2684 1.2686

5/1/2004 8:01:28 1.2685 1.2687



To this:



Date Time Low High
Volume

4/1/2004 8:51 1.2585 1.2588 2

5/1/2004 8:00 1.2685 1.2688 2

5/1/2004 8:01 1.2684 1.2687 2





Thanks

Rolf
 
M

Marshall Barton

Rolf said:
What query can make these tics to minutes?

From this:

Date Time Low High
4/1/2004 8:51:40 1.2586 1.2588
4/1/2004 8:51:42 1.2585 1.2587
5/1/2004 8:00:03 1.2685 1.2687
5/1/2004 8:00:24 1.2686 1.2688
5/1/2004 8:01:07 1.2684 1.2686
5/1/2004 8:01:28 1.2685 1.2687

To this:
Date Time Low High Volume
4/1/2004 8:51 1.2585 1.2588 2
5/1/2004 8:00 1.2685 1.2688 2
5/1/2004 8:01 1.2684 1.2687 2
Click to expand...


Try something like"

SELECT [Date], Format([Time], "hh:nn") As RTime,
Min(Low) As MinLow, Max(High) As MaxHigh,
Count(*) As Volumn
FROM [your table]
GROUP BY [Date], Format([Time], "hh:nn")
 
R

Rolf Edberg

Thanks for the answer!!!

How do I make the question to work?

I got stuck on a ODBC-connection or am I totally off track?

I did this:
Query
New
Design
Close
Query(Meny)
SQL/Direct
Paste 'Your text'
Properties
ODBC; ...
And then I am lost..



Regards

Rolf

-----------------------------------------------

(I was wrong in my question. Sorry.

What I ment was to group trades. All trades that were made in the same
minute should have a lowest Low and a highest High and be counted as Volume.

PS. A tic is the smallest change in the price. The topic shold have been
'seconds to minutes'. DS)

Marshall Barton said:
Rolf said:
What query can make these tics to minutes?

From this:

Date Time Low High
4/1/2004 8:51:40 1.2586 1.2588
4/1/2004 8:51:42 1.2585 1.2587
5/1/2004 8:00:03 1.2685 1.2687
5/1/2004 8:00:24 1.2686 1.2688
5/1/2004 8:01:07 1.2684 1.2686
5/1/2004 8:01:28 1.2685 1.2687

To this:
Date Time Low High Volume
4/1/2004 8:51 1.2585 1.2588 2
5/1/2004 8:00 1.2685 1.2688 2
5/1/2004 8:01 1.2684 1.2687 2
Click to expand...


Try something like"

SELECT [Date], Format([Time], "hh:nn") As RTime,
Min(Low) As MinLow, Max(High) As MaxHigh,
Count(*) As Volumn
FROM [your table]
GROUP BY [Date], Format([Time], "hh:nn")
Click to expand...
 
M

Marshall Barton

Sorry, I do not understand what you are asking.

An Access query can be run in many ways. The simplest is to
just double click the query name in the database window.
Or, if you are in the query design window, just switch to
datasheet view.

If you are not using the Jet databse engine, the query will
have to modified to whatever SQL dialect your database
engine uses.
--
Marsh
MVP [MS Access]


Rolf said:
How do I make the question to work?

I got stuck on a ODBC-connection or am I totally off track?

I did this:
Query
New
Design
Close
Query(Meny)
SQL/Direct
Paste 'Your text'
Properties
ODBC; ...
And then I am lost..
Click to expand...
-----------------------------------------------

(I was wrong in my question. Sorry.

What I ment was to group trades. All trades that were made in the same
minute should have a lowest Low and a highest High and be counted as Volume.

PS. A tic is the smallest change in the price. The topic shold have been
'seconds to minutes'. DS)

"Marshall Barton" skrev
Rolf said:
What query can make these tics to minutes?

From this:

Date Time Low High
4/1/2004 8:51:40 1.2586 1.2588
4/1/2004 8:51:42 1.2585 1.2587
5/1/2004 8:00:03 1.2685 1.2687
5/1/2004 8:00:24 1.2686 1.2688
5/1/2004 8:01:07 1.2684 1.2686
5/1/2004 8:01:28 1.2685 1.2687

To this:
Date Time Low High Volume
4/1/2004 8:51 1.2585 1.2588 2
5/1/2004 8:00 1.2685 1.2688 2
5/1/2004 8:01 1.2684 1.2687 2
Click to expand...


Try something like"

SELECT [Date], Format([Time], "hh:nn") As RTime,
Min(Low) As MinLow, Max(High) As MaxHigh,
Count(*) As Volumn
FROM [your table]
GROUP BY [Date], Format([Time], "hh:nn")
Click to expand...
Click to expand...
 
R

Rolf Edberg

Thanks!!!!

Marshall Barton said:
Sorry, I do not understand what you are asking.

An Access query can be run in many ways. The simplest is to
just double click the query name in the database window.
Or, if you are in the query design window, just switch to
datasheet view.

If you are not using the Jet databse engine, the query will
have to modified to whatever SQL dialect your database
engine uses.
--
Marsh
MVP [MS Access]


Rolf said:
How do I make the question to work?

I got stuck on a ODBC-connection or am I totally off track?

I did this:
Query
New
Design
Close
Query(Meny)
SQL/Direct
Paste 'Your text'
Properties
ODBC; ...
And then I am lost..
Click to expand...
-----------------------------------------------

(I was wrong in my question. Sorry.

What I ment was to group trades. All trades that were made in the same
minute should have a lowest Low and a highest High and be counted as
Volume.

PS. A tic is the smallest change in the price. The topic shold have been
'seconds to minutes'. DS)

"Marshall Barton" skrev
Rolf Edberg wrote:

What query can make these tics to minutes?

From this:

Date Time Low High
4/1/2004 8:51:40 1.2586 1.2588
4/1/2004 8:51:42 1.2585 1.2587
5/1/2004 8:00:03 1.2685 1.2687
5/1/2004 8:00:24 1.2686 1.2688
5/1/2004 8:01:07 1.2684 1.2686
5/1/2004 8:01:28 1.2685 1.2687

To this:
Date Time Low High Volume
4/1/2004 8:51 1.2585 1.2588 2
5/1/2004 8:00 1.2685 1.2688 2
5/1/2004 8:01 1.2684 1.2687 2


Try something like"

SELECT [Date], Format([Time], "hh:nn") As RTime,
Min(Low) As MinLow, Max(High) As MaxHigh,
Count(*) As Volumn
FROM [your table]
GROUP BY [Date], Format([Time], "hh:nn")
Click to expand...
Click to expand...
Click to expand...
 
Top