NexusFi: Find Your Edge


Home Menu

 





OEC excel Add-in Update Quotes together with the Positions in Excel


Discussion in Options

Updated
    1. trending_up 2,604 views
    2. thumb_up 0 thanks given
    3. group 1 followers
    1. forum 1 posts
    2. attach_file 1 attachments




 
Search this Thread
  #1 (permalink)
 sinpeople 
Singapore
 
Experience: Beginner
Platform: TDAmeritrade
Trading: Options On Futures
Posts: 45 since Aug 2017
Thanks Given: 5
Thanks Received: 10

Hi folks,

With the OEC Excel Add-in, I am able to get all positions from Gain into excel. There is a column "Symbol". With the value under "Symbol", I manually key in it to form a proper query statement for "Quotes", to get "Bid", "Last" etc fram gain. I didn't find a way to combine the symbol value into the query statement though.
The worse comes when new positions are added. New positions comes in alphetical order such that it can be insert into the existing position rows. Then I have to update the Quotes part manually again.

How do you update the quotes automatically by tie it with the positions query results?

Many thanks. I have attached my OEC worksheet in the image below.

Best Regards
David
=========================================


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
More Than Capable: Hegseths War Warning Validates $114M …
Prediction Markets & Event Contracts
CME Expands 24/7 Trading to WTI Crude Oil and Gold -- We …
Commodities
Iran Fired a Missile at Israel Last Night. The $8M June …
Prediction Markets & Event Contracts
$500M Riding on World Cup 2026: France/Spain Co-Favored …
Prediction Markets & Event Contracts
Hormuz Normalization Collapses to 19.5% -- Iran Regime F …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
Big Mike in Ecuador
205 thanks
Sober Journey With S&P
21 thanks
30 Sessions
20 thanks
Volume Indicators
8 thanks
Thanks Mike. Godspeed.
7 thanks




Last Updated on October 5, 2017


© 2026 NexusFi®, s.a., All Rights Reserved.
Av Ricardo J. Alfaro, Century Tower, Panama City, Panama, Ph: +507 833-9432 (Panama and Intl), +1 888-312-3001 (USA and Canada)
All information is for educational use only and is not investment advice. There is a substantial risk of loss in trading commodity futures, stocks, options and foreign exchange products. Past performance is not indicative of future results.
About Us - Contact Us - Site Rules, Acceptable Use, and Terms and Conditions - Downloads - Top
no new posts