Search results

Hi All I have been looking around and searching for a possible solution for a few day now, but I have not had any luck, so there may not be a solution. I am hoping someone here may have an insight... I am preparing a worksheet which is essentially a decision tool which requires the user to...

Hi Narayank991 You're a genius! Your first suggestion fixed the left side of the graph but not the right, then it occurred to me that there was in fact a second axis! I repeated on the second x axis and it worked beautifully. The next step was to get those manual mouse clicks into VBA...

Hi maniche.jain I am learning about these kinds of graphs at the moment. A good starting place is http://chandoo.org/wp/tag/dynamic-charts/. It will at least give you an introduction into what you are after. Sorry I couldn't be of more help. Cheers Shaun

Hi All I have prepared a dummy file to demonstrate the issue as suggested by Narayank991. https://rapidshare.com/files/1056428909/bhp.xlsm Cheers Shaun

Hi all I have generated code to produce Open, High, Low, Close stock charts (Primary Axis) with two moving average lines (Secondary Axis) sharing a common Y axis (dates). I wanted to create a fill with boundries equalling: - bottom boundry = Min on Y axis - top boundry = Close price -...

Hi SirJB7 I will certainly have look through those links. The first of the three graphs are a simple Open, High, Low, Close graph, with two exponential moving averages (EMA) laid over the top. As you could see from the data workbook aac.ax.xlsx all the indicators a based on historical...

Hi SirJB7 Firstly, thank you taking the time to read my posts. Secondly, I guess it is time to see how deep the rabbit hole goes! More quickly than I had anticipated, but I am more than happy to jump right on in! This is a project that started in November(ish) last year, and at that time I...

Hi SirJB7 Your comments are have been taken on board and green stickies have been read. This is more a concept discussion than a please help discussion (though help would be greatly appreciated). The state of play as it stands now: I have (with the help of a good friend) developed a...

G'Day My name is Shaun from Melbourne, Australia. I am currently developing my skills in excel, playing around with VBA and various formulas to create an automated share picking spreadsheet. I have been met with many, many challenges. Fortunately, I have had some help from a friend to date...

Hi All Is it possible for excel to look at the current closing prices and volumes and then look at history of stock closing prices and volumes to find a period of time where the a similar trading had occured then provide an idication of what might happen whether it be adding another line in a...