Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dam Dam is offline
external usenet poster
 
Posts: 1
Default Seasonal factors

Dear newsgroup member,

I am looking for a way to calculate different seasonal factors in an
easy way on financial assets.

The data I have is the date (MM/DD/YYYY) as well as the daily price.

I define today percentage change as the difference between yesterday
price and todays one

What I am looking for a

The mean, median, top and bottom 5% mean, standard deviation and the
percentage of positive occurence (% of the time where the asset rose) for:

The days of the week (Monday to Friday)
The day of the month with trading taking place (for example the first
day in January with trading, the second day,...)
The day of the month with trading taking place but this time starting
with the last day(last day of the month, ....)
The trading day of the year (1st,2nd,...) (day where I have a price)
the week of the year (first week,...)
the month of the year (January, Febraury,...)

One of the problem is that the date varies depending on the asset as
some are not open a given day when other are,...

Really hope somebody can help me

Have a great day

Dam
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you determine a seasonal index in Excel? [email protected] Excel Worksheet Functions 2 August 8th 07 11:37 PM
How do you determine a seasonal index in Excel? [email protected] Excel Worksheet Functions 0 August 8th 07 10:20 PM
Seasonal Trend Lines Colin Foster Charts and Charting in Excel 4 July 27th 07 11:44 PM
Seasonal factor graph Dam Charts and Charting in Excel 1 April 24th 05 03:48 AM
How to make a forecast for a highly seasonal business? [email protected] Excel Discussion (Misc queries) 1 January 25th 05 08:37 AM


All times are GMT +1. The time now is 03:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"