forex line graph

[billd766]

Can anybody help me out?

 

I am trying to make a line graph in Excel for daily forex rates.

 

I have X and Y axes sorted out but I cannot remember how to insert the data.

 

I have followed the how to guides from MS and I can sometimes get what I want but not where I want it which is in line 1.

 

I have tried to cut and paste but that doesn't seem to work for me.

 

I haven't done one of these in years and my memory has failed me, at 78 it is hardly surprising.

 

 

[Sparktrader]

Use a free chart software like barchart

 

 

[CartagenaWarlock]

3 minutes ago, billd766 said:

haven't done one of these in years and my memory has failed me, at 78 it is hardly surprising.

At 78 you want to do forex trading? You ain't George Soros and he has a team of experienced people. 

[billd766]

4 minutes ago, Sparktrader said:

Use a free chart software like barchart

 

 

T Excel chart is already free and installed on my pc.

[billd766]

Just now, CartagenaWarlock said:

At 78 you want to do forex trading? You ain't George Soros and he has a team of experienced people. 

No. It is simply for me to keep up with the daily forex rate. 

[Lacessit]

3 minutes ago, billd766 said:

No. It is simply for me to keep up with the daily forex rate. 

Just put xe.com in your bookmarks, click on charts in their website if you want trends.

[Sparktrader]

14 minutes ago, billd766 said:

T Excel chart is already free and installed on my pc.

Barchart does the work for you

[Sparktrader]

16 minutes ago, billd766 said:

T Excel chart is already free and installed on my pc.

Barchart does the work for you

[carlyai]

I'm only 77 and also forgotten most of this even though I taught it to year 12s before.

What I can remember (sort of) is Excel have a very good Help menue.

Go to the Help menu and type something like: how do I insert a forex line chart?

 

[billd766]

18 minutes ago, Lacessit said:

Just put xe.com in your bookmarks, click on charts in their website if you want trends.

Thank you.

[billd766]

10 minutes ago, Sparktrader said:

Barchart does the work for you

Thank you.  I will look at that tomorrow.

 

I am looking specifically at the KBank forex, XE forex and Wise forex rates on a daily basis.

[billd766]

10 minutes ago, carlyai said:

I'm only 77 and also forgotten most of this even though I taught it to year 12s before.

What I can remember (sort of) is Excel have a very good Help menue.

Go to the Help menu and type something like: how do I insert a forex line chart?

 

I did, I can get the date on the horizontal axis, the forex rate on the vertical axis OK. My problem is getting the data on the chart in the right place.

[Sparktrader]

2 minutes ago, billd766 said:

Thank you.  I will look at that tomorrow.

 

I am looking specifically at the KBank forex, XE forex and Wise forex rates on a daily basis.

Banks just copy official rates and adjust spreads.

 

Set up a template on barchart. Put 2 moving averages. 3 day ema and 15 day ema. If the 3 day ema is above the 15 then the trend is up. If below the trend is down.

[nigelforbes]

My advice is not to reinvent the wheel on this, there's loads of sites out there that already have the daily exchange rates going back over 25 years.

[billd766]

1 hour ago, nigelforbes said:

My advice is not to reinvent the wheel on this, there's loads of sites out there that already have the daily exchange rates going back over 25 years.

I am not re-inventing the wheel, merely trying to get a simple answer to a fairly simple question.

 

If you had read my post I am looking specifically at KBank, XE, and Wise forex only as I have done certainly over the last 8 years.  I don't need loads of sites going back over the years.

 

I am merely trying to get a simple answer to a fairly simple question.

[Lacessit]

If I assume your X and Y axes are the date of the forex on the x axis, and the rate on the y axis, you should be able to create a line graph by finding a function called X-Y scatter or similar in the Excel menus. Fill in the A column with the date, B column with the rate.

At least, that's what I have done in LibreOffice, haven't used Excel for years.

[billd766]

11 hours ago, Lacessit said:

If I assume your X and Y axes are the date of the forex on the x axis, and the rate on the y axis, you should be able to create a line graph by finding a function called X-Y scatter or similar in the Excel menus. Fill in the A column with the date, B column with the rate.

At least, that's what I have done in LibreOffice, haven't used Excel for years.

Thank you. I have the X and Y functions sorted but I can't seem to get the graph to go into line 1 where I want it to be.

 

[Stocky]

1 hour ago, billd766 said:

I have the X and Y functions sorted but I can't seem to get the graph to go into line 1 where I want it to be

I assume you have your data in 4 columns, DATE, XE, KBANK, WISE - select and highlight the data  and on the menu bar go to Insert and then Recommended Charts and pick Insert Line Chart. Pick the option you want Line with or without markers - you have your graph.

[billd766]

20 hours ago, Sparktrader said:

Barchart does the work for you

I tried bar chart this morning and unless I missed something, it gives me the forex rate in general and not as I want which is bank specific.

 

Thank you for our help.

 

[billd766]

17 hours ago, Lacessit said:

If I assume your X and Y axes are the date of the forex on the x axis, and the rate on the y axis, you should be able to create a line graph by finding a function called X-Y scatter or similar in the Excel menus. Fill in the A column with the date, B column with the rate.

At least, that's what I have done in LibreOffice, haven't used Excel for years.

I loaded Libre Office this morning, (I haven't used it for 2 or 3 years) and it quickly brought up the bar chart that I needed and now I have to tweak it to get it correct.

 

Thank you also for your help. It is much appreciated.

[MJCM]

Is this what your are looking for (Excel)??

 

Sample data of course

 

[Sparktrader]

1 hour ago, billd766 said:

I tried bar chart this morning and unless I missed something, it gives me the forex rate in general and not as I want which is bank specific.

 

Thank you for our help.

 

Why do you want specific banks? They just copy the official rates less margin.

[billd766]

1 hour ago, MJCM said:

Is this what your are looking for (Excel)??

 

Sample data of course

 

Thank you for that. It is what I wanted.

 

I managed to do it about an hour ago using Libre Office. Much easier than Excel. 

[billd766]

1 hour ago, Sparktrader said:

Why do you want specific banks? They just copy the official rates less margin.

I want KBank as that is my Thai bank, Wise as that is my UK bank, XE as a comparison and for amusement I have now added BBK Bank as that is where I transfer funds from Wise.

 

If you transfer money from the UK to Thailand, you won't get the official rate anyway, so for what I want, the official rate is useless.

[MJCM]

-

[Sparktrader]

2 hours ago, billd766 said:

I want KBank as that is my Thai bank, Wise as that is my UK bank, XE as a comparison and for amusement I have now added BBK Bank as that is where I transfer funds from Wise.

 

If you transfer money from the UK to Thailand, you won't get the official rate anyway, so for what I want, the official rate is useless.

Whats the graph for? 

[billd766]

14 hours ago, Sparktrader said:

Whats the graph for? 

My satisfaction.

 

[carlyai]

Got it all sorted?

 

[billd766]

1 hour ago, carlyai said:

Got it all sorted?

 

Yes thank you. I am now at the tweakit to fit stage.