Need Gold historical data

[rocky01]

HEY DUDE THANKS A LOT BUT ....CAN YOU PLZ HELP ME HOW TO GET FURTHER DATA FROM MCX WEB SITE..?IT GIVES IN FUTUER EXPIRY MONTH,,,PLZ POST THE PROCEEDUER FOR IT....GREAT JOB neil.nitk

 

[neil.nitk]

Step by step Guide
1)go to mcxindia.com
2)click market data
3)then bhav copy (commoditywise)
4)click on the Commodity and select the contract month and click go
5)click view in excel and save it on your comp (i use firefox)
6)Repeat 4-5 for diff contract months and save all excel files into one folder
7)Go to amibroker and click import ascii data the parameters while importing are
Date_DMY, Ticker, Skip, Open, High, Low, Close, Skip, Skip, Volume, OpenInt
8)Amibroker will create a continuous contract for the given commodity
9)Export the data and post it here for all of us to use

have a great day..

 

[rpc]

hi neil
thks for step by step guide.You may also use desitradermall for getting monthly data free of cost.Daily data has gone to paid model from 21/6/09
hope this helps

 

[rpc]

hi neil
can you tell the difference between gold,goldguinea,goldhni,goldm and which one we download
TIA

 

[neil.nitk]

Hi all, this is the comparison between the different contracts.

------------------Gold Guinea---------Gold Mini-----------Gold HNI----------Gold
Trading unit:---------8 g---------------100 g---------------1 kg------------1 kg
Base Value unit :-----8 g----------------10 g---------------10 g------------10 g
Tick size :-----------1 Rs----------------1 Rs---------------1 Rs------------1 Rs
Purity :--------------995----------------999----------------999-------------995
Value :-----------11,438 Rs-----------14,497 Rs----------14,715 Rs-------14,508 Rs
Margin :----------457.52 Rs------------5,798 Rs----------58,860 Rs-------58,032 Rs

Time for some basics..
1)Trading value is the quantity of gold you need to buy / sell if you want to exercise delivery. (Eg: you own a jewelery shop and want to physically own 1Kg gold (Trading Unit) of 999 purity, then you buy a Gold HNI and wait till expiry date). If you're a speculator, like me and the rest 95% of futures traders, then you dont wait till expiry date. you just take profits (hopefully ) and run.
2)The price you see everywhere (MCX website, your amibroker chart etc) is quoted on basis of the Base Value Unit, not the trading unit.
3)Tick size is the minimum price fluctuation of the contract per base value unit (eg 1Rs/8g, Rs/10g)
4)All i know is 999 is more pure than 995 (i guess )
5)Value of Base value unit (mentioned in 2) ) (eg: 11,438 Rs/8gm or 14,715/10gm)
6)Margin is the minimum amount of money you need to have in your trading account to control 1 future.

notes:
1)Some math :Total value of the contract = Value * ( Trading unit / Base value unit )
2)Commission : 0.03%, but remember they charge commission on Total value, smart ass brokers . BTW if your broker charges less, do let me know
3)The prices for margin and value are as on 22/06/09.

enough of gyaan....

i'm not a professional and the info above may not be 100% right (or even 50% for that matter lol, remember i said MAY). If ever i was one, i would be pouring over my gold charts, not wasting time writing posts

happy trading everyone


@rpc : if you're like me who has a 4 digit account balance then i suggest you trade gold coins (gold guinea) till your account balance reaches some 6 digits then you can trade kilos of gold . yeah, and i wont be downloading GOLD HNI data from MCX when i'm trading GOLD Guinea. i tried desitradermall as you suggested but i can download data only 1 trading day at a time and maximum of 4 trading days for 24 hours, they want me to shell out some $$$ for more data.

 

[rocky01]

GENIUS is d right word ... i found 4 u...!!! thanx a lot..!!:clap::clapping::thumb:

 

[rpc]

Hi all, this is the comparison between the different enough of gyaan....

Hi neil
Many thks for the gyaan.I am interested in accumulating gold on SIP basis,say 10 gms per month.I was looking for some guidance on buying in one of follo 3 ways.You seem to be well aware of gold market so pls help me which of the follo should I go for
1) buy physical gold from local jeweller/bank etc
2) invest if gold ETF like GOLDBEES,KOTAKGOLD etc
3) invest in gold by buying on MCX and hold in demat a/c
I want to hold gold for a long time like may be for 3-4 years
Pls give some guidance
TIA
rpc

 

[priyankadhanani]

i want historic gold prices in indian rupee(monthly) since 1997..plz help

 

[rocky01]

Hi,MY friend NEIL i need us dollar=INDIAN RUPEES historical eod data uptill now .kindly help suggest a website .!! as you helped me in case of gold data from mcx.

 

[neil.nitk]

@rpc: sorry i cant answer your question as i have not traded etfs. I know that buying from a jeweller is costlier than owning gold through mcx, but you have to wait till expiry date. Ill read about etfs after my exams.

@priyankadhanani: MCX provides data only from 2003, i dont know of any other free source to get data from 1997. If you get to know please share.

@rocky01: i guess this thread is not for forex, anyway i've attached 1 year usd-inr data and i found this link http://tinyurl.com/kn9nx3 where you can get data from 1822-2007.

regards
-neil