How to use Screener.in Export to Excel feature

http://www.drvijaymalik.com/2017/06/how-to-use-screener-in-export-to-excel-feature-tool.html

Coding can be a huge advantage

Does Rohan Jain still code?
Rohan Jain
Rohan Jain, CSE IITK'15, IIMA Batch of 2015-17
Answered Jun 8
I don’t need to code as much now as I used to code during my B.Tech days. Not even close. In fact, for all practical purposes, I don’t code at all these days.

There is an interesting anecdote related to coding that happened during my time at IIMA though. My batchmate and I were doing a project under a professor at IIMA. Both of us had done our B.Tech in computer science.

Prof: “Generate around 50 queries, run this regression and send me the results. Let us meet again in 3–4 days.”

She was probably expecting us to manually enter all the 50 queries. Instead, we created a Python script that generated 5000 queries instead of 50, inserted them into Stata software to run the regression for each query and collated all the output and results into an Excel file in a readable format. Everything in just a few seconds.

We ran that script for 5000 queries and sent her the data by the end of the day itself. The prof. was expecting that we would take a few days, so she was surprised when we asked for a meeting the next day itself.

She again gave us some more work, expecting us to take a week for that. We created another python script and sent results for 100 times the number of queries she had requested, again within the day.

The professor, visibly impressed: “If I had worked at this speed during my Ph.D, I would have probably taken only one month to complete my entire thesis.”

Knowing how to code can be a huge advantage.

Shankar Sharma - Bet on stocks that are loss making

Shankar Sharma’s mantra: Equity only if I can think of 100% returns

By Amit Mudgill

http://economictimes.indiatimes.com/markets/stocks/news/shankar-sharmas-mantra-equity-only-if-i-can-think-of-100-returns/articleshow/58983992.cms

Which is the best Indian stock to invest?

Amit Jeswani, Founder of India's 5th Largest Equity Advisory Company

Answered Jan 16

Hi i am going to give you a Portfolio of Stocks rather than one stock.

Today i am going to share Top 10 Stocks with you according to a strategy which is endorsed by Warren Buffet, written in “the little book that beats the Market” by Joel Greenblatt. Joel Greenblatt runs a hedge fund named Gotham Capital and has compounded capital at 40% for 20 years from 1985 to 2006.

In the Book, Joel Greenblatt gives out his Magic Formula. The Result’s of the Magic Formula in the US Markets have been Amazing and has delivered 30.8% between 1988 and 2004 with delivering negative returns only once.

SO WHAT EXACTLY IS THE MAGIC FORMULA?

The Magic Formula is Easy – Buy Good Companies for Cheap Valuation.

We Ranked all companies listed in Indian Stock market According to 2 main Factor’s of the Magic Formula

1. Good Companies that have High Return on Capital Employed (ROCE)
2. Cheap Companies that trade at a Low Enterprise Value to EBITDA Ratio (EV/EBITDA).

** Please note we have Excluded Holding Companies, Utilities and Financials.

Here is the list of top 10 stocks according to the Magic Formula.

Not all of these will be Multibagger, but these are good companies at below reasonable valuation. I haven’t Back tested this strategy in the Indian Stock Market, but in the US market this strategy has worked really well.

This is definitely not a Stock Recommendation but this strategy has worked really well. We will Review this strategy at the end of 2017. Incase your looking for the full Excel of This feel Free to Mail us at info@stallionasset.com and we will provide you for free.

Feel Free to Contact us on 02240033944

Stallionasset.com

What advice would you give to a beginner quantitative trader?

Timothy Gouskov, I write trade orders on paper, then throw them at an exchange really fast

Answered Dec 27 · Upvoted by Anirudh Joshi and Terrence Yang

Here are a few things I learnt when I was starting out.

• Understand that price can only behave in these two ways: Mean Reversion and Trending.
• You don’t need to know exactly what your strategy is at the start. One of the best things you have in the beginning is an open and un-biased learning about all the types of trading.
• Don’t be afraid of mathematics. This is a huge one I realised. Go and jump right into reading research papers and textbooks that are both directly to do with trading (statistics, algorithms etc), and also ones that aren’t (game theory, agent-based modelling, machine learning etc). Even if your mathematics is not that strong, you will still capture so many interesting ideas.
• Understand the difference/relation between simplicity and complexity. Your strategy/algorithm should follow this type of process: Simple question at the start (should I buy/sell now)…then onto complexity used in your model (to determine an answer)…then back onto a simple answer (buy now). Simplicity should always surround the complexity.
• Understand that a lot of people talk about a lot things. It doesn’t mean they’re correct. Trading is such a unique field and profession. You can succeed and fail through so many paths.
• Be cautious about “successful” traders, who give advice/resources at a price. Think about why they would rationally/pragmatically/morally and you’ll probably find some contradiction in the reasoning.
• Understand that the market is these two things at the same time: A social interaction between beliefs about a fundamental value, and, a complex system.
• Learn risk management in your portfolio.
• You will take losses. Think of them as an expensive lesson you just paid tuition for.
• In the beginning, backtesting is useless for you. It will only be useful, when you start to properly study about data sets. You’ll then appreciate why people have professions specialised in data.

DMart currently is at 160 stores, the total potential for such stores in India is 8,000

Ashok Maheshwari, one of the co-founders of DMart. 


Retail Business

Retail business is a high-volume, low margin business.

It is about constantly keeping what customers want on the shelf. What is seen on the shelf sells, and what sells has to be seen on the shelf.

To plan a store of 15,000 sft, one has to target a neighborhood potential of 20,000 families, each family spending a minimum of Rs. 2,500 in a store that offers basic day-to-day needs.

There can be atleast 8,000 such stores in India. DMart currently has about 160 stores.

Capital 

The way DMart was planned is that:

- the first 10 stores will fund the next 10 stores after 4 years of operation
- the 20 stores together will fund the next 20 stores after 8 years of operation
- the 40 stores will fund the next 40 stores in 12 years of operation
- the 80 stores will fund the next 80 stores in 16 years of operation

- Dmart will be have over 150 stores after 16 years of operation. This is what we predicted in 2002 and that is where Dmart is currently.

This strategy brings down the capital requirement and cost drastically.

Model

From day one, we wanted to open 'discount format' stores.

It is all about value proposition.

Before we opened the first store, we visited value stores like IKEA, Costco & Walmart.

***

Start-up / Partnership

(This is especially applicable when the other partner is more powerful. Ashok Maheshwari had moved out of the partnership after 5 years without any stake).

- Life and time are two great teachers

- You should always protect your rights

- You should document everything - even if it is your family. Keep it simple, yet don't take anything for granted.

- Choose a good partner. The business should not be sabotaged or hijacked.

- If a partner is involved in management, have a clear delegation of responsibilities and capital infusion dynamics.

So, the simple discipline for a start-up is have everything well-documented. 


http://economictimes.indiatimes.com/opinion/interviews/exiting-a-business-one-has-nurtured-is-always-painful-ashok-maheshwari-entrepreneur/articleshow/58583839.cms

Apple market cap is bigger than BSE, Brazil, Russia, Singapore, Malaysia, Mexico

The recent rally in the share price of Apple Inc has taken the market capitalisation of the technology giant to more than $797 billion at 10 PM IST, making it bigger than the combined market cap of all the 30 Sensex companies put together.

India’s bluechip index closed at a market cap of $784 billion, based on Monday's share prices. Apple, the most valuable company in the world, is the only company to have a higher market cap than that of the Sensex companies together. The Sensex accounts for 40 per cent of India’s total market cap.

Apple is also larger than the market cap of countries like Brazil, Singapore, Spain, and Malaysia.

In the league of companies with the top market cap, Apple is followed by Alphabet Inc and Microsoft, which have a market cap of $651 billion and $530 billion, respectively.

Despite reporting lower than expected earnings, shares of Apple went up by 3.7 per cent last week, pushing its market cap to record highs.

The rally in Apple was triggered by ace investor Warren Buffett’s statement that he had more than doubled his firm Berkshire Hathaway’s stake in Apple. His firm currently owns a 2.5 per cent stake in the technology giant. Expressing his confidence in the company despite softer sales in the recent past, Buffett said consumer loyalty for Apple was huge and hence there was nothing to worry.

Apple has gained 32 per cent year to date.

During the previous quarter, Apple added another $10 billion to its cash reserves, taking them to $256.8 billion, larger than the market capitalisation of General Electric (GE). This is roughly the size of the Indian mid-cap index in terms of market value.

http://www.business-standard.com/article/markets/apple-s-m-cap-exceeds-that-of-sensex-117050801417_1.html