indiTraders - Forum for the Active Indian Trader  

Go Back   indiTraders - Forum for the Active Indian Trader > Tools > Software > Other Platforms

DPonline
Reply
 
Bookmark and Share LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 07-04-2014, 11:33 AM
whatsinthename whatsinthename is offline
Regulars
 
Join Date: Mar 2014
Posts: 313
Thanks: 126
Thanked 516 Times in 267 Posts
whatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the rough
Default RT plotting in excel

i do some simple calculations in excel.
lets say its A-B=C. since A, B are changing in RT, C is also changing.
i just want to plot C in a graph with time on X-axis and C on Y-axis.
how to do it in excel?
pls help
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to whatsinthename For This Useful Post:
  #2 (permalink)  
Old 07-04-2014, 11:53 AM
JJ's Avatar
JJ JJ is online now
.
 
Join Date: Mar 2009
Posts: 6,996
Thanks: 20,046
Thanked 28,255 Times in 6,720 Posts
JJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond repute
JJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond repute
Default

If you can get data into excel then the best option is to plot the data in MultiCharts which can read data from a dynamically updating excel sheet. Charting and managing a database in excel is not the most efficient option especially for real time.
__________________
In a fight between you and the markets, back the markets.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 5 Users Say Thank You to JJ For This Useful Post:
  #3 (permalink)  
Old 07-04-2014, 12:10 PM
whatsinthename whatsinthename is offline
Regulars
 
Join Date: Mar 2014
Posts: 313
Thanks: 126
Thanked 516 Times in 267 Posts
whatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the rough
Default

in my case its just a simple line graph with x-axis as time. no complicated charting stuff! also, this activity wud nt require me to maintain & manage database on a daily basis. only intra day plotting of a line graph! infact this line graph doesnt care wht happened yest!

thts why i thot of a simple tool in excel! though MC wud make it easier and give me lot of options to manoeuvre, i want to try excel first!

still wud u prefer MC over excel for such a small requirement?

Originally Posted by JJ View Post
If you can get data into excel then the best option is to plot the data in MultiCharts which can read data from a dynamically updating excel sheet. Charting and managing a database in excel is not the most efficient option especially for real time.


Last edited by whatsinthename; 07-04-2014 at 12:13 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to whatsinthename For This Useful Post:
  #4 (permalink)  
Old 07-04-2014, 12:15 PM
JJ's Avatar
JJ JJ is online now
.
 
Join Date: Mar 2009
Posts: 6,996
Thanks: 20,046
Thanked 28,255 Times in 6,720 Posts
JJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond repute
JJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond repute
Default

If it's a small amount of data then it should not be a problem, however it's not straightforward in excel, you have to create a dynamic sheet where the old values are pushed in favor of the new ones. In short, few formulas are needed to get it done and rather cumbersome without a plugin.
__________________
In a fight between you and the markets, back the markets.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 4 Users Say Thank You to JJ For This Useful Post:
  #5 (permalink)  
Old 07-04-2014, 12:22 PM
whatsinthename whatsinthename is offline
Regulars
 
Join Date: Mar 2014
Posts: 313
Thanks: 126
Thanked 516 Times in 267 Posts
whatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the rough
Default

i thot any forum member must have done sumthing on it, thus the query posted here! anyways i will work on those lines.

Originally Posted by JJ View Post
If it's a small amount of data then it should not be a problem, however it's not straightforward in excel, you have to create a dynamic sheet where the old values are pushed in favor of the new ones. In short, few formulas are needed to get it done and rather cumbersome without a plugin.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to whatsinthename For This Useful Post:
  #6 (permalink)  
Old 07-04-2014, 01:41 PM
JJ's Avatar
JJ JJ is online now
.
 
Join Date: Mar 2009
Posts: 6,996
Thanks: 20,046
Thanked 28,255 Times in 6,720 Posts
JJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond repute
JJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond repute
Default

The problem is timestamp and pushing off old data to plot the new values, determining that in excel isn't easy without macros or plugin, maybe someone who does this regularly would be able to help more.
__________________
In a fight between you and the markets, back the markets.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 4 Users Say Thank You to JJ For This Useful Post:
  #7 (permalink)  
Old 07-04-2014, 03:40 PM
whatsinthename whatsinthename is offline
Regulars
 
Join Date: Mar 2014
Posts: 313
Thanks: 126
Thanked 516 Times in 267 Posts
whatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the rough
Default

can u pls explain abt timestamp thing in detail as in my case there is no timestamp getting generated. its only C (i.e. A-B) which is getting updated RT.

Originally Posted by JJ View Post
The problem is timestamp and pushing off old data to plot the new values, determining that in excel isn't easy without macros or plugin, maybe someone who does this regularly would be able to help more.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to whatsinthename For This Useful Post:
  #8 (permalink)  
Old 07-04-2014, 04:16 PM
JJ's Avatar
JJ JJ is online now
.
 
Join Date: Mar 2009
Posts: 6,996
Thanks: 20,046
Thanked 28,255 Times in 6,720 Posts
JJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond repute
JJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond reputeJJ has a reputation beyond repute
Default

Timestamp shows when your value was created.

To get a chart, you need two axis, one of them will be timestamp in your case.

Let's say the value at 12.01 PM was 10 and at 12.02 PM was 11, 12.01 and 12.02 are the time stamps. The challenge is in pushing the 12.01 PM value to a different row or column and bring the 12.02 PM value to front.
__________________
In a fight between you and the markets, back the markets.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following 2 Users Say Thank You to JJ For This Useful Post:
  #9 (permalink)  
Old 07-04-2014, 04:57 PM
whatsinthename whatsinthename is offline
Regulars
 
Join Date: Mar 2014
Posts: 313
Thanks: 126
Thanked 516 Times in 267 Posts
whatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the rough
Default

u must be aware of write to excel or snap to excel feature of various trading platforms. when u use tht u get streaming RT values.

now lets take a simple example:
  • cell A is open price (cell A cud also be RT changing depending on any other example)
  • cell B is RT price
  • cell C is A - B

so cell C is getting updated RT every second. though RT change is every second, there is no time stamp getting generated in any corresponding cells!

i agree tht for every time stamp the value of cell C wud be different. but i didnt get this where time stamps are getting generated?

am i sounding like an idiot or not able to put across my query

Originally Posted by JJ View Post
Timestamp shows when your value was created.

To get a chart, you need two axis, one of them will be timestamp in your case.

Let's say the value at 12.01 PM was 10 and at 12.02 PM was 11, 12.01 and 12.02 are the time stamps. The challenge is in pushing the 12.01 PM value to a different row or column and bring the 12.02 PM value to front.


Last edited by whatsinthename; 07-04-2014 at 05:09 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to whatsinthename For This Useful Post:
  #10 (permalink)  
Old 07-04-2014, 05:06 PM
whatsinthename whatsinthename is offline
Regulars
 
Join Date: Mar 2014
Posts: 313
Thanks: 126
Thanked 516 Times in 267 Posts
whatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the roughwhatsinthename is a jewel in the rough
Default

to take this example further in a visual way:

there are 4 columns in my mktwatch
exchg = cell A
scrip name = cell B
open = cell C
current = cell D

my calculation is E = C-D which is getting changed RT and i wanna plot this - simple!

my question is where is the time stamp in picture?
Attached Images
File Type: png 1.png (5.0 KB, 26 views)
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
The Following User Says Thank You to whatsinthename For This Useful Post:
Reply

indiTraders - Forum for the Active Indian Trader > Tools > Software > Other Platforms


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are On


DPonline

All times are GMT +5.5. The time now is 09:09 PM.


vBulletin Copyright by vBulletin

Content Relevant URLs by vBSEO 3.3.2