Register


Results 1 to 6 of 6

Thread: CORRELAZIONI EXCEL

  1. 05-31-2012, 03:24 AM #1
    carlov77
    carlov77 is offline Member
    Join Date
    May 2012
    Posts
    46

    Excel e correlazioni

    Salve,
    ho letto l'argomento delle correlazioni con molto interesse.
    Vorrei poter calcolare le correlazioni in excel come spiegato dal Dott.Paganini.
    Potete spiegare come prendere i dati dalla trading station in excel e quali operazioni fare sul foglio di calcolo per misurare le correlazioni?
    Wasp likes this.
    Reply With Quote Reply With Quote
  2. 05-31-2012, 04:28 AM #2
    Matteo Paganini's Avatar
    Matteo Paganini
    Matteo Paganini is offline Senior Analyst FXCM Italia
    Join Date
    May 2010
    Posts
    3,967

    CORRELAZIONI EXCEL

    Eccoci qui,

    per parlare di correlazioni di mercato e per capire come calcolarle utilizzando Microsoft Excel.
    carlov77 likes this.
    Matteo Paganini – Chief Analyst FXCM Italia – mpaganini@fxcm.it

    Twitter: @MPaganiniFX

    Ps: le operazioni effettuate sono realizzate in un ambiente demo, a scopi prettamente educativi.
    Reply With Quote Reply With Quote
  3. 05-31-2012, 04:31 AM #3
    carlov77
    carlov77 is offline Member
    Join Date
    May 2012
    Posts
    46
    Molto bene, ti seguo.
    Reply With Quote Reply With Quote
  4. 05-31-2012, 04:43 AM #4
    Matteo Paganini's Avatar
    Matteo Paganini
    Matteo Paganini is offline Senior Analyst FXCM Italia
    Join Date
    May 2010
    Posts
    3,967
    Allora ragazzi,

    il modo per calcolare le correlazioni è molto semplice.

    1) Andare sul Marketscope 2.0 e selezionare il TIME FRAME DAILY + la VISUALIZZAZIONE TABELLARE



    2) A questo punto avremo i dati presentati in questo modo



    3) Tasto destro --> esporta in excel



    In questo modo è possibile scaricare tutte le serie storiche di prezzi DAILY sulle quali effettuare i calcoli.

    4) una volta che si hanno le serie storiche, basta copiarle in questo file FXCORRELATIONS.zip
    sotto le colonne dei prezzi, non dei rendimenti, mi raccomando

    carlov77 likes this.
    Matteo Paganini – Chief Analyst FXCM Italia – mpaganini@fxcm.it

    Twitter: @MPaganiniFX

    Ps: le operazioni effettuate sono realizzate in un ambiente demo, a scopi prettamente educativi.
    Reply With Quote Reply With Quote
  5. 03-01-2013, 08:45 AM #5
    Matteo Paganini's Avatar
    Matteo Paganini
    Matteo Paganini is offline Senior Analyst FXCM Italia
    Join Date
    May 2010
    Posts
    3,967
    Ecco nuovamente il file per te, Ezio! Grazie dell'email!

    FXCORRELATIONS.xls
    Matteo Paganini – Chief Analyst FXCM Italia – mpaganini@fxcm.it

    Twitter: @MPaganiniFX

    Ps: le operazioni effettuate sono realizzate in un ambiente demo, a scopi prettamente educativi.
    Reply With Quote Reply With Quote
  6. 03-01-2013, 05:20 PM #6
    Aezio
    Aezio is offline Member
    Join Date
    Jul 2011
    Posts
    80
    Quote Originally Posted by Matteo Paganini View Post
    Ecco nuovamente il file per te, Ezio! Grazie dell'email!

    FXCORRELATIONS.xls
    OK: questo funziona alla grande. Grazie.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Disclaimer: Trading foreign exchange on margin carries a high level of risk, and may not be suitable for all investors. The high degree of leverage can work against you as well as for you. Before deciding to trade foreign exchange you should carefully consider your investment objectives, level of experience, and risk appetite. The possibility exists that you could sustain a loss of some or all of your initial investment and therefore you should not invest money that you cannot afford to lose. You should be aware of all the risks associated with foreign exchange trading, and seek advice from an independent financial advisor if you have any doubts. Any opinions, news, research, analyses, prices, or other information contained on this website is provided as general market commentary and does not constitute investment advice. Forex Capital Markets LLC. will not accept liability for any loss or damage, including without limitation to, any loss of profit, which may arise directly or indirectly from use of or reliance on such information.