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 Quick Summary with 1 posts (0 thanks)
    2. looks_two ericbrown with 1 posts (2 thanks)
    3. looks_3 Big Mike with 1 posts (1 thanks)
    4. looks_4 Cogito ergo sum with 1 posts (0 thanks)
    1. trending_up 1,603 views
    2. thumb_up 3 thanks given
    3. group 1 followers
    1. forum 3 posts
    2. attach_file 0 attachments




 
Search this Thread

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

  #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?
Pivot Indicator like the old SwingTemp by Big Mike
NinjaTrader
Trade idea based off three indicators.
Traders Hideout
ZombieSqueeze
Platforms and Indicators
Trend Direction Force Index (TDFI)
Platforms and Indicators
Cheap historycal L1 data for stocks
Stocks and ETFs
 
  #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,463 since Jun 2009
Thanks Given: 33,239
Thanks Received: 101,662



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



Join the free Markets Chat beta: one platform, all the trade rooms!

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 Twitter 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 Twitter Reply With Quote
Thanked by:




Last Updated on December 5, 2013


© 2024 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 - Privacy Policy - Downloads - Top
no new posts