Posts Tagged ‘stock market’

How To Use Excel For Trading

Wednesday, August 12th, 2015

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.

There are many ways to use Excel for trading, and your first consideration should be narrowing down your intended use of the tool. Will you use it to compute trading signals? Is your interest importing data automatically into Excel? How about calculating profits, drawdowns, risk and other analytics? Do you have many open positions you need to track? Would you like to integrate Excel with a charting platform? Are you interested in automating your workbooks with VBA to increase speed and accuracy?

Bringing price and volume data into a spreadsheet automatically is one way to implement Excel for trading. This uses DDE links to a price data database, either an internal or vendor provided database. DDE links are efficient and can capture fast moving prices (with certain limitations relevant to algorithmic trading). Importing price and volume data into Excel with web query functionality is an alternative to DDE links. This works if you want to capture a smaller volume of prices or economic data from websites like Yahoo Finance, Google Finance, etc. You can also import data into Excel using the Data from Other Sources function. This connects to SQL Server, MS Analysis Services, XML files and ODBC — this is a good option for the technically minded.

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 about Excel for trading? Visit this site for a FREE GUIDE on building trading models in Excel.

Investing Secrets The Pros Don’t Want You To Know

Sunday, June 8th, 2014

Stocks are a little more cash. You may be surprised at how much money you can grow your wealth with stock investment. Keep reading to learn some tips about the stock market. Keeping it simple applies to most things in life, and this applies very well to the stock market.

Set realistic expectations when you begin to invest. It is common knowledge that stock market success and overnight riches do not happen instantly, which often leads to serious loss of capital.

Watch the markets closely prior to jumping in.Before you make your initial investment, try studying the market for a while. The best way is to monitor it for about three years before investing. This will give you a view of how the market is working and increase your chances of making wise investments.

If you want to build a solid portfolio that delivers good yields over the long term, be sure to have stocks from various industries. Even while the market grows at a steady average, not every sector sees growth each year. By having different positions through different sectors, you can benefit from all growing sectors and plant buying seeds in retracting industries that are undervalued.

It is very essential that you always looking over your portfolio a few times a year. This is important because the economy is changing all the time. Some sectors will do better than others, while other companies could even become outdated. The best company to invest in may vary from year to year.This is why it is important to keep an eye on your portfolio and adjust it as necessary.

An online broker is a good choice for those who are ready to handle your investment research yourself. The overall fees and commissions for an online brokers are much less than it would be for a discount or full service brokerage. Since your objective is to increase profits, the lowest possible operating costs are always ideal.

If you’d like a broker who gives you more flexibility,” look for brokers that can provide both traditional and online services. This way you can just dedicate half to a professional and just handle the rest of your stocks to a professional manager and take care of the rest on your own. This can give you the best of both worlds in your investing.

Keep it simple and small when you are beginning. It can be tempting to diversify right away and try everything you have read about or learned, but if you’re new in investing it is good to focus on one thing that truly works and stick to it. This will save you to build your portfolio to meet your goals.

Invest in stocks that are damaged, not damaged companies. A short-term fall in a company’s stock is a great time to buy, but the drop has to be a temporary one. When a company has a quick drop due to investor panic, there can be sudden sell offs and over-reactions which create buying opportunities for value investors.

If you plan on using a brokerage firm for your investments in the stock market, see to it that they are trustworthy. There are lots of firms who promise to make you tons of money investing in stocks; however, you will often find that they are ill-equipped to deliver on their claims. Research the brokerage firms online before settling on one.

Don’t invest in a company you haven’t thoroughly researched.

Start investing with stocks that have more secure investment options. If you are just starting out, your first portfolio should consist of stocks of large companies to minimize the risk. Smaller companies may grow quickly, but they’re very high risk.

Start your investing with stocks that are proven and trustworthy before branching out into riskier and potentially more secure investment options. If you are new to the market, your first portfolio should consist of stocks of large companies to minimize the risk. Smaller companies have great potential for growth, but these investments are more risky.

You can generate a lot more income through stocks. Educating yourself on this complicated subject is the best way to increase your profits. By using the tips and techniques you have learned here, you will have a head start on the path to stock market success.

Looking to find the best stock market investment strategy, then visit www.workwithdannyyounes.com to find the best advice on the best way to invest money for you.

Investing 101: Everything You Need To Know To Get Started

Sunday, April 27th, 2014

Becoming a stock market trader is a very attractive proposition, but it should be given careful consideration. This article will discuss some of the most important tips that you should consider before purchasing stocks and risking your hard earned money. Keep reading to learn more about the ins and outs of stock market investing.

Basically when investing in stocks, the keep it simple approach works best. Simplify your investment actions. Whether it is in examining past performance for prediction, or doing the actual trade, avoid over-complication of the process.

You should always investigate the fees that you will be liable for from a broker before you register with them. You want to look into both entry and deduction fees. You will be surprised at how fast these can add up over time.

If you’re comfortable doing the research yourself, use an online broker. Online brokers have cheaper fees since they let you do most of the work. When you are just starting out, you will likely prefer to invest your money in stocks rather than the investing process itself.

Once you have decided on a new stock to try, be sure to only invest a small percentage of your portfolio into that one stock. It is unwise to invest more in one place. With lower investment, you will greatly reduce your potential for losses.

Do not invest too much money in the company for which you work. Owning stock in your employer can be risky. If something happens to the company, your stock investment and wages will be both in danger. However, if you get a discounted rate on showers, you might have good reason to buy.

Stick to a basic investing plan when you are new to investing. It may be tempting to go all in right away, but when you are new it is wise to educate yourself on what the best investment strategies are. Although you may not make a ton of money with your simple plan, you don’t risk the substantial losses that can come with inexperienced complicated investing.

If you are new to the stock market, you need to realize that you can’t make huge amounts of money quickly. If you give up on a company’s stock to use, you can lose out on a lot of money. You have to be patient and take your time.

You can also test out short selling. This strategy involves borrowing shares of stock from your broker. The investor will borrow the shares under the agreement that they will later deliver the same amount of shares back. The person who is investing will then sell their shares so they will be bought again when the price of the stock falls.

Patience and wisdom are of critical importance and go hand-in-hand when you are investing in the stock market. Although business education isn’t needed, staying knowledgeable on your investments is. You can begin to make money quickly with these tips.

Want to find out more about this proven stock market strategy, then visit Work With Danny Younes site on the best short term investments.

The Investor’s Scoop On Book Value Vs Market Capitalization

Wednesday, April 23rd, 2014

The difference between book and market capitalization and how it is calculated is a matter I’ve addressed elsewhere. Space constraints prevent repeating the explanation at any length.

It’s enough for our purposes, here, to observe that book value is a company’s assessment of its own equity: determined by subtracting the value of total liabilities from the value of total assets. The value of that equity though is determined differently on the market: it generally responds to the shifts in demand, since it is rare for new shares to be issued. (Further detail on how these values are calculated can be found through the link at the end of this article.)

The book value of the company will be a more stable price. However, if it is subject to sound accounting practices, it too will change with the passage of time. An obvious example would be in the case of the depreciation of infrastructure. Stock market prices, though, as we all know, do not reflect such stability or orderly gradated adjustment. Instead, they fluctuate – and often far and fast.

Discussion of this constant movement of stock prices will have to wait for another occasion. Here we only want to understand the reason for the discrepancies between book and market capitalization and the relevance of that difference to investing.

Putting those reasons aside, just briefly, the basic principle involved is simply that the market – by which, of course, we mean the buyers and sellers of companies’ shares, through constant bid-ask operations – hits upon prices disputing the equity value that the company assigns its own capitalization.

The difference may be of course either more or less than book value. The potential reasons for the discrepancy may be any of many. It can be as simple a matter as brand recognition and estimation. Should a particular brand have a high enough cache or reputation with the relevant consumer base, virtually identical products may be differently valued in the market, allowing the stronger brand to successfully charge more.

If this results in consumers willing to pay a brand premium for the product, capital otherwise hardly distinguishable from competitors effectively becomes more valuable. In such situations, obviously, there is no dispute about the literal book value of the company’s assets. Nonetheless, though, further considerations may lead share traders to value the shares more than suggested by the book value.

Many discrepancies, however, are indeed a function of markets disagreeing with the stated book value of a company’s assets. An example would be the situation in which a company’s assets include undeveloped land. If the market, and the company’s accountants, has valued the assets at prevailing real estate rates a potentially dramatic divergence of value could result if enough share traders re-evaluate the land. Say, for instance, they become convinced that the region in question is poised for a major real estate boom. At that point traders may now consider the land a significantly undervalued asset on the company’s books.

Recognizing such undervalued shares sufficiently in advance is a means to great profits. Those who have early enough recognized the situation bid on the company’s shares in great numbers. The more shares one can purchase at the undervalued price the more total profit one stands to make whether the long term intent is to resell at the higher price or collect the increased dividends expected. In the process, of course, this raised demand for the shares pushes up their price. The resulting market capitalization value is thus increased considerably over the book value.

It can likewise work the other way around. If the company is in a business which a large enough number of share traders become convinced will soon be subject to new, onerous regulation that will entail massive compliance costs, their conclusions could be that the company’s book value of its equity insufficiently accounts for its actual liabilities. The shares are considered overpriced and shareholders start lowering prices to unload them and cut their losses.

As we’ve seen, then, numerous potential reasons may lie behind the discrepancy between book and market value. In all cases, though, this discrepancy reflects the judgment of a large-enough number of traders that the company’s actual value is not accurately reflected in its book value. For the successful investor, early recognition of such a situation and sound assessment of its validity is the key to successful investment strategy, leveraging market capitalization against book value.

The illustrations above provide plenty of different manners in which diverse skills and insights can aid in such leveraging: e.g., familiarity with the real estate market, the government’s legislative agenda or popular taste. Possessing insight into any of these matters, or numerous others, can provide the opportunity to benefit from a book value that inadequately appreciates the true or immanent value of a company’s equity. When you discover such a discrepancy the opportunity for profitable investment – whether under or overvalued – is available.

It is in this way that knowledge of the difference between book value and the market capitalization unlocks vital investment opportunities. If this discussion presumes knowledge about market capitalization with which you don’t feel quite up to speed, I’d suggest having a look at my What is Market Capitalization article.

Investors who want to leverage profits from mistakenly valued book equity need to follow all the hottest tips at the Market Capitalization blog. Wallace Eddington is an insightful commentator on markets and finance. His recent article on fiat currency and inflation is a must read for those looking to make sound monetary investments.

Make Money With These Safe Investment Tips!

Saturday, March 29th, 2014

Many ponder the idea of successful stock investment, but you should not do so casually. This article discusses some of the most important tips on safe investments. Keep on reading to learn more.

Keeping it simple applies to most things in life, and this applies very well to the stock market. Make sure that you’re spreading out your investments around a little. If you have everything you’ve invested in a single stock and it flops, then you have just lost your entire investment and your loss is total.

If you become unemployed or have high medical bills, investing safely in the stock market is the right way to go. The stock market can pay of your home mortgage and other bills that you may have.

When you make the decision as to which stocks you are going to invest in, only invest five to ten percent of your total capital into that one choice. This is very important in regards to safe investments. By doing this you protect yourself from huge amounts of money if the stock crashes.

You may consider short selling the stock to make money. Short selling is when you sell the stock and buy it back later at a lower price. You must know the risk involved when selling stock short.

Only go with brokers that offer discount brokerage. You must know your skills in the stock market and trade within your skills. You may have knowledge about renting an investment property, but are you knowledgeable in regards to oil companies. This is where a stock broker can come to your aid and help you out with safe investments.

Start investing with larger companies that are proven and trustworthy before branching out into riskier and potentially more secure investment options. If you’re new to trading, begin with a portfolio that contain blue chip stocks, as these are normally lower risk. Smaller companies have greater growth potential, but these investments are more risky.

If you begin to second guess yourself or panic when making decisions to invest in a stock, then you will lose a lot of money. Also review your portfolio frequently as the stock market tends to change very frequently.

Don’t be totally discouraged of your safe investments when you’re just starting out. A lot of people who are new to the market tend to get disappointed if things happen differently than they expect or would like. It takes a good deal of practice, knowledge, experience and knowledge to professionally invest, so don’t be too hard on yourself.

Many people are tempted by the stock market, with the opportunity to make a lot of money. However, you must educate yourself on safe investments, and make wise choices when investing. Follow this article’s advice so you can ensure you make wise investment decisions.

Looking to find the best safe investments, then visit www.workwithdannyyounes.com to find the best advice on stock market.. Also published at Make Money With These Safe Investment Tips!.