EXCEL Graphs.

ZigZag

Active member
123 0
Can anyone help me. Is it possible to superimpose a graph,from another worksheet , onto a graph on a different worksheet. Thanks Norman
 

stevet

Established member
917 5
yes - u can pretty much use excel graphing to do anything u can imagine - including replicate professional charting packages ( in look, but the key with professional charting packages is the data, not the charting), and get plug ins to save u a lot of the work - best to do a search on google
 

Bigbusiness

Experienced member
1,408 23
It is amazing what you can do with excel charts. Microsoft seem to have missed a huge market. If it was easy to get live data in to excel, I would use it all the time. I have read of some people using third party software to import in to excel but it looks a bit too complicated for me. Does anyone use excel for live charts?

Not sure if this website has the answer to your question about overlays but it has helped me a lot.

http://www.geocities.com/jonpeltier/Excel/Charts/index.html

PS

Looks like that website is too popular and is down for the next hour. There is a link to chart overlays.

http://www.geocities.com/jonpeltier/Excel/Charts/chartvba.html#AlignCharts
 

ZigZag

Active member
123 0
Much appreciated bigbusiness & Stevet. Trying to solve it by trial & error was driving me nuts. Big business. I think Bonsai does exactly that. He seems to be a clever guy and very helpful.
Regards Norman
 

Rognvald

Established member
916 15
BB
I have used a live feed to DDE price data into excel for purposes of assessing indices volatility and performing live calculations on risk and bet/deal size and found it ok most of the time subject to the feed data. I have not had the time yet to convert data into charts but this is something I may move to idc. I would appreciate hearing from anyone experienced in this
 

stevet

Established member
917 5
you can use api/dde links etc to access some charting companies data and there are companies which only supply real time data so u have to hook into their data with your own c, vb program etc, but not much point to replicate a charting package with excel when there are so many good charting packages out there
 

Bigbusiness

Experienced member
1,408 23
But with excel you don't have to use the indicators that everyone else is using, you can make your own. I have been doing this for EOD charts and now prefer them to the charting packages I have looked at. I have never got on with conventional indicators but the custom built ones have helped me a lot. It also costs a lot less that the crazy prices for some charting packages.
 

stevet

Established member
917 5
Bigbusiness

a lot of people spend a lot of time coming up with their own indicators - and good luck to you if it works for u - but i never met a trader who works that way simply because trading is a herd thing - when u take a position - if it does not work right away - you got it wrong as everyone else should have seen what you saw - so if u have your own one off indicator - who knows - if you are lucky - you might even be right - but mostly when u take that positon - you are going to be the only one hanging your XXXX out in the wind - and when that wind is cold - it is real cold

in trading its not about being right - its about being right just at the point that everyone else agrees - dont be first - be one of the first!
 

Rognvald

Established member
916 15
BB
Spot on.With hindsight I have spent so much time fighting with dilatory packages that I could probably have produced one to meet my particular needs in the same time and with less expense. It also gives a better understanding of what the indicators do and how - also how they might be tweaked/adjusted to work better for you
 

bonsai

Veteren member
4,106 10
Stevet
clearly I need to introduce myself. As I am the first.
:LOL:


Rog
I use dde and Lotus. If I can help let me know.

Big Business.
don't know about exel, but Lotus charting is first class.
as for those 'charting packages out there', they got dumped years
ago.
 

Bigbusiness

Experienced member
1,408 23
Hi Bonsai,

I have an old Lotus CD somewhere, I will have a look. Any chance of a rough guide to how you import the data with dde?
 

bonsai

Veteren member
4,106 10
first thing is you have to have a feed that supports dde.

I have satellite feed so what I do may not be of much help.

IB may offer dde ?

but when you find one, will be happy to guide you through the detail.

Rog indicated he knew some ?
 

stevet

Established member
917 5
bonsai

i did not say that i had not met people who talk about success with their own indicators - just that i never met a professional trader who needs or wants anything special like that - but if it works for - good on ya

but are u talking about coming up with special indicators or just using your own system to access and analyse data and automatically issue your open and close orders? - that for sure does work!

IB have socket connections, api and dde for getting data but its only real time sort of direct from exchnges so no historic data, so u miss a tick and its gone forever, and its sampled to cut down a bandwidth, so u dont get it all ( i am not technical except to the level i need to trade)

i guess u might have CQG if u have a satelite feed and they use dde - dont u just love latency? or is it another data supplier
 
Last edited:

bonsai

Veteren member
4,106 10
stevet

in my experience, most of them are very good with 'keyboard skills' and wouldn't even dream of writing their own routines for anything. But I could be wrong.

why bother, when the company has paid the nice salesman lots of dosh for 200 work stations. ?
 

stevet

Established member
917 5
bonsai

i added a bit to my message - did u get that

and as you know - you are paying for the good data and the charting package is basically free - and most of the "name" packages have way way too much for a professional trader and enough for gamers to play with for sure, until they decide to stop playing and start trading
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock