Tag Archives: personal finance

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.

Bobby Jain Credit Suisse & The Idea Of Long-Term Planning

When it comes to constructing financial plans, the term “unique” should be brought to the forefront. The reason for this is because there isn’t a single plan that works for everyone, which is understandable when given the fact that everyone has unique needs and responsibilities to account for. In terms of structures, though, you may find that many of them are largely similar. In order to construct a plan for the long term, here are some ideas Bobby Jain Credit Suisse can bring to your attention.

If financial planning is a venture you’d like to tackle, you’re going to have to focus on taxes to start off. Even though this may seem like a challenging prospect, it’s fortunate that the services of Bobby Jain Credit Suisse exist to help this process along. Keep in mind that not everyone understands the extent of tax planning, which is why it’s important to figure out the best payment methods for the future. I am sure that authorities like Bob Jain can help here, as well as in other fields.

When it comes to the distant future, wealth management planning is going to have to be undertaken. Specifically, this is done in order to see where your belongings will go after you are gone. In order for this to be done well, document review is going to have to be done by the aforementioned authorities. It’s also worth noting that there is an element of strategy to be had here, which is why many individuals may find themselves tripped up when going about financial planning.

You may also wonder about the financial status of your family members. Fortunately, financial planning will not only be able to understand this concept but work in order to ensure that it is covered as well. Life insurance, for example, is an element that will be able to help you, in addition to your family, so that financial stability will be a certainty. No two financial plans will be the same and this aspect only helps to further this idea along.

With these concepts in mind, you can probably see why Bobby Jain Credit Suisse supports the idea of long-term financial planning. However, there’s a deeper level of complexity to be found here that very few will be able to overlook once they see the planning conducted. Do not feel as though you are without help, though. It’s just a matter of consulting the best parties which possess not only the strongest services but the most intelligible minds as well.

Get in touch with Bobby Jain Credit Suisse for specifics about creating the finest financial plan or click here for other details.