=googlefinance(concatenate("ASX:", CELL REFERENCE ), "price")For...

  1. roaminoz
    18,278 Posts.
    lightbulb Created with Sketch. 276
    clock Created with Sketch.
    19/02/21
    01:40
    Post #: 51139774
    =googlefinance(concatenate("ASX:", CELL REFERENCE ), "price")

    For example for BHP in your sheet the formula would go into B2 cell and the formula would be the following:

    =googlefinance(concatenate("ASX:", A2), "price")
    Likes Created with Sketch. 1  Upvote
    Stroke 3 Created with Sketch. Comments Created with Sketch. Reply
 

Featured News

NEWS Frontier Energy nears $225M financing milestone: Click here to join discussion
right-arrow Created with Sketch.
NEWS Week 15 Wrap: USA uncertain, ECB shrugs at the Fed & gold, gold, gold
right-arrow Created with Sketch.
FXG Market purrs with approval of Felix's 90% gold recovery in Alaska
right-arrow Created with Sketch.
OZM OzAurum Resources ups the ante on the charge for lithium in Brazi
right-arrow Created with Sketch.
BGD Barton kicks off scoping studies at Tunkillia – a 1.5Moz gold play
right-arrow Created with Sketch.
RCE Recce Pharmaceuticals up on new antibiotic production milestone
right-arrow Created with Sketch.

Top Stories

arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.