Any Stock traders here (Options markets) with EXCEL 2021


jimbo45

Well-known member
Power User
VIP
Local time
8:54 AM
Posts
1,643
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Hi folks

Tidying up some old disks I found some old spreadsheets I used to use -- however access to things like Yahoo financial API has changed a lot.

Any Idea how I can get this type of stuff back on track with EXCEL 2021 and Yahoo (or other type of financial data with API to pull required data out)

Screenshot 2022-05-08 162033.png


Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

johnlgalt

Antidisestablishmentarianistentarianist
Power User
VIP
Local time
4:54 AM
Posts
2,423
Location
3rd Rock
OS
Windows 11 21H2
Check native Excel functions. I know it already has native ability to do currency exchange in real-time, something I learned a few months ago when re-doing some spreadsheets for my company's B2B rep.

Also, check out the results in this search: https://search.brave.com/search?q=excel+stock+spreadsheets
 

My Computers

System One System Two

  • OS
    Windows 11 21H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    HomeBrew
    CPU
    AMD Ryzen 9 3950X
    Motherboard
    MSI MEG X570 GODLIKE
    Memory
    4 * Corsair Vengeance 32 GB 3600 MHz
    Graphics Card(s)
    EVGA GeForce RTX 3080 Ti XC3 ULTRA GAMING (12G-P5-3955-KR)
    Sound Card
    Realtek® ALC1220 Codec
    Monitor(s) Displays
    Eve Spectrum ES07D02 280 Hz QHD | Eve Spectrum ES07D03 4K Gaming Monitor
    Screen Resolution
    1440p | 4k
    Hard Drives
    3x Samsung 980 Pro NVMe PCIe 4 M.2 2 TB SSD (MZ-V8P2T0B/AM)
    PSU
    PC Power & Cooling’s Silencer Series 1050 Watt, 80 Plus Platinum
    Case
    Fractal Design Define 7 XL Dark ATX Full Tower Case
    Cooling
    ZXT KRAKEN Z73 73.11 CFM Liquid CPU Cooler (3x 120 mm push top) + Air 3x 140mm case fans (pull front) + 1x 120 mm (push back) and 1 x 120 mm (pull bottom)
    Keyboard
    SteelSeries Apex Pro Wired Gaming Keyboard
    Mouse
    Logitech MX Master 3 for Business
    Internet Speed
    Logitech MX Master 3 for Business
    Browser
    Nightly (default) + Firefox (stable),Chrome, Edge/ß/Dev/Canary
    Antivirus
    Defender
  • Operating System
    Windows 10 x64 Pro build 21H1
    Computer type
    Laptop
    Manufacturer/Model
    Dell Latitude E5470
    CPU
    Intel(R) Core(TM) i5-6300U CPU @ 2.40GHz, 2501 Mhz, 2 Core(s), 4 Logical Processor(s)
    Motherboard
    Dell
    Memory
    16 GB
    Graphics card(s)
    Intel(R) HD Graphics 520
    Sound Card
    Intel(R) HD Graphics 520 + RealTek Audio
    Monitor(s) Displays
    Dell laptop display 15"
    Screen Resolution
    1920 * 1080
    Hard Drives
    Toshiba 128GB M.2 22300 drive
    INTEL Cherryvill 520 Series SSDSC2CW180A 180 GB SATA III SSD
    PSU
    Dell
    Case
    Dell
    Cooling
    Dell
    Mouse
    Logitech MX Master (shared) | Dell TouchPad
    Keyboard
    Dell
    Internet Speed
    AT&T LightSpeed Gigabit Duplex
    Browser
    Edge Chromium | Chrome | Firefox Nightly | Brave
    Antivirus
    Defender + MB4

jimbo45

Well-known member
Power User
VIP
Thread Starter
Local time
8:54 AM
Posts
1,643
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
Check native Excel functions. I know it already has native ability to do currency exchange in real-time, something I learned a few months ago when re-doing some spreadsheets for my company's B2B rep.

Also, check out the results in this search: https://search.brave.com/search?q=excel+stock+spreadsheets
Thanks

I'd love to get this sort of stuff working again - got a bit more time now as I only do "part time" gigs these days -- I think as they say in parts of the UK "The Great Retirement" where apparently after the Covid pandemic they just can't get enough people back again into the workforce - and it's not only in the UK either -- I'd hate going back "Full Time" these days. !!!

Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

johnlgalt

Antidisestablishmentarianistentarianist
Power User
VIP
Local time
4:54 AM
Posts
2,423
Location
3rd Rock
OS
Windows 11 21H2
I'm full-time 100% remote for my company. I mean, *technically* every employee is, as the official headquarters is in Hong Kong and no one actually lives there.

I might peruse some of those links myself, I need to learn how ot do this myself.
 

My Computers

System One System Two

  • OS
    Windows 11 21H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    HomeBrew
    CPU
    AMD Ryzen 9 3950X
    Motherboard
    MSI MEG X570 GODLIKE
    Memory
    4 * Corsair Vengeance 32 GB 3600 MHz
    Graphics Card(s)
    EVGA GeForce RTX 3080 Ti XC3 ULTRA GAMING (12G-P5-3955-KR)
    Sound Card
    Realtek® ALC1220 Codec
    Monitor(s) Displays
    Eve Spectrum ES07D02 280 Hz QHD | Eve Spectrum ES07D03 4K Gaming Monitor
    Screen Resolution
    1440p | 4k
    Hard Drives
    3x Samsung 980 Pro NVMe PCIe 4 M.2 2 TB SSD (MZ-V8P2T0B/AM)
    PSU
    PC Power & Cooling’s Silencer Series 1050 Watt, 80 Plus Platinum
    Case
    Fractal Design Define 7 XL Dark ATX Full Tower Case
    Cooling
    ZXT KRAKEN Z73 73.11 CFM Liquid CPU Cooler (3x 120 mm push top) + Air 3x 140mm case fans (pull front) + 1x 120 mm (push back) and 1 x 120 mm (pull bottom)
    Keyboard
    SteelSeries Apex Pro Wired Gaming Keyboard
    Mouse
    Logitech MX Master 3 for Business
    Internet Speed
    Logitech MX Master 3 for Business
    Browser
    Nightly (default) + Firefox (stable),Chrome, Edge/ß/Dev/Canary
    Antivirus
    Defender
  • Operating System
    Windows 10 x64 Pro build 21H1
    Computer type
    Laptop
    Manufacturer/Model
    Dell Latitude E5470
    CPU
    Intel(R) Core(TM) i5-6300U CPU @ 2.40GHz, 2501 Mhz, 2 Core(s), 4 Logical Processor(s)
    Motherboard
    Dell
    Memory
    16 GB
    Graphics card(s)
    Intel(R) HD Graphics 520
    Sound Card
    Intel(R) HD Graphics 520 + RealTek Audio
    Monitor(s) Displays
    Dell laptop display 15"
    Screen Resolution
    1920 * 1080
    Hard Drives
    Toshiba 128GB M.2 22300 drive
    INTEL Cherryvill 520 Series SSDSC2CW180A 180 GB SATA III SSD
    PSU
    Dell
    Case
    Dell
    Cooling
    Dell
    Mouse
    Logitech MX Master (shared) | Dell TouchPad
    Keyboard
    Dell
    Internet Speed
    AT&T LightSpeed Gigabit Duplex
    Browser
    Edge Chromium | Chrome | Firefox Nightly | Brave
    Antivirus
    Defender + MB4

jimbo45

Well-known member
Power User
VIP
Thread Starter
Local time
8:54 AM
Posts
1,643
Location
Hafnarfjörður IS
OS
Windows XP,7,10,11 Linux Arch Linux
I'm full-time 100% remote for my company. I mean, *technically* every employee is, as the official headquarters is in Hong Kong and no one actually lives there.

I might peruse some of those links myself, I need to learn how ot do this myself.

If only I'd bought AMAZN in 2011 -- they were still losing zillions back then !!! How things change.

I've found the the "Weeklys" on options exchange - Chicago CBOE (no typo that's what they are called) really interesting - they expire on Fridays and you can buy in "dollops" of 100 USD per "contract" -- most other exchanges need 1000 USD per contract and they expire monthly.


I used to have an e*trade account from Amsterdam but they've now moved only to US bur DEGIRO is good as alternative from NL where I can trade on US markets.

Iceland is in the EEA and has 100% access to the EU's internal market (thankfully) so no probs there -- but what a hassle dealing with US financial / IRS - I needed to get a "Witholding Tax exemption for a Non resident". What a mess that was - but all sorted. !! Not sure who has the worst bureaucracy - Indian Railways, Chinese People Liberation army, UK's National Health service or USA's Federal Govt's IRS !!! Close call all ways round !!!.

Anyway thanks for links.

"Happy and successful trading".

Cheers
jimbo
 

My Computer

System One

  • OS
    Windows XP,7,10,11 Linux Arch Linux
    Computer type
    PC/Desktop
    CPU
    2 X Intel i7

johnlgalt

Antidisestablishmentarianistentarianist
Power User
VIP
Local time
4:54 AM
Posts
2,423
Location
3rd Rock
OS
Windows 11 21H2
but what a hassle dealing with US financial / IRS - I needed to get a "Witholding Tax exemption for a Non resident". What a mess that was - but all sorted. !! Not sure who has the worst bureaucracy - Indian Railways, Chinese People Liberation army, UK's National Health service or USA's Federal Govt's IRS !!!

Being Indian, and working for a company that has all of its manufacturing in China, amongst those three I can definitely say that here in the US it's definitely convoluted, to say the least.

As every tax-paying resident know. :lmao:
 

My Computers

System One System Two

  • OS
    Windows 11 21H2
    Computer type
    PC/Desktop
    Manufacturer/Model
    HomeBrew
    CPU
    AMD Ryzen 9 3950X
    Motherboard
    MSI MEG X570 GODLIKE
    Memory
    4 * Corsair Vengeance 32 GB 3600 MHz
    Graphics Card(s)
    EVGA GeForce RTX 3080 Ti XC3 ULTRA GAMING (12G-P5-3955-KR)
    Sound Card
    Realtek® ALC1220 Codec
    Monitor(s) Displays
    Eve Spectrum ES07D02 280 Hz QHD | Eve Spectrum ES07D03 4K Gaming Monitor
    Screen Resolution
    1440p | 4k
    Hard Drives
    3x Samsung 980 Pro NVMe PCIe 4 M.2 2 TB SSD (MZ-V8P2T0B/AM)
    PSU
    PC Power & Cooling’s Silencer Series 1050 Watt, 80 Plus Platinum
    Case
    Fractal Design Define 7 XL Dark ATX Full Tower Case
    Cooling
    ZXT KRAKEN Z73 73.11 CFM Liquid CPU Cooler (3x 120 mm push top) + Air 3x 140mm case fans (pull front) + 1x 120 mm (push back) and 1 x 120 mm (pull bottom)
    Keyboard
    SteelSeries Apex Pro Wired Gaming Keyboard
    Mouse
    Logitech MX Master 3 for Business
    Internet Speed
    Logitech MX Master 3 for Business
    Browser
    Nightly (default) + Firefox (stable),Chrome, Edge/ß/Dev/Canary
    Antivirus
    Defender
  • Operating System
    Windows 10 x64 Pro build 21H1
    Computer type
    Laptop
    Manufacturer/Model
    Dell Latitude E5470
    CPU
    Intel(R) Core(TM) i5-6300U CPU @ 2.40GHz, 2501 Mhz, 2 Core(s), 4 Logical Processor(s)
    Motherboard
    Dell
    Memory
    16 GB
    Graphics card(s)
    Intel(R) HD Graphics 520
    Sound Card
    Intel(R) HD Graphics 520 + RealTek Audio
    Monitor(s) Displays
    Dell laptop display 15"
    Screen Resolution
    1920 * 1080
    Hard Drives
    Toshiba 128GB M.2 22300 drive
    INTEL Cherryvill 520 Series SSDSC2CW180A 180 GB SATA III SSD
    PSU
    Dell
    Case
    Dell
    Cooling
    Dell
    Mouse
    Logitech MX Master (shared) | Dell TouchPad
    Keyboard
    Dell
    Internet Speed
    AT&T LightSpeed Gigabit Duplex
    Browser
    Edge Chromium | Chrome | Firefox Nightly | Brave
    Antivirus
    Defender + MB4
Top Bottom