Re: Transition Formula Entry and Copy of Values

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

On Sep 15, 7:47 am, R Tanner <tanner.ro...@xxxxxxxxx> wrote:
Hi,

I have a small table with updating prices from a trade platform.  I
need to update a specified column with the value of a specific cell in
the table when it changes.  I can do everything except I can't figure
out how to get the loop to activate whenever the cell updates with a
new value.  What syntax would I use for this?

Thanks

It is probably important to note I did not query this data through the
'Data' tab in excel. I went to the advanced tab under Options and
checked 'Transition Formula Entry'. It is a formula that updates my
price table. If any of you are familiar with Metaquotes, the formula
pulling the data from the client is the following:

=MT4|BID!GBPUSD

Again, it updates whenever the price updates. I want to record every
change in price. I just don't know how to calculate my loop according
to a change in value of the cell.
.

Relevant Pages

  • Re: Installed XP SP2 last night 52 patches. Oh right, it is Micro$oft
    ... I know I got big discounts. ... Just like his price of $300 assumes he got no discounts. ... ignoring the nearly 36 incremental OS updates & fixes! ... of theirs from Office & Windows Licensing, ...
    (comp.sys.mac.advocacy)
  • Re: What will happen?
    ... The $1000 price would p*ss off the loyal users who ... renewal each year which includes all product updates and upgrades. ... Oracle, Microsoft, VMWare, many others offer annual subscriptions for very ...
    (borland.public.delphi.non-technical)
  • Question about update fees.
    ... portability and GUI designer are quite attractive for the price. ... the standard version is offered for 90 Euro including ... six months of updates, and 120 Euro for eighteen months of updates. ... apply to major updates, such as from 5.5.x to 2005? ...
    (comp.lang.basic.realbasic)
  • Re: Message to Stern Pinball: Unfinished Code
    ... No mater if they dropped the price or not, ... updates, that would get rid of most op pin sales. ... them, and that was a profitable video game, not a pinball machine. ...
    (rec.games.pinball)
  • Re: I need help with a simple vlookup formula
    ... worksheet A contains ... D - Customer Price ... in cell b of worksheet B to populate cell d of worksheet A. ... I get daily price updates from a vendor daily and need a way to update ...
    (microsoft.public.excel.worksheet.functions)