Find Jobs
Hire Freelancers

volatility band spreadsheet(repost)

$30-5000 USD

Cancelado
Publicado hace casi 16 años

$30-5000 USD

Pagado a la entrega
Here is my original request below, however it can also be some way other than excel.? ? If someone has a better idea then please suggest it. I need an excel spreadsheet programmed that downloads data from [login to view URL] for option data for various stock symbols.? It figures out the implied volatility for the at the money option and then figures out the volatility bands from the implied volatility.? Once the implied volatility is found the calculation for the volatility bands is very simple.? There are currently excel add ins that already can calculate implied volatility given the option data.? ? As far as? I see it, there are 2 ways to do it.? I like one way better but I am open to suggestions. ? The first way is to use the data from [[login to view URL]][1].? They? provide the information on their basic account which is free.? I have included a screen shot of the info that I need.? Once i have the mean implied volatility, the calculation for the volatility bands is very simple.? What I need to happen is that my spreadsheed will gather the data for maybe 100 different symbols that i am watching and calculates the bands for each symbol.? The way I would rather do it is to just grab the at the money options data from [[login to view URL]][2].? Then I have excel add in's that will calculate the implied volatility which is then used for the band calculations.? The excel add ins are from <[login to view URL]> What I would love to happen is to have a list of symobls that I want the data calculated on 1 tab.? Excel will then go out and download the datat using the excel add in and determine the at the money option and calculate the mean implied volatility.? Then it is a very simple calculation to get a volatility band.? Once the program is done running, it lists all the stock symbols on another tab with the volatility bands listed for each stock next to the symbol.
ID del proyecto: 3930336

Información sobre el proyecto

2 propuestas
Proyecto remoto
Activo hace 16 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
2 freelancers están ofertando un promedio de $40 USD por este trabajo
Avatar del usuario
See private message.
$38,25 USD en 14 días
4,9 (15 comentarios)
3,3
3,3
Avatar del usuario
See private message.
$42,50 USD en 14 días
0,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
5,0
6
Miembro desde ene 28, 2006

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.