How to pull realtime data like stock prices in grid view in windwos aplication C#

Question

0.00/5 (No votes)

See more:

hello friends can any one give me concept or any link to pull data from excel wich have stock market reat time data changes/update
i want to display data in datagrid with real time changes .
thanks

What I have tried:

i have try and display online data in data grid but it was not updating in realtime..

Posted 2-Jan-21 19:39pm

Member 12643851

Updated 2-Jan-21 20:41pm

Add a Solution

Comments

RickZeeland 3-Jan-21 2:36am

To get online data you probably need to use some API, try to get this information from the supplier of the data. If there is a website try to find the information there.

Member 12643851 5-Jan-21 8:32am

i think it can be done using DDE,socet programing but hoow to connect third party software like broker terminal to access stock prices in grid view

RickZeeland 5-Jan-21 12:38pm

That seems like a difficult thing to accomplish, you will also need information from the manufacturer of the 3rd party software or some SDK that allows you to communicate with their software. Another (ugly) option would be to scan the Excel file by reading it from your application.

Member 12643851 27-Jan-21 9:16am

they also provide excel file where stock prices(LTP of stock) is change continuously how to fetch data from excel using c#(something like live stream of excel Colum data)

RickZeeland 27-Jan-21 12:19pm

That seems like the Excel file is using macro's to fetch the data. You will have to try to open these macro's which are mostly written in VBA to know what they do. If you can't, ask the manufacturer for more information.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

RickZeeland · Answer 1 · 2021-01-02T20:41:00

Solution 1

You can find some examples here: stock · GitHub Topics · GitHub[^]

Posted 2-Jan-21 20:41pm

RickZeeland