I need Python Developer with Excel VBA knowledge for Stock Market Dashboard

Fixed Price Project | Posted



₹ 3500

Budget

17

Proposals

1048

Views

Active

Status

Project Details

I want an Excel Dashboard for Stock Market through Python. I have Fyers API so please check if you are comfortable on that.

Already have a python codes which is incomplete as of now. Need to complete it or you can create full from scratch.


Steps to start:

1) In Excel, there is a login sheet where i will mention fyers api details on click Login button it will check credential and if correct it will get login with Fyers API.

2) Then, on 2nd sheet, i will click on Fetch Historical Data button and start fetching & storing historical data of all NSE Future symbols (last 7 trading days). Then after all historical data fetched, click on Start button to start live data of all Future symbols and start filter on the basis of calculations with historical data based on:


Logic For Long:

Current candle Live Close Price (as per timeframe selected in sheet) > Previous day Close Price AND,

Current candle Live Open Interest (as per timeframe selected in sheet) > Previous day Open Interest AND,

Current candle Live Volume (as per timeframe selected in sheet) > Previous day Volume AND,

Current candle Live Close Price (as per timeframe selected in sheet) > VWAP


Logic For Short:

Current candle Live Close Price (as per timeframe selected in sheet) < Previous day Close Price AND,

Current candle Live Open Interest (as per timeframe selected in sheet) > Previous day Open Interest AND,

Current candle Live Volume (as per timeframe selected in sheet) > Previous day Volume AND,

Current candle Live Close Price (as per timeframe selected in sheet) < VWAP


5) In 3rd Sheet, Live Options Chain of selected symbol data will show as per the excel design. Includes Data Recording as per timeframe selected for data.


6) In 4th Sheet, Gainers/Looser data will show: Top Gainers, Top Looser, 52 Week High, Oi+Price Gainer, Oi+Price Looser, Open=High, Open=Low


Please read my requirement and budget before apply as I can increase my budget upto 20% maximum but not beyond this so please apply only if you agree on this. Preferred Indian and who knows python and excel properly and can work without giving any excuses on delivery time. Knowledge of Python, Excel VBA, SQL required.

About the Client

Country
India

India

Reputation

0

Projects Paid
1
Projects Posted
8
Total Feedbacks
0
Feedbacks
0%
Total Spent
₹ 2000
Client Type
Individual

Member since 

Copyright © 2025 | Truelancer.com