+ Reply to Thread
Results 1 to 4 of 4

Precious Metals Running Total & Live Quotes Feed Question

  1. #1
    Registered User
    Join Date
    07-15-2014
    Location
    nyc
    MS-Off Ver
    office 2011 mac
    Posts
    2

    Precious Metals Running Total & Live Quotes Feed Question

    I'd like to learn how to create a formula/function that keeps a running total of precious metals purchases and how to insert a live quote in the worksheet..I'd like to be able to have the portfolio value refresh using the values from the live quote.

    I want to be able to enter in purchases (they are not in any order) and have Excel total the amount of silver, gold, etc in Troy Oz. I'm assuming a vlookup would accomplish this???..just having trouble on how to approach this issue.

    Excel would have to look through the Metals column and determine what gold, silver, etc..after that it needs to match the corresponding Total Cost for each purchase that is gold, silver, etc

    Once this is done, Excel would have to sum up all purchases for silver, gold, etc.

    Would inserting a live quote be easier on Windows vs. Mac?

    I've attached an example Excel 2011 Mac file. I have additional questions/things I want to learn but this is my priority.

    Thank You!!
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Precious Metals Running Total & Live Quotes Feed Question

    You're example is not clear, what is your condition and in which column? and what results that you need to achieve and in which column?

    Thanks

  3. #3
    Registered User
    Join Date
    07-15-2014
    Location
    nyc
    MS-Off Ver
    office 2011 mac
    Posts
    2

    Re: Precious Metals Running Total & Live Quotes Feed Question

    I want to be able to enter purchases and have Excel update the total weight and cost in the portfolio for each type of metal.

    I have highlighted the the three columns that are relevant..Metal, WGHT/ITEM OZ, Total cost.

    After every entry the worksheet should reflect an updated total weight in troy oz, the acquisition cost for each type of metal.

    I hope that clears things up?

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: Precious Metals Running Total & Live Quotes Feed Question

    I am not sure whether u r looking for same or not .

    Punnam
    Attached Files Attached Files

+ 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. Need help to split buy and sell from live feed
    By mutant2308 in forum Excel General
    Replies: 6
    Last Post: 01-17-2014, 04:48 PM
  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

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