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

    • Date: 26th November 2024. Trump’s tariff threats boosted Dollar; Peso, Loonie, Gold & Oil Lower. The Trump trade picked up steam as investors cheered his pick for Treasury Secretary, Scott Bessent. Beliefs he will be a steadying voice in the administration’s fiscal measures, while still following President-elect Trump’s tariff and tax commitments, underpinned. Asia & European Sessions:   Trump threatened on Monday to impose sweeping new tariffs on China, Canada and Mexico on his first day as US President to crack down on illegal immigration and drugs. He would impose a 25% tax on all products entering the country from Canada and Mexico, and an additional 10% tariff on goods from China as one of his first acts as president of the US. Bessent’s 3-3-3 plan aims to cut the deficit to 3% of GDP, boost growth to 3%, and increase oil production to 3 mln barrels. Treasury yields dove in a curve flattener, extending their drops through the session, on expectations inflation will decelerate. A strong 2-year auction also supported. The Dow led the charge, climbing 0.99% to 44,736, a new record peak as the rally broadens. The S&P500 climbed to 6020, a session peak, but finished with a 0.3% gain to 5987. The NASDAQ closed 0.27% higher. Today, stock markets in Europe are posting broad losses, with the DAX down -0.6%, the FTSE 100 0.4%, after a largely weaker close across Asia. ECB: Lane suggests ECB must be open-minded on speed of rate cuts. The ECB’s Chief Economist said in a speech on Monday evening that “remaining open-minded about the speed and scale of adjustments is in fact a valuable strategy across various environments, as different situations may necessitate distinct approaches.” This careful, step-by-step strategy enables us to observe the responses of the economy to our decisions and continuously refine our understanding of their impacts.” The comments leave the door open to a 50 bp move in December, but also tie in with our expectation that the central bank will deliver a 25 bp while tweaking the forward guidance and commit to additional moves. Financial Markets Performance: The USDIndex hit a session high of 107.50 and is currently lower at 106.85. Mexican peso and Canadian dollar slumped as the dollar is being viewed as a haven after the comments of President-elect Donald Trump on tariffs on Canada, Mexico and China. USDCAD spiked to 1.4177 and USDMXN rallied to 20.74. Oil and Gold lost ground, in part on cooling geopolitical risks, and on Trump trades. Oil dropped -3.03% to $69.09 per barrel, in part on the Trump trade and on talk of a potential cease fire between Israel and Hezbollah. Similarly, gold fell -3.26% to $2605 per ounce. Always trade with strict risk management. Your capital is the single most important aspect of your trading business. Please note that times displayed based on local time zone and are from time of writing this report. Click HERE to access the full HFM Economic calendar. Want to learn to trade and analyse the markets? Join our webinars and get analysis and trading ideas combined with better understanding of how markets work. Click HERE to register for FREE! Click HERE to READ more Market news. Andria Pichidi HFMarkets Disclaimer: This material is provided as a general marketing communication for information purposes only and does not constitute an independent investment research. Nothing in this communication contains, or should be considered as containing, an investment advice or an investment recommendation or a solicitation for the purpose of buying or selling of any financial instrument. All information provided is gathered from reputable sources and any information containing an indication of past performance is not a guarantee or reliable indicator of future performance. Users acknowledge that any investment in FX and CFDs products is characterized by a certain degree of uncertainty and that any investment of this nature involves a high level of risk for which the users are solely responsible and liable. We assume no liability for any loss arising from any investment made based on the information provided in this communication. This communication must not be reproduced or further distributed without our prior written permission.
    • RYAM Rayonier Advanced Materials stock, nice trend with a pull back to 8.79 support area, bullish indicators at https://stockconsultant.com/?RYAM
    • LICY Li-Cycle stock watch, attempting to move higher off the 2.15 triple+ support area at https://stockconsultant.com/?LICY
    • SGMO Sangamo Therapeutics stock watch, pull back to 2 support area with high trade quality at https://stockconsultant.com/?SGMO
    • YUMC Yum China stock watch, pull back to 47.4 support area with bullish indicators at https://stockconsultant.com/?YUMC
×
×
  • Create New...

Important Information

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