Dhan api, excel and python

I am reaching out to seek some assistance regarding an issue I encountered while attempting to place orders using DHAN API and Python.

After conducting thorough research on Google and YouTube, I was disappointed to find that there is limited available information on using DHAN API with Python and Excel. I did come across a Zerodha Excel file with Python integration, but it did not specifically cater to DHAN API.

Considering your expertise in this field, I was wondering if you or your team could provide me with an Excel file that supports DHAN API integration with Python. Having such a file would greatly simplify the process of placing orders through the DHAN API, streamlining my workflow.

I appreciate your time and assistance in helping me overcome this challenge. If you are unable to provide an Excel file directly, I would be grateful for any guidance or resources you can offer to help me achieve my goal.

Darvas box Excel Google Drive Link

1 Like

Hello @JayDalwadi

Glad to see you exploring Dhan APIs. Can you please confirm what do you require the Excel file for? Is it for fetching market data, or doing Excel based trading?

i am a trader who has been using the Darvas Box Excel sheet for managing equity shares. I find the tool extremely useful, particularly in setting up GTT (Good Till Triggered) orders based on the high of the last week for each script.

Currently, I am managing 29 equity shares in the Excel sheet, and every Friday, I manually set GTT orders for each script based on the high of the last week. This process is becoming quite time-consuming, and I am reaching out to seek your assistance in streamlining this task.

I would greatly appreciate it if you could provide guidance or help me modify the Excel sheet to allow for setting GTT orders for all 29 scripts in a more efficient way. Ideally, I am looking for a solution that enables me to set GTT orders for multiple scripts at once, saving me time and effort.

If necessary, I am more than willing to share additional details, such as the Zerodha API Python Excel sheet, to facilitate a more targeted and effective solution.

Thank you very much for your time and support. I am confident that with your expertise, we can find a more efficient way to manage GTT orders for multiple scripts in the Darvas Box Excel sheet.

@JayDalwadi

Got the use case that you are trying to solve here. It will be great if you can share the resources at api@dhan.co, will take a look.

When it comes to customising strategy or creating custom script, we might not be able to provide you with the same, but would definitely look at how Dhan APIs can facilitate the same for your excel sheet.

I have already sent email but not getting any update from dhan.

Hello @JayDalwadi

Will check the same and update you. As mentioned, it might not be possible for the team to make custom scripts, but if a library can be built around the same, will definitely take that up.

Hire a Coder. Dhan as a broker cannot provide such offerings