NexusFi: Find Your Edge


Home Menu

 





Quantitative Research Question: Which platform to use instead of EXCEL with VBA?


Discussion in Platforms and Indicators

Updated
      Top Posters
    1. looks_one Big Mike with 1 posts (1 thanks)
    2. looks_two Cogito ergo sum with 1 posts (0 thanks)
    3. looks_3 Quick Summary with 1 posts (0 thanks)
    4. looks_4 ericbrown with 1 posts (2 thanks)
    1. trending_up 2,572 views
    2. thumb_up 3 thanks given
    3. group 1 followers
    1. forum 3 posts
    2. attach_file 0 attachments




 
Search this Thread
  #1 (permalink)
 
Cogito ergo sum's Avatar
 Cogito ergo sum 
Amsterdam
 
Experience: None
Platform: QuickStrike, CTS
Trading: Derivatives
Posts: 195 since Jul 2010
Thanks Given: 227
Thanks Received: 214

Hello,

I intend to conduct some vol related research on several ETFs and their options in order to further develop a gamma scalping strategy.

Which tool(s) would be the most useful/ robust to pick up and learn for this purpose? Please note that I am not a talented programmer, however I do have some basic knowledge of VBA. Would you recommend: Rstudio, Matlab, Mathematica, others?
If so, where would you recommend me to start learning about your selected platform?

Thank you for your input.


Started this thread Reply With Quote

Can you help answer these questions
from other members on NexusFi?
Trump Media to sell instant access to market-moving soci …
Traders Hideout
Irans Answer Due Today: Peace Surges to 33.5%, Invasion …
Prediction Markets & Event Contracts
Wood Mackenzie Drops $200 Oil Forecast -- Airspace Expir …
Prediction Markets & Event Contracts
Trump Truth Social Fires Hormuz From 10% to 59% -- Arsen …
Prediction Markets & Event Contracts
Fed Hike Odds at 57% After Warsh: England Surges 12.9%, …
Prediction Markets & Event Contracts
 
Best Threads (Most Thanked)
in the last 7 days on NexusFi
NexusFi site changelog and issues/problem reporting
8 thanks
Darmok and Jalad at Tanagra
1 thanks
  #3 (permalink)
 
Big Mike's Avatar
 Big Mike 
Manta, Ecuador
Site Administrator
Developer
Swing Trader
 
Experience: Advanced
Platform: Custom solution
Broker: IBKR
Trading: Stocks & Futures
Frequency: Every few days
Duration: Weeks
Posts: 50,669 since Jun 2009
Thanks Given: 33,669
Thanks Received: 102,577



Cogito ergo sum View Post
Hello,

I intend to conduct some vol related research on several ETFs and their options in order to further develop a gamma scalping strategy.

Which tool(s) would be the most useful/ robust to pick up and learn for this purpose? Please note that I am not a talented programmer, however I do have some basic knowledge of VBA. Would you recommend: Rstudio, Matlab, Mathematica, others?
If so, where would you recommend me to start learning about your selected platform?

Thank you for your input.

I would say R, it has everything you need as available package to download daily data for ETF's from Yahoo and then crunch it.

Do a search for R quantmod and R TTR.

Mike




We're here to help: just ask the community or contact our Help Desk

Quick Links: Change your Username or Register as a Vendor
Searching for trading reviews? Review this list
Lifetime Elite Membership: Sign-up for only $149 USD
Exclusive money saving offers from our Site Sponsors: Browse Offers
Report problems with the site: Using the NexusFi changelog thread
Follow me on X Visit my NexusFi Trade Journal Reply With Quote
Thanked by:
  #4 (permalink)
 
ericbrown's Avatar
 ericbrown 
Tulsa, OK
 
Experience: Advanced
Platform: Tradestation, TOS, Python
Broker: IQFeed, Tradestation, TOS
Trading: ES, SPY, Options
Posts: 201 since Jan 2011
Thanks Given: 339
Thanks Received: 258

Similar to R, you can use Python. Take a look at pandas for python...you'll get all sorts of goodies including ability to pull down data from Google or Yahoo.

If starting from scratch, either R or Python will work well fro what you need.


Follow me on X Reply With Quote
Thanked by:




Last Updated on December 5, 2013


© 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