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
  davewolfs said:
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
  davewolfs said:
... 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
  davewolfs said:
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
  davewolfs said:
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
  thrunner said:
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
  davewolfs said:
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

    • YUM Yum Brands stock, nice breakout with volume +34.5%, from Stocks to Watch at https://stockconsultant.com/?YUM
    • Date: 3rd April 2025.   Gold Prices Pull Back After Record High as Traders Eye Trump’s Tariffs.   Key Takeaways:   Gold prices retreated after hitting a record high of $3,167.57 per ounce due to profit-taking. President Trump announced a 10% baseline tariff on all US imports, escalating trade tensions. Gold remains exempt from reciprocal tariffs, reinforcing its safe-haven appeal. Investors await US non-farm payroll data for further market direction. Fed rate cut bets and weaker US Treasury yields underpin gold’s bullish outlook. Gold Prices Retreat from Record Highs Amid Profit-Taking Gold prices saw a pullback on Thursday as traders opted to take profits following a historic surge. Spot gold declined 0.4% to $3,122.10 per ounce as of 0710 GMT, retreating from its fresh all-time high of $3,167.57. Meanwhile, US gold futures slipped 0.7% to $3,145.00 per ounce, reflecting broader market uncertainty over economic and geopolitical developments.   The recent rally was largely fueled by concerns over escalating trade tensions after President Donald Trump unveiled sweeping new import tariffs. The 10% baseline tariff on all goods entering the US further deepened the global trade conflict, intensifying investor demand for safe-haven assets like gold. However, as traders locked in gains from the surge, prices saw a modest retracement.   Trump’s Tariffs and Their Market Implications On Wednesday, Trump introduced a sweeping tariff policy imposing a 10% baseline duty on all imports, with significantly higher tariffs on select nations. While this move was aimed at bolstering domestic manufacturing, it sent shockwaves across global markets, fueling inflation concerns and heightening trade war fears.   Gold’s Role Amid Trade War Escalations Despite the widespread tariff measures, the White House clarified that reciprocal tariffs do not apply to gold, energy, and ‘certain minerals that are not available in the US’. This exemption suggests that central banks and institutional investors may continue favouring gold as a hedge against economic instability. One of the key factors supporting gold is the slowdown that these tariffs could cause in the US economy, which raises the likelihood of future Federal Reserve rate cuts. Gold is currently in a pure momentum trade. Market participants are on the sidelines and until we see a significant shakeout, this momentum could persist.   Impact on the US Dollar and Bond Yields Gold prices typically move inversely to the US dollar, and the latest developments have pushed the dollar to its weakest level since October 2024. Market participants are increasingly pricing in the possibility of a Fed rate cut, as the tariffs could weigh on economic growth.   Additionally, US Treasury yields have plummeted, reflecting growing recession fears. Lower bond yields reduce the opportunity cost of holding non-yielding assets like gold, making it a more attractive investment.         Technical Analysis: Key Levels to Watch Gold’s recent rally has pushed it into overbought territory, with the Relative Strength Index (RSI) above 70. This indicates a potential short-term pullback before the uptrend resumes. The immediate support level lies at $3,115, aligning with the Asian session low. A further decline could bring gold towards the $3,100 psychological level, which has previously acted as a strong support zone. Below this, the $3,076–$3,057 region represents a critical weekly support range where buyers may re-enter the market. In the event of a more significant correction, $3,000 stands as a major psychological floor.   On the upside, gold faces immediate resistance at $3,149. A break above this level could signal renewed bullish momentum, potentially leading to a retest of the record high at $3,167. If bullish momentum persists, the next target is the $3,200 psychological barrier, which could pave the way for further gains. Despite the recent pullback, the broader trend remains bullish, with dips likely to be viewed as buying opportunities.   Looking Ahead: Non-Farm Payrolls and Fed Policy Traders are closely monitoring Friday’s US non-farm payrolls (NFP) report, which could provide critical insights into the Federal Reserve’s next policy moves. A weaker-than-expected jobs report may strengthen expectations for an interest rate cut, further boosting gold prices.   Other key economic data releases, such as jobless claims and the ISM Services PMI, may also impact market sentiment in the short term. However, with rising geopolitical uncertainties, trade tensions, and a weakening US dollar, gold’s safe-haven appeal remains strong.   Conclusion: While short-term profit-taking may trigger minor corrections, gold’s long-term outlook remains bullish. As global trade tensions mount and the Federal Reserve leans toward a more accommodative stance, gold could see further gains in the months ahead.   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 Leveraged 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.
    • AMZN Amazon stock, nice buying at the 187.26 triple+ support area at https://stockconsultant.com/?AMZN
    • DELL Dell Technologies stock, good day moving higher off the 90.99 double support area, from Stocks to Watch at https://stockconsultant.com/?DELL
    • MCK Mckesson stock, nice trend and continuation breakout at https://stockconsultant.com/?MCK
×
×
  • Create New...

Important Information

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