+ Reply to Thread
Results 1 to 7 of 7

Need help to split buy and sell from live feed

  1. #1
    Registered User
    Join Date
    01-17-2014
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    6

    Need help to split buy and sell from live feed

    Hi, I am not good at excel. I would like to split buy and sell orders from the live feed and updating when new feeds come in.

    LIVE FEED
    BUY/SELL QTY PRICE BUY QTY PRICE SELL QTY PRICE
    B 4 150
    S 6 200
    S 4 300 CHANGE TO
    B 3 350 B 4 150
    B 2 180 B 3 350 S 6 200
    S 2 220 B 2 180 S 4 300
    B 1 120 B 1 120 S 2 220

    Hope you guys can help me.

    Thanks in advance

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need help to split buy and sell from live feed

    How do you want to separate it? Onto different sheets?

    What do you want to do with the data once its separated? Delete the rows?
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    01-17-2014
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need help to split buy and sell from live feed

    Hi,

    Its on the same spreadsheet. I extracted the data from a live feed but they mix the buy and sell together, so I wan to split it to buy order and sell order.
    When there is a new data feed come in eg: sell 5 200, it will update on my sell order side.

    I do not need to del the data once its updated

    Thanks in advance

  4. #4
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need help to split buy and sell from live feed

    Can you please upload a sample file showing how you receive the data and how you want the output to be?

    To Attach a File:

    1. Click on Go Advanced
    2. In the frame Attach Files you will see the button Manage Attachments
    3. Click the button.
    4. A new window will open titled Manage Attachments - Excel Forum.
    5. Click the Browse... button to locate your file for uploading.
    6. This will open a new window File Upload.
    7. Once you have located the file to upload click the Open button. This window will close.
    8. You are now back in the Manage Attachments - Excel Forum window.
    9. Click the Upload button and wait until the file has uploaded.
    10. Close the window and then click Submit.

  5. #5
    Registered User
    Join Date
    01-17-2014
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need help to split buy and sell from live feed

    mutant.xlsx

    Thanks in advance

  6. #6
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Need help to split buy and sell from live feed

    I am not understanding.

    How do we identify which is the new feed v/s the already existing data?

    Also, you want data to be copied from down to up?

  7. #7
    Registered User
    Join Date
    01-17-2014
    Location
    singapore
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need help to split buy and sell from live feed

    mutant.xlsx

    I do not mind whether the data are copy from up to down or down to up.
    thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel 2007 : Live exchange rate data feed?-
    By benoj2005 in forum Excel General
    Replies: 4
    Last Post: 03-22-2012, 10:40 AM
  2. Record Value Change from a Live Feed
    By jk64 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2011, 03:30 AM
  3. Live Feed Help.
    By megamuel in forum Excel General
    Replies: 2
    Last Post: 12-29-2010, 01:49 AM
  4. programming live feed data
    By losmi8 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-15-2010, 07:29 PM
  5. Live data feed - export
    By Drazen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2009, 02:22 PM

Tags for this Thread

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