Jump to content

Welcome to the new Traders Laboratory! Please bear with us as we finish the migration over the next few days. If you find any issues, want to leave feedback, get in touch with us, or offer suggestions please post to the Support forum here.

  • Welcome Guests

    Welcome. You are currently viewing the forum as a guest which does not give you access to all the great features at Traders Laboratory such as interacting with members, access to all forums, downloading attachments, and eligibility to win free giveaways. Registration is fast, simple and absolutely free. Create a FREE Traders Laboratory account here.

davewolfs

Software for Generating Reports Based on Various Indicators/Events

Recommended Posts

Hey everyone,

 

Quick question for you pros. Is there any software out there that will allow me to back test how the market reacted after a specific event occurred over the course of a specific time period.

 

Say for example, the market hit a 20 day low and I wanted to know how many times the market bounced when hitting a 20 day low since 2000 and what the average return after the bounce was vs the average S&P gain over a two day period without previously hitting a 20 day low.

 

I'm sure some sort of tool/package exists to compute these types of statistics. Any recommendations would be appreciated.

 

Thank you,

 

Dave

Share this post


Link to post
Share on other sites
So would I have to configure or program the software to execute buys under certain conditions to simulate this? Any recommendations on software?

 

 

Unless the software can read your mind on what you want to do, the answer is yes.

Edited by Tams

Share this post


Link to post
Share on other sites
... Any recommendations on software?

 

 

 

Since you have no programming/backtesting experience, it is difficult to make suggestions to you.

 

Most of the software has a 30 day trial.

Just go download a few and try them for yourself.

 

Ninjatrader is F-R-E-E... until you starts trading. That's a good starting point.

Share this post


Link to post
Share on other sites

No back testing experience, but I can program in Java and C++. To be more specific, I guess I was hoping that some sort of suite would exist that could be easily configurable to match on specific rule sets.

 

As far of software goes, are there better alternatives to Ninjatrader, I don't mind paying if it is going to make my life easier.

Share this post


Link to post
Share on other sites
No back testing experience, but I can program in Java and C++. To be more specific, I guess I was hoping that some sort of suite would exist that could be easily configurable to match on specific rule sets.

 

As far of software goes, are there better alternatives to Ninjatrader, I don't mind paying if it is going to make my life easier.

 

Tradestation is probably the most popular choice. If you are experienced in programming, you probably would not have much difficulty picking up the other platforms' language. I would suggest to check out NinjaTrader as Tams suggested. It uses C# which should be an easy transition for you since you know C++ already. The current version is not very robust for backtesting, but the next version (7.0), to be released before the end of the year promises to resolve most of the issues. Check the release notes on their website.

 

Also check out Amibroker which is very flexable and also easy to do portfolio level backtesting and very inexpensive compared to other platforms.

 

Another platform that is very flexable is Neoticker, but not easy to program in. However, if you have a strong programming background, you might not have much difficulty.

 

All these platforms will give you what you are looking for. Best would be as Tams suggested, to download the trials and see which one speaks to you.

Share this post


Link to post
Share on other sites
Will do. Do you know if TradeStation offers any sort of API that would allow me to download historical data, say I wanted to build my own database based on my own criteria.

There is currently no market data API available in the TradeStation platform. You can however, download a lot of data and export as text or CSV.

What you are looking to do is fairly simple, using daily data, and a lot of studies have been done (see Steenbarger). You can open a Tradestation account with or w/o their brokerage acount. Alternatively, if you are just testing the waters, download a 30 day trial copy of Multicharts from TSSupport, which is a TS clone, and just use the free Yahoo EOD daily data.

 

As someone had pointed out in the other forum to your question, you can do all of these in MS Excel as well, which is what Steenbarger did with a lot of this studies.

Share this post


Link to post
Share on other sites

davewolfs,

 

If you go the TS / MC route, PM me and I can give you template code for outputting 'count' statistics for various ways your test condition turns out (sans actual system backtesting). From there you could kick the stats out to .csv , etc. if needed...

 

zdo

Share this post


Link to post
Share on other sites
There is currently no market data API available in the TradeStation platform. You can however, download a lot of data and export as text or CSV.

What you are looking to do is fairly simple, using daily data, and a lot of studies have been done (see Steenbarger). You can open a Tradestation account with or w/o their brokerage acount. Alternatively, if you are just testing the waters, download a 30 day trial copy of Multicharts from TSSupport, which is a TS clone, and just use the free Yahoo EOD daily data.

 

As someone had pointed out in the other forum to your question, you can do all of these in MS Excel as well, which is what Steenbarger did with a lot of this studies.

 

I didn't realize that the data is easily available from Yahoo for the daily values and it seems like this could easily be done in excel. Thanks for the help.

 

How is Multicharts compared to the actual Tradestation platform? Are almost all TS Studies/Indicators backward compatible?

Share this post


Link to post
Share on other sites

if you are skilled enough - you can do anything with excel. Excel can read data files in CSV format.

There are free programs (or under $100) to download free daily data from the internet too!

 

TS you can do a lot with, but there are better ones. I second sevensa's neoticker recommendation, and amibroker.

 

I am using tradersstudio which makes amibroker look like a kids toy.

Share this post


Link to post
Share on other sites
I didn't realize that the data is easily available from Yahoo for the daily values and it seems like this could easily be done in excel. Thanks for the help.

 

How is Multicharts compared to the actual Tradestation platform? Are almost all TS Studies/Indicators backward compatible?

 

Pretty darn compatible.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Topics

  • Posts

    • Why not to simply connect you account to myfxbook which will collect all this data automatically for you? The process you described looks tedious and a bit obsolete but may work for you though.
    • The big breakthrough with AI right now is “natural language computing.”   Meaning, you can speak in natural language to a computer and it can go through huge data sets, make sense out of them, and speak back to you in natural language.   That alone is a huge breakthrough.   The next leg? AI agents. Where they don’t just speak back to you.   They take action. Here’s the definition I like best: an AI agent is an autonomous system that uses tools, memory, and context to accomplish goals that require multiple steps.   Everything from simple tasks (analyzing web traffic) to more complex goals (building executive briefings or optimizing websites).   They can:   > Reason across multiple steps.   >Use tools like a real assistant (Excel spreadsheets, budgeting apps, search engines, etc.)   > Remember things.   And AI agents are not islands. They talk to other agents.   They can collaborate. Specialized agents that excel at narrow tasks can communicate and amplify one another’s strengths—whether it’s reasoning, data processing, or real-time monitoring.   What it Looks Like You wake up one morning, drink your coffee, and tell your AI agent, “I need to save $500 a month.”   It gets to work.   First, it finds all your recurring subscriptions. Turns out you’re paying $8.99 for a streaming service you forgot you had.   It cancels it. Then it calls your internet provider, negotiates a lower bill, and saves you another $40. Finally, it finds you car insurance that’s $200 cheaper per year.   What used to take you hours—digging through statements, talking to customer service reps on hold for an hour, comparing plans—is done while you’re scrolling Twitter.   Another example: one agent tracks your home maintenance needs and gets information from a local weather-monitoring agent. Result: "Rain forecast next week - should we schedule gutter cleaning now?"   Another: an AI agent will plan your vacations (“Book me a week in Italy for under $2,000”), find the cheapest flights, and sort out hotels with a view.   It’ll remind you to pay bills, schedule doctor’s appointments, and track expenses so you’re not wondering where your paycheck went every month.   The old world gave you tools—Excel spreadsheets, search engines, budgeting apps. The new world gives you agents who do the work for you.   Don’t Get Too Scared (or Excited) Yet William Gibson famously said: "The future is already here – it's just not evenly distributed."   AI agents will distribute it. For decades, the tools that billionaires and corporations used to get ahead—personal assistants, financial advisors, lawyers—were out of reach for regular people.   AI agents could change that.   BUT, remember…   We’re in inning one.   AI agents have a ways to go.   They’re imperfect. They mess up. They need more defenses to get ready for prime time.   To be sure, AI is powerful, but it’s not a miracle worker. It’s great at helping humans solve problems, but it’s not going to replace all jobs overnight.   Instead of fearing AI, think of it as a tool to A.] save you time on boring stuff and B.] amplify what you’re already good at. Right now is the BEST time to start experimenting. It’s also the best time to find investments that will “make AI work for you”. Author: Chris Campbell (AltucherConfidential)   Profits from free accurate cryptos signals: https://www.predictmag.com/     
    • What a wild year.   AI seems to be appearing everywhere you look, Paris hosted a weird Olympics, unrest continues in the Middle East, the US endured a crazy-heated election, and the largest rocket ever to fly successfully landed in a giant pair of robot arms.   Okay, but what about the $money stuff?   Well, this year we've seen a load of uncertainty - inflation is still biting and many businesses have gone down.   Property has been very fractured, with developments becoming prohibitively expensive, while other markets have boomed.   It hasn't been an easy ride, that's for sure.   However, the stock market has had some outstanding results, and for those who know how to trade, some have done VERY well for themselves.   Some have replaced their incomes. Some have set themselves up for the rest of their days on this planet.   How about you? How did you go? Author: Louise Bedford    Profits from free accurate cryptos signals: https://www.predictmag.com/  
    • U Unity Software stock watch, attempting to move higher off the 22.4 triple+ support area at https://stockconsultant.com/?U  
    • TSSI TSS stock, watch for an ascending triangle breakout above 11.49, target 15 area at https://stockconsultant.com/?TSSI
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.