![]() ![]() The one-week, one-month, three-month, six-month, and one-year trailing periods provide the most complete view of the correlations between currency pairs. Let's assume your account's currency is XXX. Determine your account’s currency (in about 90 cases, it is USD). Here is a simple formula to calculate the pip value in all possible cases. When you’re done, you can take your new data and create a cool looking table just like this. In all these cases, the value of a single pip for your positions is not obvious. Step 10: Repeat Steps 5-9 for the other pairs and for other time frames. Step 9: Click the Enter key on your keyboard to calculate the correlation coefficient for EUR/USD and USD/JPY. ![]() Step 8: After the comma, select USD/JPY’s price data range just like you did for EUR/USD. You’ll be surrounding this range with a box. Step 7: Next, select the range of cells for EUR/USD’s price data, followed by a comma. Step 6: In the first empty cell below your first comparison pair (I’m correlating EUR/USD to the other pairs, so I’m starting with EUR/USD and USD/JPY), type: =correl( For this example, we’re using the last month. The amount of price data you have will dictate this, but you can always get more data. Do you want last week’s currency correlation? Last month? Last year? Step 5: It’s time to decide on a time frame. Yellow might not be the best option though! Colors and fonts are up to you! Have fun with this. Step 4: Now arrange your data to look like the following or something similar. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |