Yearly price bar charts candles

I am looking for yearly high low and closes. For the forex market or even commodities i was wondering if someone knows such place?


Thank you verry much

Ingmar.

Which timezone are you interested in?

Hi Seagreen,

I am not intrested in the timezone just in the yearly high low and closing prices i need them for gann.

regards Ingmar

How about checking out your charts? They should tell.

Possible on NT I believe.

I was kidding, if I new the answer I wouldn't fool with you brother. Yes Ninjatrader can construct 1 year charts but you need external datafeed.

If all else fails, try downloading or importing the data to Excel (don't ask me how, there are instructions all over the place, Google should help). Use the formula MAX and MIN in the 'close price' column to find the lowest and highest values.

Oke thanks guys for the aswers so far i am not a step further but no matters hope some will pass by and has the solution i know i can look on the charts blah blah.

But i am just looking for a simplistic way to do my maths with gann, thats why i asked if somebody knows a source with yearly highs low and closes or quarters half year etc.

Thanks for the responses so far know let's see if somebody has some decenst answer.

Thanks anyway

Regards,

Ingmar.

It took me 4 minutes to compile this Google Docs file using monthly CSV data imported from Mt4. I'm sorry to be so impolite, but I think you're just lazy.

A little respect would've been nice - you got two very good replies. So you can forget about the .csv file because I'm not uploading it. You only get to see a preview in screenshot form.

Bug there was no reason for me to insult you, your post is valuable only i really dont know how to that.

Sorry that i insulted you if you feeled that way.

It only amazes me if somebody opens a new thread with a question or whatever that it doesn't take long or the jokers come in or it goes way off topic.

Again no offense against you, you do with it what you want.

Respect,

Ingmar.

You know it kind of did. But I accept your apology. I would like to suggest that next time you ask me how to do that instead of claiming to have received 'no descent solutions'. In any case, here's the 'how to' for both solutions that were offered. I use MT4 so here's how to do it on MT4.

Solution 1 (by aediaz1)
1. Open a monthly chart (for yearly data this is the most sensible option because you only have to inspect 12 candles/bars). Make sure you have period separators on (ctrl+Y) to clearly separate one year from another.
2. Open the data window (ctrl+D).
3. Visually inspect the chart and find what looks like the highest high.
4. Move your mouse over it and check the data window. Write down your high.
5. If another high looks like it's very close to being higher, mouse over to that candle and check the data window. If the high is higher than what you previously wrote down, edit it.
6. Do the same for lows.
7. Repeat until you have all the data for all years.

Solution 2 (suggest by me)
1. Open a monthly chart
2. Save the data in CSV format using 'ctrl+s'
3. Import the data into Excel (using 'import-->data' or using 'open file'). Alternatively you could upload it into Google Docs or whichever online data processor you prefer. Although there are no headlines, the data in MT4 is always saved like this: DATE/TIME/OPEN/HIGH/LOW/CLOSE/VOLUME
This means that if you want your calculations to be based on closing prices, you have to use the 6th column from left.
4. Visually separate one year from another using lines or colors to make the next step easier.
5. Use the formulas MAX and MIN to calculate your data. If your data for 1990 is in columns C2 through C13 insert =MAX(R2:R13) and the same for MIN. If you get an error code or nothing shows up then you are doing something wrong.
6. Repeat this for each year.

Thanks Bug i apreciate your post i vouched as appreciation

Thank you. I hope have your data now. Excel is a powerful tool and you can do all sorts of crazy things with it, things you can't even imagine are possible. With MT4 you can download price and history data and you can analyse it all with Excel. With a certain vendor* (that I'm not going to mention here in the fear of being bumped into the commercial section) you even have the ability to trade straight from Excel using a web connection. If data analysis is what you are interested in then definitely get some education on using Excel. There's plenty of it available for free on the web, but I wouldn't rule out taking a couple of courses from your local university either (I had statistics 101 using Excel, it was great).

*PM me if you want to know the name of the company.