Question for tradergary-EXCEL stock futures


jimbo45

jimbo45

Well-known member
Pro User
VIP
Local time
3:28 PM
Posts
5,794
Location
Hafnarfjörður IS
OS
Windows XP,11 Linux Fedora Rawhide pre-release 45
Hi @TraderGary

I'm trying to get data from YAHOO finance into an EXCEL spread sheet -- Data from UK Futures market -- although ANY market is OK as I want the principle -- UK market is open at time when I'm usually up/

Is it possible and interactively look at to see if it's updating etc when I open the spreadsheet.

Skjámynd 2023-10-02 114211.png



Hi again @TraderGary

got the stuff into EXCEL via "Get data from Web" but any way of making it update regularly -- then I can set an alert and I can get a text message if the position improves / deteriorates so I can either invest more or close the trade without being stuck at a terminal.


Screenshot 2023-10-02 120757.png


cheers
jimbo
 
Last edited:

My Computer

System One

  • OS
    Windows XP,11 Linux Fedora Rawhide pre-release 45
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
    Screen Resolution
    4KUHD X 2
@jimbo45 My broker is Interactive Brokers. I don't use yahoo finance for anything. I used to use Excel extensively, but the charting I'm interested in is now done quite thoroughly and interactively by Interactive Brokers. I trade using Interactive Brokers Trader Workstation. I've also kept a subscription to finviz.com for years and find it quite valuable. The subscription has real-time data and is ad free.
 

My Computers

System One System Two

  • OS
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Dell XPS 16 DA16260
    CPU
    Intel Series 3 Core Ultra X9 388H
    Memory
    64GB LPDDR5x 9600 MT/s
    Graphics Card(s)
    Intel Arc graphics B390 Panther Lake
    Monitor(s) Displays
    16" 3.2K Tandem OLED Infinity Edge
    Screen Resolution
    3200 x 2000 16:10 236 PPI
    Hard Drives
    1 Terabyte M.2 PCIe NVMe SSD
    Case
    Black Anodized Aluminum
    Cooling
    Vapor Chamber Cooling
    Mouse
    None
    Internet Speed
    942 Mbps Netgear Mesh + 2 Satellites
    Browser
    Microsoft Edge (Chromium)
    Antivirus
    Windows Security (Defender)
    Other Info
    NPU delivering 67 TOPS
    Microsoft 365 subscription
    Microsoft OneDrive 1TB Cloud
    Microsoft Visual Studio
    Microsoft Visual Studio Code
    Microsoft Sysinternals Suite
    Microsoft BitLocker
    Microsoft Copilot
    Dell Support Assist
    Dell Command | Update
    Macrium Reflect X subscription
    1Password Password Manager
    Amazon Kindle for PC
    Lightroom/Photoshop subscription
    Interactive Brokers Trader Workstation
  • Operating System
    Windows 11 Pro
    Computer type
    Laptop
    Manufacturer/Model
    Microsoft Surface Laptop 7
    CPU
    Snapdragon® X Elite (12 Core) with Hexagon NPU delivering 45 TOPS
    Memory
    32GB LPDDR5x 8448 MT/s
    Graphics card(s)
    Integrated Adreno GPU
    Sound Card
    Omnisonic speakers with Dolby Atmos spatial sound
    Monitor(s) Displays
    13.8″ PixelSense Flow touchscreen 120 Hz 600 NIT
    Screen Resolution
    2304 × 1536 (201 PPI), 3:2 aspect ratio
    Hard Drives
    1 TB PCIe NVMe Gen 4 SSD
    Case
    Black Anodized Aluminum
    Cooling
    Vapor Chamber Cooling
    Mouse
    None
    Internet Speed
    942 Mbps Netgear Mesh + 2 Satellites
    Browser
    Microsoft Edge (Chromium)
    Antivirus
    Windows Security (Defender)
    Other Info
    Microsoft 365 subscription (Office)
    Microsoft OneDrive 1TB Cloud
    Microsoft Visual Studio 2026
    Microsoft Visual Studio Code
    Interactive Brokers Trader Workstation
    Lightroom/Photoshop subscription
    1Password Password Manager
    Microsoft Sysinternals
    Amazon Kindle for PC
    Microsoft BitLocker
    Microsoft Copilot
TraderGary said:
@jimbo45 My broker is Interactive Brokers. I don't use yahoo finance for anything. I used to use Excel extensively, but the charting I'm interested in is now done quite thoroughly and interactively by Interactive Brokers. I trade using Interactive Brokers Trader Workstation. I've also kept a subscription to finviz.com for years and find it quite valuable. The subscription has real-time data and is ad free.
Click to expand...
Hi there

Thanks for answering -- I'm not a pro but do the odd bit so something with reasonable EOD (Open, Close, High, Low, Volume) is mostly what Id want to mess around with.

I looked at the finviz one but it doesn't do FTSE (UK) at least not unless you subscribe to the elite platform.This one looks OK for 9 USD a month for a decent number of API calls per month - never heard of it though -- any comments :

www.marketdata.app

Market Data – Stocks & Options API + Spreadsheet Access

Real-time & historical Market Data for stocks, options, ETFs, mutual funds and more. Spreadsheet plug-ins, CSVs, and JSON API.
www.marketdata.app www.marketdata.app

Not sure who owns the site or whatever but 9 USD a month is hardly breaking the bank !!!!

But thanks again for answering !!!!



Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,11 Linux Fedora Rawhide pre-release 45
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
    Screen Resolution
    4KUHD X 2
jimbo45 said:
any way of making it update regularly
Click to expand...

Automatically refresh data at regular intervals​

  1. Select a cell in the external data range.
  2. Select Data > Queries & Connections > Connections tab, right click a query in the list, and then select Properties.
  3. Click the Usage tab.
  4. Select the Refresh every check box, and then enter the number of minutes between each refresh operation.
 

My Computers

System One System Two

  • OS
    Win 11 Pro 25H2 26200.8457 / Linux Mint 22.3
    Computer type
    Laptop
    Manufacturer/Model
    Lenovo A485
    CPU
    Ryzen 7 2700U Pro
    Motherboard
    Lenovo (WiFi/BT module upgraded to Intel Wireless-AC-9260)
    Memory
    32GB
    Graphics Card(s)
    iGPU Vega 10
    Sound Card
    Realtek
    Monitor(s) Displays
    14" FHD (built-in) + 14" Lenovo Thinkvision M14t (touch+pen) + 32" Asus PB328
    Screen Resolution
    FHD + FHD + 1440p
    Hard Drives
    Intel 660p m.2 nVME PCIe3.0 x2 512GB
    PSU
    125W(Dock)/65W(Travel Adapter)
    Keyboard
    Thinkpad / Logitech MX Keys
    Mouse
    Logitech MX Master 2S
    Internet Speed
    1/1Gbit
    Browser
    Firefox
    Antivirus
    Windows Defender
    Other Info
    SecureBoot: Enabled
    TPM2.0: Enabled
    AMD-V: Enabled
  • Operating System
    Win 11 Pro 25H2 26200.8521(RP)
    Computer type
    PC/Desktop
    Manufacturer/Model
    Custom
    CPU
    i7-7700k @4.8GHz
    Motherboard
    Asus PRIME Z270-A
    Memory
    32GB 2x16GB 2133MHz CL15
    Graphics card(s)
    EVGA GTX1080Ti FTW 11GB
    Sound Card
    Integrated
    Monitor(s) Displays
    32" 10-bit Asus PB328Q
    Screen Resolution
    WQHD 2560x1440
    Hard Drives
    512GB ADATA SX8000NP NVMe PCIe Gen 3 x4
    PSU
    850W
    Case
    Fractal Design Define 7
    Cooling
    Noctua NH-D15 chromax.black
    Keyboard
    Logitech MX Keys
    Mouse
    Logitech MX Master 2S
    Internet Speed
    1/1Gbit
    Browser
    Firefox
    Antivirus
    Windows Defender
    Other Info
    AC WiFi Card
SlicEnDicE said:

Automatically refresh data at regular intervals​

  1. Select a cell in the external data range.
  2. Select Data > Queries & Connections > Connections tab, right click a query in the list, and then select Properties.
  3. Click the Usage tab.
  4. Select the Refresh every check box, and then enter the number of minutes between each refresh operation.
Click to expand...
Hi there
Thanks

I'm also building my own historical data base {End of Day data -- OPEN, HIGH, LOW, CLOSE and Volume) -- the difficult was to get the components into a single data -- if you use the LSE data it's too many pages. I found one site that lists the whole 100 so got into EXCEL and can now with JSON / MariaDB start a decent app too - without having to subscribe to anything.


Got data from HERE :

With the data query on EXCEL

Screenshot 2023-10-03 113124.png


Now and thanks to your help I'm back in business !!!!! - Gives me something to do while at one of those endless boring "Town Hall meetings" consultancies like "Accidenture" seem to love and one has to attend even as an external free lancer !!!

cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,11 Linux Fedora Rawhide pre-release 45
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7
    Screen Resolution
    4KUHD X 2
You must log in or register to reply here.

Similar threads

  • Article Article
OpenAI Introducing ChatGPT for Excel
Replies
0
Views
244
Brink
Brink
  • Article Article
Early preview of Agent Mode in Excel is available
Replies
0
Views
497
Brink
Brink
  • Article Article
Microsoft Excel, a year in review: unlocking insights with Copilot and Python
Replies
0
Views
556
Brink
Brink
Stock trading platform for W11 and Firefox (or native but on W11)
Replies
3
Views
2K
Bree
Bree
Any Stock traders here (Options markets) with EXCEL 2021
Replies
5
Views
1K
johnlgalt
johnlgalt

Latest Support Threads

Latest Tutorials

Back
Top Bottom