Search results

  1. Save tick data in Excel

    Hi All :) I wanted to import tick by tick(Each Minute) price appearing in a website to my spreadsheet that refreshes every minute i have done that using web query imported to excel now i need your help if i want to save that value which refreshes in every minute in a seprate sheet of the...
  2. GPD

    Hi All Could you all please help me in calculating Tail Index of Stocks or modelling Tail distribution i am looking to model extreme risks say a non normal distribution using generalized pareto distribution in Excel VBA (any Code) Any Help Suggetion Thanks in Advance
  3. Correlation Gold,Dollar,Oil,Interest rate

    Hi All Inverse correlation between gold and US financials but in current times with US Financials and Gold, Oil all are moving same What are your views kindly discuss those If one is doing any stress test analysis how do he incorporate current situation in his scenarios analysis...
  4. GARCH Parameters Estimation

    Hi All Have any one here done Coding in VBA for GARCH Parameters Estimation Kindly plz see if you could share with me or give me some hints in constructing that in Excel VBA Thanks
  5. Analyse Gold Returns Distribution

    Hi All www.gold.org Just want to take your views if you have only Investment in Gold and you want to analyse maximum probable loss in one day , is VaR good for estimation maximum probable loss in 1 day keeping view in mind of Normal Distribution? Please reply soon Thanks
Back
Top