• This topic is empty.
Viewing 13 posts - 1 through 13 (of 13 total)
• Author
Posts
• #2918
changmin
Member

Hello,

Have anyone load in your own data ie from excel to Algo Quant to test out? I do not know how to load in our data to it.

If anyone knows, please teach me.

Thank you very much
Leo

#2919
Ryu
Member

AlgoQuant can download data from free sources such as Yahoo Finance. See this for an example:

http://redmine.numericalmethod.com/projects/public/repository/svn-algoquant/entry/core/src/test/java/com/numericalmethod/algoquant/model/elliott2005/strategy/Elliott2005v10Test.java

(Your version is going to be different from the svn version because the release is not yet updated.)

#2920
changmin
Member

Hi Ryu,

I mean load up my own data. My data is fixed income data. You wont be able to find it from yahoo finance. My data is in Excel. I just need your software to read in my data and try your strategy to see if it works or not.

Thank you
Leo

#2921
Ryu
Member

In that case, you just need to use this class to create a SequentialCache<Depth> and feed that into the simulator.

#2923
changmin
Member

Dear Ryu,

I found the two files in algoquant-0.8.0.
I run the CsvCacheLoaderTest.java in algoquant-0.8.0. I have two questions:

1) How do I check the data, “test-data/csv/AU.csv” is loaded?

2) All the lines in CsvCacheLoaderTest.java become black colour instead of remaining at its original different colours.

Leo

#2924
Ryu
Member

I am not sure if I understand.

1) Can you just print them out, or view them in a debugger?

2) I am not sure what you mean. Can you post a screenshot please?

#2925
changmin
Member

Hi Ryu,

1) How do you see the values in debugger? I cant find the variable name that is associated with the data.
2) In the attached picture, on the left-hand side of it shows that all the wordings are black after I run the simulation. On the left is the normal colourful workings.

Thank you very much for your help
Leo

#2927
Ryu
Member

You can examine the variable cache.
Are you using Eclipse, you can refer articles like this for learning how to use its debugger:
http://www.vogella.com/tutorials/EclipseDebugging/article.html

I don’t know why the code coloring disappears but it is an eclipse problem, not algoquant’s.

#2931
changmin
Member

Dear Ryu,

I can use CsvCacheLoaderTest.java to load in my data and verify the values. However, when I try to load data to demoElliott2005_010.java, I could not. I do not know how to create depthCaches using the technique in CsvCacheLoaderTest. I attach the source code and the error messages.

Leo

#2934
Ryu
Member

First, you need a throw-exception clause:

Second, you need to create a DepthCaches.
E.g.,

#2935
changmin
Member

Dear Ryu,

It is not working still. I made some changes and I attached the source code.

I encountered the error at
// execution summary
logger.info(String.format(“%d executions: %s”, allExecutions.size(), allExecutions));

The compiling error says the following

Exception in thread “main” java.lang.Error: Unresolved compilation problem:
Execution cannot be resolved to a type

at com.numericalmethod.algoquant.model.elliott2005.demo.DemoElliott2005_010_ccm.main(DemoElliott2005_010_ccm.java:154)

Thank you very much for your help
Leo

#2937
changmin
Member

Dear Ryu,

I got it working. I attached the graph

The strategy could not work on my data. May I seek your advises on what can be changed ie parameters?

Thank you
Leo

#2939
Ryu
Member

There are practically infinitely many things you can do starting from here. You can change the calibration window, the calibration period, the trading sizes, the way you compute the mean (long term vs. short term), the entry and exit signals, etc. This is the fun part of “designing” a trading strategy. You need to use a lot of imagination here.

This is why we open up the source code so you can design and code up your own mean-reversion strategy based on Prof. Elliotts’ framework.

Viewing 13 posts - 1 through 13 (of 13 total)
• You must be logged in to reply to this topic.