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?
Strike Pause Holds, Oil Erases Monday Spike -- May CPI W …
Traders Hideout
CME Group Fee Schedule Changes Hit All Four Exchanges -- …
Traders Hideout
Iran Ceasefire Surges to 19.5% on US 15-Point Plan -- 82 …
Prediction Markets & Event Contracts
Fabrication or Framework? Irans Denied MOU Explains the …
Prediction Markets & Event Contracts
TradingView Deploys AI to Monitor SEC Filings in Real Ti …
TradingView
 
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