+ Reply to Thread
Results 1 to 5 of 5

extract data from a realtime updated cell

  1. #1
    ALVESM
    Guest

    extract data from a realtime updated cell

    hey how's everything? i've got a spreadsheet that is linked to reuters
    Xtra3000 and gets updated every 10s. my goal is to copy the value from a
    specific cell and paste it on some other cell. then after 10s repeat it,
    copying the same cell, but pasting it on a different one so i can come up
    with a series of values.
    afterwards i'd like to plot a chart based on the copied range of cells that
    gets updated as we go.
    can someone point out what should i be doing?
    thanks in adv,
    Miguel

  2. #2
    Bob Phillips
    Guest

    Re: extract data from a realtime updated cell

    Have you looked at either the Worksheet_Change event or the
    Worksheet_Calculate event?

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "ALVESM" <ALVESM@discussions.microsoft.com> wrote in message
    news:E8A06F5D-5935-4350-A70F-1061DFE06474@microsoft.com...
    > hey how's everything? i've got a spreadsheet that is linked to reuters
    > Xtra3000 and gets updated every 10s. my goal is to copy the value from a
    > specific cell and paste it on some other cell. then after 10s repeat it,
    > copying the same cell, but pasting it on a different one so i can come up
    > with a series of values.
    > afterwards i'd like to plot a chart based on the copied range of cells

    that
    > gets updated as we go.
    > can someone point out what should i be doing?
    > thanks in adv,
    > Miguel




  3. #3
    ALVESM
    Guest

    Re: extract data from a realtime updated cell

    that's not how i want to do it- cheers anyway.
    i need to update every 10sec and if i'm to track changes i can only track in
    a 5min interval. the mean time is quite important since this refers to stock
    quotes and it does matter for a technical analyst
    can i do it using macros? i'm not familiar with any commands, but it would
    be a very simple macro: a cycle that copies a cell's value every ten secs and
    causes one other cell to assume that value. then after 10s the clycle reruns
    copying the same cell to the cell bellow the first copied one. maybe 2 cycles
    then, i guess.
    can you draw a simple macro structure? i'll learn more about it, after.

    t.i.a.,
    Miguel


    "Bob Phillips" wrote:

    > Have you looked at either the Worksheet_Change event or the
    > Worksheet_Calculate event?
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "ALVESM" <ALVESM@discussions.microsoft.com> wrote in message
    > news:E8A06F5D-5935-4350-A70F-1061DFE06474@microsoft.com...
    > > hey how's everything? i've got a spreadsheet that is linked to reuters
    > > Xtra3000 and gets updated every 10s. my goal is to copy the value from a
    > > specific cell and paste it on some other cell. then after 10s repeat it,
    > > copying the same cell, but pasting it on a different one so i can come up
    > > with a series of values.
    > > afterwards i'd like to plot a chart based on the copied range of cells

    > that
    > > gets updated as we go.
    > > can someone point out what should i be doing?
    > > thanks in adv,
    > > Miguel

    >
    >
    >


  4. #4
    Bob Phillips
    Guest

    Re: extract data from a realtime updated cell

    Those events should fire when the worksheet updates.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "ALVESM" <ALVESM@discussions.microsoft.com> wrote in message
    news:59F5CAB9-5609-4246-8AE8-7732D5E36B06@microsoft.com...
    > that's not how i want to do it- cheers anyway.
    > i need to update every 10sec and if i'm to track changes i can only track

    in
    > a 5min interval. the mean time is quite important since this refers to

    stock
    > quotes and it does matter for a technical analyst
    > can i do it using macros? i'm not familiar with any commands, but it would
    > be a very simple macro: a cycle that copies a cell's value every ten secs

    and
    > causes one other cell to assume that value. then after 10s the clycle

    reruns
    > copying the same cell to the cell bellow the first copied one. maybe 2

    cycles
    > then, i guess.
    > can you draw a simple macro structure? i'll learn more about it, after.
    >
    > t.i.a.,
    > Miguel
    >
    >
    > "Bob Phillips" wrote:
    >
    > > Have you looked at either the Worksheet_Change event or the
    > > Worksheet_Calculate event?
    > >
    > > --
    > >
    > > HTH
    > >
    > > RP
    > > (remove nothere from the email address if mailing direct)
    > >
    > >
    > > "ALVESM" <ALVESM@discussions.microsoft.com> wrote in message
    > > news:E8A06F5D-5935-4350-A70F-1061DFE06474@microsoft.com...
    > > > hey how's everything? i've got a spreadsheet that is linked to reuters
    > > > Xtra3000 and gets updated every 10s. my goal is to copy the value from

    a
    > > > specific cell and paste it on some other cell. then after 10s repeat

    it,
    > > > copying the same cell, but pasting it on a different one so i can come

    up
    > > > with a series of values.
    > > > afterwards i'd like to plot a chart based on the copied range of cells

    > > that
    > > > gets updated as we go.
    > > > can someone point out what should i be doing?
    > > > thanks in adv,
    > > > Miguel

    > >
    > >
    > >




  5. #5
    ALVESM
    Guest

    Re: extract data from a realtime updated cell

    can you fill me in on how to do it?
    i'm very much clueless
    cheers

    "Bob Phillips" wrote:

    > Those events should fire when the worksheet updates.
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "ALVESM" <ALVESM@discussions.microsoft.com> wrote in message
    > news:59F5CAB9-5609-4246-8AE8-7732D5E36B06@microsoft.com...
    > > that's not how i want to do it- cheers anyway.
    > > i need to update every 10sec and if i'm to track changes i can only track

    > in
    > > a 5min interval. the mean time is quite important since this refers to

    > stock
    > > quotes and it does matter for a technical analyst
    > > can i do it using macros? i'm not familiar with any commands, but it would
    > > be a very simple macro: a cycle that copies a cell's value every ten secs

    > and
    > > causes one other cell to assume that value. then after 10s the clycle

    > reruns
    > > copying the same cell to the cell bellow the first copied one. maybe 2

    > cycles
    > > then, i guess.
    > > can you draw a simple macro structure? i'll learn more about it, after.
    > >
    > > t.i.a.,
    > > Miguel
    > >
    > >
    > > "Bob Phillips" wrote:
    > >
    > > > Have you looked at either the Worksheet_Change event or the
    > > > Worksheet_Calculate event?
    > > >
    > > > --
    > > >
    > > > HTH
    > > >
    > > > RP
    > > > (remove nothere from the email address if mailing direct)
    > > >
    > > >
    > > > "ALVESM" <ALVESM@discussions.microsoft.com> wrote in message
    > > > news:E8A06F5D-5935-4350-A70F-1061DFE06474@microsoft.com...
    > > > > hey how's everything? i've got a spreadsheet that is linked to reuters
    > > > > Xtra3000 and gets updated every 10s. my goal is to copy the value from

    > a
    > > > > specific cell and paste it on some other cell. then after 10s repeat

    > it,
    > > > > copying the same cell, but pasting it on a different one so i can come

    > up
    > > > > with a series of values.
    > > > > afterwards i'd like to plot a chart based on the copied range of cells
    > > > that
    > > > > gets updated as we go.
    > > > > can someone point out what should i be doing?
    > > > > thanks in adv,
    > > > > Miguel
    > > >
    > > >
    > > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1