图表数据转换DLL [英] Chart Data Conversion DLL

问题描述

我将数据收集到csv中.

Hi,

I have collection of data into my csv.

Stock,BarDateTime,Open,High,Low,Close
3045,2012-10-10 09:15:00.000,2255.00,2261.80,2254.15,2256.25
3045,2012-10-10 09:16:00.000,2256.65,2261.85,2256.65,2261.85
3045,2012-10-10 09:17:00.000,2262.05,2263.00,2261.15,2261.15
3045,2012-10-10 09:18:00.000,2261.20,2261.20,2258.15,2259.00
3045,2012-10-10 09:19:00.000,2257.70,2259.55,2257.70,2258.90
3045,2012-10-10 09:20:00.000,2258.80,2259.70,2256.20,2257.00
3045,2012-10-10 09:21:00.000,2257.15,2257.15,2255.20,2255.80
3045,2012-10-10 09:22:00.000,2254.55,2254.55,2250.60,2251.20
3045,2012-10-10 09:23:00.000,2251.30,2251.30,2249.60,2249.60
3045,2012-10-10 09:24:00.000,2249.60,2250.90,2249.00,2250.90
3045,2012-10-10 09:25:00.000,2250.90,2253.60,2250.90,2252.80
3045,2012-10-10 09:26:00.000,2252.60,2252.60,2251.50,2252.00
3045,2012-10-10 09:27:00.000,2252.70,2255.00,2252.45,2252.85
3045,2012-10-10 09:28:00.000,2252.85,2252.85,2252.10,2252.10
3045,2012-10-10 09:29:00.000,2253.80,2254.85,2253.80,2254.45
3045,2012-10-10 09:30:00.000,2254.25,2254.25,2252.00,2252.00
3045,2012-10-10 09:31:00.000,2252.10,2252.10,2251.20,2252.00
3045,2012-10-10 09:32:00.000,2252.65,2254.40,2252.65,2254.35
3045,2012-10-10 09:33:00.000,2255.05,2256.95,2255.05,2256.05
3045,2012-10-10 09:34:00.000,2255.55,2257.90,2255.55,2256.85
3045,2012-10-10 09:35:00.000,2256.00,2257.00,2255.10,2256.60
3045,2012-10-10 09:36:00.000,2256.50,2256.50,2255.25,2255.40
3045,2012-10-10 09:37:00.000,2255.10,2255.10,2254.40,2254.40
3045,2012-10-10 09:38:00.000,2254.00,2257.50,2253.30,2256.30
3045,2012-10-10 09:39:00.000,2256.30,2258.95,2255.60,2257.60
3045,2012-10-10 09:40:00.000,2258.00,2258.00,2256.35,2257.05

如您所见，此数据的周期为1分钟间隔(请参见第二列BarDateTime"yyyy-mm-dd HH:MM:SS.SSS").我想将此数据转换为其他自定义周期，例如3,5,7分钟间隔，并据此计算OHLC.是否有任何C#dll或程序可以通过使用最低的循环迭代来将此数据的收集转换为任何其他自定义周期，以提高性能.我想将这些数据输出到动态数组中，因为我将以实时模式将数据添加到此集合中.
在我的C#应用​​程序中的数据上方，从CSV文件创建数据集.

As you can see periodicity of this data is 1 Minute interval(See second column BarDateTime "yyyy-mm-dd HH:MM:SS.SSS"). I want to convert this data into other custom periodicity like 3,5,7 Minute interval with OHLC calculated accordingly. Is there any C# dll or program which can convert collection of this data into any other custom periodicity, by using lowest loops iteration for better performance. I want output this data into dynamic array cause i will be adding data to this collection in realtime mode.
Above data in my C# application, creating dataset from CSV file.
Please let me know if you know any such readily available program or dll.

推荐答案

如果有人出于某种原因使某个程序完全执行此操作，并且此人是作为一个合理的人，此开发人员将以发布此代码并使其可用为耻.向忙碌且努力工作的人发送垃圾邮件不是一个好主意.如果有人在CodeProject之外的任何地方发布了此类代码，答案论坛，它不会长寿.许多像我这样的成员会报告说它没有任何价值，并且这种帖子会被关闭"，因为它有时会因垃圾邮件，窃或仅仅是毫无意义的帖子而发生.

现在，如果您认为让某件工作完全相同并且已经可用的软件的可能性很大，那么这将告诉我们您严重缺乏判断力.即使您不需要完全一样，但也希望有一些可以以某种方式帮助您的东西.实际上，从头开始编写所需的代码比在查看可用的相似代码(如果有人为您找到它的情况下)要便宜得多.

我给您提供了一些论据，以表明您的请求中没有任何内容具有实际意义.我什至严重怀疑您提到的整个工作是否具有实际意义.以临时方式处理临时数据和文件格式，满足临时需求和需求变更…

—SA

If someone has a program doing exactly this, by some reason, and if this individual is a reasonable person, this developer would be ashamed to publish this code and make it available. Spamming busy and hard-working people would be not a good idea. If someone published such code in CodeProject anywhere but this Questions & Answers forum, it would not live long. Many members like myself would report it as having no value, and such post would be "closed", as it happens from time to time with spam, plagiarizing or just pointless post.

Now, if you think that you have a considerable odds of having the piece of work doing exactly the same and already available software, it would tell us about your serious lack of judgement. Even if you don''t need exactly the same but hope to have something which could help you somehow. In fact, writing the code your need from scratch would be less costly then even looking at the available similar code in case someone finds it out for you.

I gave you some arguments to show that nothing in your request makes any practical sense. I even seriously doubt the whole work you refer to makes any practical sense. Dealing with ad-hoc data and file format, in ad-hoc manner, with ad-hoc requirements and changes in requirements…

—SA

这篇关于图表数据转换DLL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！