Writing a macro for stock chart with scroll and 4-6 additional series

[mayur553]

Hi...

I am makin a model wherein it will download historical stock data from yahoo and make a new sheet for all the stocks its asked to download while the formating like data title would be same for all the sheet... after that i wanna put a button to run a macro which will create a stock chart with additional 4-6 series along with OHLC... and also the scroll.. now i have created the chart with all that range name and all that... but i am stuck how to convert it into a macro... also i would like to put another option there where in i would give a date range for which the chart has to be prepared... i want to incorporate that too in my macro...
another problem would be there can't be same range name in a workbook... so i dont know how to deal with that too...

Pleas help i would really appreciate the same...

[mayur553]

WOW.... No replies... Guys please help me out here...

I have attached a file... its on the line of my master file which i am working on... i have created the graph and all the data range would be similar to the one in the attached file..

the graph has messed up a bit... its not coming out as a candlestick stock chart... i couldn't figure out the problem there either.

Can anyone of you help me out to write a Macro for this file.. which will create that graph...

Also if we could incorporate givin a date range for the graph to draw... that would be gr8

Also... there will be many sheets similar to this and each would have that graph macro... so there might be a problem with named range also... pls chech and help me out

thanks..

Regards
Mayur

[mayur553]

Still no reply... well is it like no one knows... how to do what i ask?

[mayur553]

wow.... still no reply.. no on has a solution for this... or i have not made myself clear about the macro... or what.... pls reply guys... or if its already solved then give me some links..

Regards
M