Tag Archives: trading

Excel For Trading: How To Do It Right

Excel is widely used by hedge funds and professional traders to manage trades, calculate P&L, compute buy and sell signals, and much more. These capabilities are available to the average trader, many of whom already use charting software to help with their trade strategies, often with limited success. Including Excel in your trading workflow process can deliver high value in terms of profitability, discipline and consistency. There are a few things you need to learn, but it is achievable with a little effort and the benefits can be very significant to your bottom line.

One of the first considerations is how you will use Excel for trading. Will you be importing price data into a spreadsheet? Will you track your positions, profits, and losses there? Do you intend to integrate it with an existing trading platform? Do you want to develop a complete Excel for trading system with VBA, charts, order entry, and such?

Importing price and volume data is one way to implement Excel for trading. This is typically done through DDE links to an internal or external pricing database. DDE links are easy to use and do a good job of updating fast moving prices, but cannot handle huge volumes. Alternately, you can import price and volume data into Excel from the Internet using web queries directly from Excel’s Data from Web functionality. This is good for basic data capture of prices, volume, financial statements, etc. from Yahoo Finance, MSN Money Central, Quicken and other standard websites. Finally, you can import data into your spreadsheet using the Data from Other Sources function which allows you to use SQL Server, MS Analysis Services, XML files, and ODBC connections.

Using Excel for trading is highly dependent on data. Importing prices and fundamental data into Excel automatically is a great first step to implement Excel for trading. In fact, not much else can be achieved until you import data, so this is a basic foundation step. There are multiple ways to do this. DDE links can be used to import data from a data vendor. Your broker’s API can be used to connect to the actual prices your broker uses. Internal or vendor provided databases can be connected using SQL or web queries. How you implement the data import will have a lot to do with your strategy and the data types you want. For automated intraday trading with fast moving prices a DDE link is best. The Data from Other Sources function in Excel uses SQL Server, XML files or ODBC to connect to a database if you have one internally at your office or home. Web queries can work for end of day and fundamental quarterly type data. Economic data comes out infrequently so speed is not an issue.

Best practices of Excel for trading involve planning your spreadsheet workflows and relationships so everything works together correctly and you can find what you need when you need it. You have a choice here of building a multiple spreadsheet environment or creating a single workbook with lots of tabs. The prior approach is modular and tends to work well because each separate workbook is for a specific purpose, small, and easy to manage. The downside is you may need to manage lots of links and Excel links have a tendency to break and get corrupted. Big workbooks with lots of sheets can be useful in Excel for trading since you have everything in one place. However, Excel tends to bog down and the files get huge when you start using more than 10,000 rows of data, charts, and multiple tabs together. It can also be a bit risky to have your whole daily trading operation in one file. Just make sure you back up your files in an external location every day!

These ideas should help you get started using Excel for trading to improve your trade processes and increase profits with less risk.

Want to learn more on how to implement Excel for trading? Visit this site for a FREE GUIDE on creating and coding trading models in Excel.

Learn The Forex Tips You Need To Succeed

Supplemental income can help make ends meet in tough economic times. Millions are currently worrying about their finances. The information provided in this article is especially helpful for anyone who is considering forex trading as a source of supplementary income.

Searching in Google can help determine trusted brokers as well as those who are not to be trusted. You can find a lot of useful tips about brokers on Forex forums. Once you have weeded out the riffraff you can be more confident about making money.

A good way to work toward success when you are trading in foreign exchange is by becoming a trader with a very small account for a year or more. It is very important to know the good trades and the bad ones and this is the easiest way to understand them.

Many professional forex traders will advise you to record your trades in a journal. Jot down both when you’ve done well, and when you’ve done poorly. This way, you will able to track your progress and see what works for you and what doesn’t work.

Don’t ever make a forex trade based on emotions. Keeping yourself from giving in to emotions will prevent mistakes you might make when you act too quickly. Of course emotions may seep into the forefront of your brain, but try to resist them as much as possible.

If you change the location of the stop loss points right before they get triggered, you can wind up losing more money than you would of if you didn’t touch it. Follow your plan to succeed.

Set goals and reevaluate once you have achieved them. Once you have decided to trade on the forex market, you should set a clear goal and a reasonable time frame for meeting that goal. Your goals should be very small and very practical when you first start trading. Determine the amount of time you can set aside for trading activities, and don’t forget to account for time needed for research.

Fake it until you make it. You can get used to the real market conditions without risking any real money. Try looking online as well for helpful tutorials. Before you trade, be sure to educate yourself about Forex to fully understand what it is all about.

If you’re searching for a sound currency to invest in, consider the Canadian dollar. Trading in foreign currencies might be tricky because it is hard to keep up with what is going on in another country. The United States dollar and the Canadian dollar most often run neck-and-neck when it comes to trends. States The US dollar is a strong currency.

Never choose a placement in forex trading by the position of a different trader. While you may hear much about that trader’s success, in most cases, you will not know about all their failures. Even though someone may seem to have many successful trades, they also have their fair share of failures. Come up with your own strategies and signals, and do not just mimic other traders.

Be sure to avoid the pitfalls of trading with uncommon currency pairs. There is more liquidity in the market when you trade in a more well-known currency pair. On the other hand, if you hold a currency pair that does not generally have a high level of activity, you run the risk of having to wait to long to sell it.

Control your emotions when you are in the midst of trading. Get a feel for what your trading style is and also figure out what ways allow you to thrive the most. Always be on guard and have a good understanding of the market before going all-in, this is the best way to achieve success.

Learn to calculate the market and draw your own conclusions. That’s the only way you can be successful using the forex market.

Try to learn about Fibonacci levels on ways on how they can help you with foreign exchange trading. Fibonacci levels give calculations and numbers that can help you in deciding when to trade. This will give you the best idea when you might need to make your exit.

You can make forex your career or you can use it as supplemental income. It depends on how successful you become at trading. The first step is to learn the basics of the forex market.

I’m not kidding when I say that this breakthrough has literally altered my view of how how to make money from forex” works! Check out this link to see what I’m raving about.