Automating Every-day stock market reports

Investor Toolkits
1

Hii ValuePickr Community,

I am Venkata Sai, a 25 years old software engineer by profession who got curious mind in stock market and investing , i am following this community from last 2 years

for every day stocks price changes , some days i have no time to check the top gainers and losers of that particular day. so i started generating the excel report using the Bhavcopy data from the NSE website to generate the report of top 50 gainers and losers of that particular day , and send the copy to gmail. It helped me in simplifying the research process.

the full project plan of this reports is

  1. Generate the top 50 gainers and losers from the NSE Bhavcopy data
  2. After generating searching any news/articles related to these filtered stocks in the internet in the past 24 hrs
  3. Extracting the data from the articles and addding the news columns beside the stock as reason for gain/lose of stock value of that particular day

Currently step 1 is done and i am processing the step 2

below i added the format of the excel file , if there are any suggestions or another metrics i can in the report which will further helps in simplifying the research , i am open to take it

nse_report_2026-10-14.xlsx (36.6 KB)

2 Likes
2
  • Make some filter Mcap otherwise there will so much noise in the report. Or you can do Mcap wise report like top 30 from so to so Mcap etc.
  • Just news data will not suffice, make sentiment point analysis with help of AI like +5 is positive , 0-Nuetral, -5 is negative
1 Like
3

@chavda thanks for your suggestions

Making report based on Mcap make’s it very informative. I will implement it ASAP

While adding the summary for the specific stock, I thought of adding the pros and cons but some what not getting the expected results from AI, trying to use other models which gives more accurate data

4

Sir,How do this automation on excel automation process and important stocks news automation, please share execution process,I want do this process,please share the detailed process, please guide me sir…,I am beginner of this automation process.., Thank you Sir..

5

i forgot to mention if anyone wants these daily reports you can send me your email, i will add you to that list of excel sheet receiver list

@trinadh can you message me, i will share the in detail approach how to generate these reports, as i dont want to spam here , if you get some basic doubts

6

What is the exact purpose of segregating and filtering of top gainers and losers? Are you looking at arbitrage based on momentum? Based on the daily top gainers and losers, how long would a tracking window of the movement for the respective stocks do you plan on having? Is your project focused on a multi day tracking window (before and then after) or the respective day window news (information) / trade data?

Along with that as someone had mentioned, what would your filter strategy be? Based on market cap, volume or combination of both or other such factors?

Now while creating a list of factors for affecting the movement, have you segregated the information based on company fillings, Regulator policy changes from regulators (RBI, SEBI, NABARD, IRDAI, FSSAI and many more…), fillings / press releases/ consultation papers. Along with that Rating Agency (CRISIL, CARE, ICRA) reviews, updates, rating revisions/reaffirmations.

All data can be characterized/segregated/sorted on the basis of macro and micro or maybe directly related, indirectly related or non-related but impactful. Eg. Impact on company due to internal performance such as better earnings, defaults on credit, capex initiation, capex completions, accidents / natural hazards. Impact on company due to industry wide regulations or failure of industry participant (any industry wide stresses/benifits ). Non direct exposure due to falling rupee and high FII holding which might be getting liquidated, Rising yields in US, Repo rate increase, Oil shocks, Wars etc.

When working with news related information based tracking, there are problems with information accessibility timings, validations issues, requires multiple scrappers / API access and information translation mechanism at rapid pace (You might need somewhat type of a Bloomberg terminal or you might end up building one if you are crazy enough to work on it.) It is quite difficult to have good information scraping mechanism when you go beyond NSE and BSE feeds for respective stocks/scrips.

People tend to rather trade with numbers and statistics based on (algorithms) strategy which have been properly back tested and have a consistent win ratio of >50% on say 10000 or maybe a million trades.

For the filtered or unfiltered list of scripts/stocks, do you have a plan on collecting other than news feed information such as OHLCV data? Do you plan on tracking momentum / regime indicators, RSI, MACD or various such basic indicators for each day?

Note: I have very limited or close to no exposure to trading or investing. The above information is from when i had tried working with or faced problems while exploring a few arbitrage strategies. It sounds quite interesting to look at top gainers and losers for the day and identifying the information which might have had potentially moved the volumes and gains/losses the most and see how things play out in the following days for the respective stock.

7

Also apply filter based on delivery persentage as we’re flooded with algo, Swing trade, scalper…all the shit we will be hard to know whether the volume is real or fake so to avoid the noise delivery volume is very important. For reference check repack durable December trades. This is pure technical analysis can be done

Importantly why sudden spike in volume is the key. Without knowing that it’s hard to believe any spike will sustain. Sometimes without any actual announcement stocks will raise but we should understand what macro micro factor triggered this. That will help to determine is this one off or structural. Yean this can only be possible when we read business and fundamentals.