[ 3 / biz / cgl / ck / diy / fa / ic / jp / lit / sci / vr / vt ] [ index / top / reports ] [ become a patron ] [ status ]
2023-11: Warosu is now out of extended maintenance.

/sci/ - Science & Math

View post   
File: 8 KB, 210x211, index.jpg [View same] [iqdb] [saucenao] [google]
7661273 No.7661273 [Reply] [Original]

i posted the same question in /biz/ sections since it's kinda financial thing.

I have an assignment for my Options class.
Basically i have 5 stocks and their prices for last 250 days. And the portfolio is 1mil with 200k in each stock

I've done Sub Functions in VBA to calculate the log-returns, their mean and variance.

However i need to estimate the opening price of the stock on the following day and also 3 days ahead.

Any1 familiar with VBA and knows any function to write ?

>> No.7661279

>>7661273
Fucking millennials, just read the goddamned documentation. You could've been finished already.

>> No.7661280
File: 53 KB, 599x449, squidward face.jpg [View same] [iqdb] [saucenao] [google]
7661280

> excel

>> No.7661296

>>7661279

if there was anything in them i wouldn't be here asking for some help.

>> No.7661871

>>7661273
Step 1: Copy everything into Open Office
Step 2: Copy and Copy and Copy everthing you find from the web. The Star Basic documentation isn't superb, but there's a wiki.

>> No.7661907
File: 27 KB, 600x551, sad_face_chocolate_bar.jpg [View same] [iqdb] [saucenao] [google]
7661907

>statistics
>using anything but R

>> No.7661914

to give a non-shitposting answer

/sci/ is not for homework answers
/sci/ will SOMETIMES answer your homework if you ask in the right places and the right ways

try the stupid questions thread or /g/'s daily programming thread