Search results

Sajan, I know I've bothered you enough already. But had this thought. Is there a way I could "highlight" (fill colour) the Buy and Sell rows in different colours, say orange for buy and green for sell? It would thus be visually possible to differentiate between buy and sell transactions. Could...

I copied the formula from your message, and pasted it in the formula bar in the spreadsheet. Not sure that's what you mean by pasting the formula as html.

Just a question, Sajan. When I copy your formula into the formula bar in my spreadsheet, the font changes from Calibri 11 to Verdana 11. How come? Because the font you have used in your post above, is Verdana? Funny, isn't it that Excel should copy not just the formula, but the font used as well?

Thanks again, Sajan.

Appreciate your gesture, Sajan. Thanks a lot. For the stock trading part, there really are only choices B (buy) and S (sell). As for the DCF part, I note that your formula is similar to mine, except for the $ part, which makes more sense. If at all DCF = CMP, then the call would be "hold"...

Narayan, Appreciate your response. My post was very much aimed at resolving a problem I faced. I shared my question here so that others facing a similar problem would also benefit. Attached is an example file. Your feedback would be welcome. Nitin

This is forum for brain-storming. If anyone can share ideas, I would appreciate. I do not think this is an "e-commerce" site.

Hi, I am a stock trader, and maintain a record of stock purchases and sales in a spreadsheet, like most people do. I have a question: Is it possible to write a formula in excel, which will (a) add brokerage commissions to the cost of shares purchased, for each transaction and (b) reduce...

Dear Chandoo and Hui, The launch of MS Excel 2013 is around the corner. Have you written a piece on the new features in Excel 2013, particularly useful in financial analysis and modeling? If not, could you please do it in due course, so that readers benefit. Thanks!

Thanks Hui for the quick reply. In fact I've already subscribed to Chandoo's regular updates over email. You had sent me the Monte Carlo files over email, since I was unable to load the ones on the link on Chandoo. Hope it is alright if I come back to you in case I need your assistance on form...

I am building a financial model. I intend to add a scroll bar for certain values in the P&L Statement, such as Revenue growth, COGS, EBITDA atc. I would like to add scroll bars to each of these rows, so that I can determine values for revenues, using different values of revenue growth, say 5%...