BC TRADING

Saved by @itzpradeep

Anon
@AnonTrader21 3 years, 8 months ago 888 views

Save to PDF Share See On Twitter

A thread on getting intraday (any timeframe) data to excel without any coding. Limited to only last 60 days. Fetches from zerodha chart.

👇

1. Open the chart on zerodha web in chrome. Right click and select 'Inspect'. Click 'Network' as shown in this pic.

2. Right click on the last entry on the table you see and click 'copy as cURL (bash)'

3. Go to website https://t.co/f8rhwoGLUc and paste on the left box and click 'Run'

4. The output below candles written on right of box is the ohlc, volume and oi data. Copy and paste to excel.

5. You can change the dates on the first line of code pasted on left box and run again to get the data.

More from Trading

Dr. Ellie Lockhart is ...
@BootlegGirl

OK, I guess I have a thing to say about the stock market. I have done kind of what these Reddit folks are doing with it, in that I have invested in the stock market when I was not at all rich, using parts of my paycheck that it probably wasn't wise to risk. I don't now. (thread)

But, like, it worked out okay for me. I even shorted some stuff. I didn't coordinate with anyone or whatever, but I don't think on the individual level the stock market is *inherently* malicious. If you're privileged, you're going to be exposed to it (through 401ks, etc.)

And I don't think it's wrong for people to try to make money off of it outside of the 401k/retirement context that's socially normal, *especially* if they're desperate like I was. There *are* strategies that you can use that, while risky, aren't exactly like gambling

Like, gambling is risky in a different way. You are always working with a fairly consistent set of probabilities in gambling, and they're never in your favor (outside of grey area gambling like between friends, where you could hypothetically actually still card count)

Anyway, like, on shorts: I don't think they're evil. I think they're dangerous. For an individual, a short always carries a small risk of individual bankruptcy. There's USUALLY not even a huge upside to them; they're not mystical or magical, they're basically reverse "longs"

10-K Diver
@10kdiver

1/

Get a cup of coffee.

In this thread, I'll help you understand Geometric Expectations.

2/

Imagine we have an investment opportunity.

If the investment goes well, we get to double our money.

But if it goes badly, we'll end up losing three fourths of it.

There's a 50/50 chance of either outcome.

The question: is this a good bet or not?

3/

A simple way to approach this question is to calculate the bet's "expectation".

For every $1 we bet, there are 2 possibilities:

1. The lucky case, where we double our money and end up with $2, and

2. The unlucky case, where we lose (3/4)'th to end up with just $0.25.

4/

Each of these outcomes is equally likely.

So, on *average*, every $1 we put in turns into ($2 + $0.25)/2 = $1.125.

This is a *positive* 12.5% return.

Such bets are called *positive expectation* bets. On average, we expect to *make* (rather than *lose*) money on them.

5/

Suppose we could take many turns betting at these odds.

In any one turn, we could of course lose money.

But because our bet has positive expectation, *over time* we expect to make money.

Advertisement

$Cem Karsan \U0001f950$

Cem Karsan 🥐
@jam_croissant

1/x Vanna is back & ready to turn back on the charm! Overnight the market hit our weeklong target of **3705 and pulled back... We were able to take profits & play for a bit of morning digestion. It’s been a nice +3.5% in a week w/a few extra scalps along the way...But the best

2/x part has been the gift of Vol compression, which along w/ short Vol profits, has given us significant calendar expansion & dispersion opps, as predicted. I expect this to continue this week as well, as Ivol oversupply should continue to be the dominant force until 12/11.This,

3/x paired w/ the significantly increasing Vanna & Charm flows, will make it hard for any decline until 12/14 to catch meaningful momentum. This said, the narrowing of 20 day RVol as well as the 2 stddev of the 20 day just overhead should cap any rallies, given the dramatically

4/x overextended retail (8-day SMA of P/C equity is the lowest in 20 years) & institutional positioning. This push/pull, should ultimately keep the market fairly pinned this week...Jan 8th call’s on back are incredibly cheap w/ a GA runoff event straddle of only $55, which given

5/x the potential macro-cyclical consequences of the next 2 years of fiscal stimulus seems absurd...& In terms of a more short term trade,Tesla Vol is either too high or 12/18 on back calendar spreads in the SPX are too low, as there’s no premium being priced in for the inclusion

$Shravan Venkataraman \U0001f525\U0001f680\U0001f4b0$

Shravan Venkataraman 🔥...
@theBuoyantMan

Working on some execution optimisation related backtesting. I have so far been executing with market orders only. Going towards higher lot sizes, I'd like to optimise for minimal slippage.

First off, on NSE, if you place a market order, you get filled at the best bid/ask right?

If we want to optimise this, the first non-creative idea one can think of is, slicing the order into different lot sizes, and placing a limit order for each slice at the mid point of current best bid & ask.

But this requires your latency to be the least.

Why would latency affect it?

I looked at tick historical data, and there are more than 18-20 ticks in a second (auction and quote combined).

Even if you keep 10 ticks per second, your best bid/ask can shift from the time you place to the time exchange receives the order.

So, the next best thing that people can do is place tranches of orders every 1s, 3s, 5s, 10s, 15s - in their preferred time range, and get filled at the midpoint or best-bid+1/2/3/4/5 in the depth.

What you need is liquidity.

But if you're trading breakouts, then it's highly likely that your limit orders may not get filled if the action is too fast.

So, a retry mechanism is required in such cases.

If nothing works, you convert your orders to marketable and get filled at worse slippage.

Aditya Todmal
@AdityaTodmal

How to save tax when income is above 50 lakhs?

Here are 9 benefits of trading in a corporate account: 🧵

Collaborated with @niki_poojary

1. Make a Pvt Ltd Company.

Form a company with family members and trade under it. The family members should be directors of the company. Will explain why later.

Why form a company?
You will only need to pay 25% flat tax. Individuals have to pay 30% tax above 10 lakh profits.

2. Surcharge Benefits:

You will be charged a lower surcharge in a corporate account.

Check the picture below:

Total Tax Outlay:

The total tax outlay for individuals is 30% plus surcharge. If you really earn a lot (10 cr +) then you will be paying 42% tax.

Whereas in a company you'll be paying a maximum of 28% tax.

This is how rich people save a lot of their money by paying low taxes.

3. Expenses can be deducted.

All expenses can be deducted from a company account.

Companies:
1. First make a profit.
2. then deduct the expenses
3. & Pay tax on the remaining income

Individuals:
1. First Profit
2. Then Pay tax
3. Expenses with whatever is left.

You May Also Like

Simon DeDeo
@SimonDeDeo

This is a pretty valiant attempt to defend the "Feminist Glaciology" article, which says conventional wisdom is wrong, and this is a solid piece of scholarship. I'll beg to differ, because I think Jeffery, here, is confusing scholarship with "saying things that seem right".

Imagine for a moment the most obscurantist, jargon-filled, po-mo article the politically correct academy might produce. Pure SJW nonsense. Got it? Chances are you're imagining something like the infamous "Feminist Glaciology" article from a few years back.https://t.co/NRaWNREBvR pic.twitter.com/qtSFBYY80S
— Jeffrey Sachs (@JeffreyASachs) October 13, 2018

The article is, at heart, deeply weird, even essentialist. Here, for example, is the claim that proposing climate engineering is a "man" thing. Also a "man" thing: attempting to get distance from a topic, approaching it in a disinterested fashion.

Also a "man" thing—physical courage. (I guess, not quite: physical courage "co-constitutes" masculinist glaciology along with nationalism and colonialism.)

There's criticism of a New York Times article that talks about glaciology adventures, which makes a similar point.

At the heart of this chunk is the claim that glaciology excludes women because of a narrative of scientific objectivity and physical adventure. This is a strong claim! It's not enough to say, hey, sure, sounds good. Is it true?

$Ranvijay Singh\U0001f1ee\U0001f1f3$

Ranvijay Singh🇮🇳...
@ranvijayT90

#Thread Two divine forms of Khatu Shyam ji...

On the day of Amavasya, devotees get the darshan of Shyam Baba in Shyam varan (black color). In ordinary days, the form of Baba is saffron. The reason for this is a custom. The real head of Shyam Baba which had appeared from Shyam Kund is of Shyam varan.

Every day Shyam Baba's grand Shringar is done by Pujaris. The main part of Shyam Baba's shringar is Tilak. This Shringar is done by the members of Nij Mandir sevaks. The sevaks of the Nij Mandir do sandalwood tilak to Baba everyday in the auspicious time.

This Divine Tilak is applied from the forehead to the nose. When Baba is given a bath by sevaks, this tilak comes off. Then in the auspicious time, the sevaks again apply tilak to Baba.

There is no auspicious time on the Amavasya. Because of this, tilak is not done on that day. That's why devotees have darshan of Shyam Baba on the Amavasya only in the actual real form (Shyam Swaroop). Baba's tilak is done on Amavasya only on the day of Deepawali.

Advertisement

Vibhu Vashisth
@VIBHU_Tweet

LACHIT BORPHUKAN : AN UNSUNG WARRIOR OF THE AHOM KINGDOM & THE GREAT BATTLE OF SARAIGHAT

Originally named as Lachit Deca, Lachit Borphukan, the fierce and invincible Ahom Commander, was born during the early 17th century at Betioni in the Golaghat district of modern Assam.

His father, Momai Tamuli Borbarua was the ‘Governor’ of the kingdom and also ‘Commander-in-Chief’ of Ahom army under King Pratap Singha during his reign starting from 1603 to 1639. Lachit received military training from an early age and joined the Ahom King Jayadhvaj Singha...

...(1648-1663) as a scarf-bearer. The post ‘scarf-bearer’ or ‘Soladhara Barua’ is considered as a part of the incumbent king’s personal staff. Owing to his military training Lechit was appointed "Ghora Barua", Supdt. of the Royal horses. When Chakradhwaj Singha became king..

..of Ahom dynasty in 1663,he appointed him Suptd. of The Royal Guards &finally he was appointed as Borphukan by the king.Then onwards,he was known as Lachit Borphukan.Borphukan used to be top councillor in Ahom Kingdom. This position was embedded with executive & judicial powers.

Assam was facing incessant Islamic invasion since Jan1662, when Mughal General Mir Jumla II attacked Ahom capital Gargaon. He never defeated Ahom king Jayadhwaja Singha as king retreated to hill &continued Guerrilla warfare.Prolonged fight &prospect of stalemate disturbed Jumla.

$TXgrlWatching\U0001f4bb\u2694\U0001f6e1$

TXgrlWatching💻⚔🛡...
@VeritasTXgem

Thread A History lesson for the MOAB:
1. The United States of America is not and has never been a Democracy, we're a Federal Republic tied together by the capital Laws of the Constitution.

Everyone in the country is about to get a harsh lesson on what this really means...

2. In 1871, February 21: Congress Passes an Act to Provide a Government for the District of Columbia, also known as the Act of 1871.

With no constitutional authority to do so, Congress creates a separate form of
government for the District of Columbia.

3. A ten mile square parcel of land (see,
Acts of the Forty-first Congress,” Section 34, Session III, chapters 61 and

4. The act — passed when the country was weakened and financially depleted in
the aftermath of the Civil War — was a strategic move by foreign interests
(international bankers) who were intent upon gaining a stranglehold on the coffers and neck of America.

5. Congress cut a deal w/ the international bankers(Rothschilds of London) to incur a DEBT to said bankers. Because the bankers were not about to lend money to a floundering nation w/out serious stipulations, they devised a way to get their foot in the door of the United States.

Sahil
@sahilypatel

Want to do an MBA for free ?

A thread 👇

1) Leadership: Foundations of Teamwork and Leadership

School: wharton

2) Marketing: Marketing Management

School: wharton

3) Microeconomics: Microeconomics for Managers

School:

4) Financial Theory

School:

Category Partner: Enkryptopedia