Replies

Andrew

Good morning.

Thank you very much, it works brilliantly, I will study the information on the site you suggested.

This is great work.

Have a nice day.

Andrew

Here is a link to an application that can be down loaded, once the application is open the following setting must be enabled:

http://www.alpari.co.uk/en/trading_platforms/metatrader4.html

Tools > Options > Server then tick Enable DDE Server

Once this is done then open the Excel Workbook: Click enable Macro’s and click Update links.

I attach a workbook with a link in Cell A2

You will see the cell changing as the Data comes in.

It is not necessary to capture every change, you can set a timer for say example: every 10 seconds or 30 seconds or 60 seconds.

Hope this is enough information.

Hi Andrew

This works perfectly, thank you very much.

This brings up another question, this code obviously work since you press the Enter key every time that you enter data, how can you make it work for a different application like linking cell A2 to steaming data like stock prices etc. Is it possible for instance to make streaming data work as if you have entered it or can code be added that “force” an entry say every second or every 5 seconds?

I would appreciate your opinion and thoughts

John

Thank you very much, look so easy, but obviously you need to know the answer first.

Thank you again

Hans

That is correct and thank you very much, this formula works now 100% (I wanted to add “famous last words”, but a tried different configurations and it always brings back the correct answer)

So, much appreciation for the solution.

Hans,

When text number are used they will normally be in the following format:

100a
100b
100c

or a mixture of text and numbers may look like this:

102
103
104a
104b
105
106

The chance that the same customer will pay 2 times on the same date for the same flat number and get one receipt as a number and one as a text is almost impossible (we can leave that possibility out), so in the example above the text 104a and 104b might be for the same customer on the same day in which case 104b will the the last number, if it was used for 2 different customers then there is no problem since 104a and 104b will be asigned to differents flat numbers although it can be on the same day.

I hope the explanation is clear, if not please let me know

Thank you

I just thought of another possible problem, in the case where you have a receipt numbers that are text and some numbers, then the sumproduct formula might not work also.

Which version of Excel are you using?

Example Excel 2003 only have 256 columns

Hans

If paid on the same day it will be the highest number since they will come from the same set of receipt numbers, so we basically need the highest number on the latest date of payment for a specific flat number.

I appologize for all the reworks but sometimes I do not think of all the possible problems that can arise beforehand.

Regards

Kobus

How many columns do your spreadsheet have?

If less than the number of items, then it will not work.

Regards

Kobus

Hans

You will not believe it, but I broke the formula again.

The problem now is that when you have a case where the same person makes 2 payments on the same day then the receipts get added together. Any solution for this ocurrance?

Regards

Kobus

Hans

Thank you, this one works perfectly.

Enjoy the day

Regards

Kobus

Hans

Thank you for the formula, I notice that if the people pay on the same date, then the formula brings back the wrong receipt number. I add the spreadsheet to illustrate.

Regards

Kobus

Hi

My spreadsheet as developped in the past works great, now I want to add one more feature to it:

I want to extract the latest Receipt number for each flat: We will have to look at the dates paid and then extract the matching latest receipt number for each flat.

I attach a small workbook to illustrate, any help or ideas will be appreciated.

Regards

Kobus

Hans

Thank you very much, your formulas is going to save me at least a week or two.
I really appreciate your help.

Thank you again