Comparing values in the same cell

**Litstone** · 03-13-2010, 10:01 AM

Dear Friends,

I have 2 very simple questions but I am very new to excel and I need your help.

1. I have a cell retrieves data from MSN Money. (For example: Exchange rate of Canadian Dollar to US Dollar. CAD to USD <Sheet1!A1=0,98039>)

It refreshes data from MSN servers in every 1 minutes. (For example; after one minute it changes to <Sheet1!A1=0,9789>)

For my local business, I need the rate of changing difference between old value and the new value. (For example, it must be <Sheet1!A2=[New value of A1 - Previous value of A1] / Previos value of A1>)

2. I want a graphic chart that follows this behavior in time. (For example; this graphic's "y" axis may refers to rates and "x" axis may refers to refresh times)

Thanks for yourn concerns and waiting for your quick replies.

Mert Ener

**JBeaucaire** · 03-13-2010, 12:03 PM

This would require VBA. Is that ok?

If you can post a sample workbook with your data retrieval active, we can test our suggestions directly.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

**Litstone** · 03-13-2010, 12:21 PM

Originally Posted by JBeaucaire

This would require VBA. Is that ok?

If you can post a sample workbook with your data retrieval active, we can test our suggestions directly.

Click GO ADVANCED and use the paperclip icon to post up your workbook.

I don't know what is a VBA but I am fairly good with codes. If you can supply a framework for me I can advance it. Here is an example of what I am looking for.

http://img86.imageshack.us/img86/130/94220060.png

**Litstone** · 03-13-2010, 02:40 PM

Any help_?

**Litstone** · 03-13-2010, 08:59 PM

Any help_?

**Litstone** · 03-15-2010, 05:57 AM

Any help_?

**JBeaucaire** · 03-15-2010, 03:42 PM

I'm stumped. Everthing I put on your sheet to auto-calculate is getting ignored or erased. I can't figure out why.

**Litstone** · 03-16-2010, 01:39 PM

Thanks JBeaucaire,

I have another problem for you

I managed previous one. Now I have a new challange:

My workbook (Kur.xlsm) is displaying current time and date. Also trend of USD compare to the other world currencies. It refreshes itself every one minute. I want a line graphic chart log will display Avarage USD Trend overtime with the values from current time.

Briefly, horizantal axes will keep log of M2 cell and vertical axis will keep log of M65 cell and this will give me a line chart.

Thanks for your concerns and waiting for your quick replies.

Your respectfully.

**JBeaucaire** · 03-16-2010, 02:08 PM

I don't do much with charting myself, but the Charting Forum probably is riddled with talent. A new thread properly titled there should get you some assistance.

**teachMeExcel** · 03-16-2010, 03:22 PM

how do i convert a cells that contains numbers in Text format into a true numeric.

I have a worksheet of 50K rows with 37 columns all full of this type of data and need to do a match and lookup with another sheets that contains a true Numeric values. ANy help in this is much appreiated.

**JBeaucaire** · 03-16-2010, 03:41 PM

1) Type the number 1 into an empty cell
2) Copy the cell
3) Select the cells that contain numbers stored as text
4) Select Edit > Paste Special > Multiply

That should convert them to real numbers.