☰
Login
Signup
Home
›
.Net / VBA / Excel (3rd party)
Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Sign In
Register
Categories
Recent Discussions
Activity
Categories
13.6K
All Categories
0
Incidents
143
Node JS client
38
Go client
784
.Net API client
375
Kite Publisher
537
.Net / VBA / Excel (3rd party)
452
Algorithms and Strategies
985
Java client
1.1K
API clients
402
PHP client
3.9K
Python client
344
Mobile and Desktop apps
1.3K
Market data (WebSockets)
3.3K
General
In this Discussion
July 2021
Viji
Is this Possible in Excel?
supaga
July 2021
edited July 2021
in
.Net / VBA / Excel (3rd party)
Hi All,
I am very new to the platform and exploring what it can, and cannot do.
In an Excel sheet, I have the following fields:
Is it possible to use any Kite Connect API and fill the fields with
per minute historical value
for that stock?
I want per minute data filled in the row from 14:08 PM till 15:30 PM.
Any ideas how to do so?
Thanks.
Tagged:
excel
Excelstocks.JPG
14.2K
Viji
July 2021
Yes it is possible using datediff function of excel VBA.
Refer
https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c
Viji
July 2021
Sorry above is for dates It will not work
Viji
July 2021
I am confused with MS Access functions
Viji
July 2021
Refer
https://support.microsoft.com/en-us/office/calculate-the-difference-between-two-times-e1c78778-749b-49a3-b13e-737715505ff6
Sign In
or
Register
to comment.
Refer https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c
Refer
https://support.microsoft.com/en-us/office/calculate-the-difference-between-two-times-e1c78778-749b-49a3-b13e-737715505ff6