Premium Essay

Msc Student

In:

Submitted By ollebolle
Words 9854
Pages 40
DATASTREAM ADVANCE FOR OFFICE 5

USING EXCEL
ISSUE 3

Datastream Advance for Office

CONTENTS
1 Using Excel with Datastream Advance for Office Setting the Excel Add-In system options Creating data requests in Excel Creating static data requests Selecting datatypes Selecting lists Selecting expressions Creating time series requests Using lists with time series requests Using functions and expressions with time series requests Selecting expressions Selecting dates Creating expression using Intellisense feature Using Expression Editor in static and time series dialogs Creating Company accounts data requests Shortcuts when entering request details Format options Format options for static and time series requests Editing an embedded data request 2 Using lists 3 3 6 8 9 10 10 11 11 12 12 13 13 15 17 17 18 18 19 21

Creating a Local list from a set of codes (Datastream, ISINs, SEDOLs, etc) in Excel (for example from a back office system) 21 3 Using Expressions The Expression Picker Using the Expression Builder 4 Using the Request Manager Editing an embedded chart Changing the properties of a chart using VBA 5 Using the Request Table What is the Request Table? Creating a set of requests Request Table options Upload List button The Series Navigation button Processing and Scheduling requests The AFO Index User created time series The user created time series template: Creating a user created time series Editing an existing user created time series 6 Using Ribbon based UI for AFO (in MS-Office 2007 and above) 22 22 22 24 24 26 27 27 28 30 31 31 32 32 33 33 34 35 36

Using Excel with Datastream Advance for Office

1 USING EXCEL WITH DATASTREAM ADVANCE FOR OFFICE
SETTING THE EXCEL ADD-IN SYSTEM OPTIONS
System options are available for you to control the way you use the Excel Add-In and how data is presented. These options include: Request Format options Menu

Similar Documents

Free Essay

Msc Student

...CH02CH19-Yarmush ARI 12 May 2011 ANNUAL REVIEWS 15:43 Further Annu. Rev. Chem. Biomol. Eng. 2011.2:403-430. Downloaded from www.annualreviews.org Access provided by Imperial College London on 01/18/16. For personal use only. Click here for quick links to Annual Reviews content online, including: • Other articles in this volume • Top cited articles • Top downloaded articles • Our comprehensive search Tissue Engineering and Regenerative Medicine: History, Progress, and Challenges Francois Berthiaume,1 Timothy J. Maguire,1 ¸ and Martin L. Yarmush1,2 1 Department of Biomedical Engineering, Rutgers, The State University of New Jersey, Piscataway, New Jersey 08854; email: ireis@sbi.org 2 Center for Engineering in Medicine, Massachusetts General Hospital, Boston, Massachusetts 02114 Annu. Rev. Chem. Biomol. Eng. 2011. 2:403–30 Keywords First published online as a Review in Advance on March 17, 2011 artificial organs, skin, cartilage, liver, stem cells The Annual Review of Chemical and Biomolecular Engineering is online at chembioeng.annualreviews.org Abstract This article’s doi: 10.1146/annurev-chembioeng-061010-114257 Copyright c 2011 by Annual Reviews. All rights reserved 1947-5438/11/0715-0403$20.00 The past three decades have seen the emergence of an endeavor called tissue engineering and regenerative medicine in which scientists, engineers, and physicians apply tools from a variety of fields to construct biological ...

Words: 6720 - Pages: 27

Free Essay

Ict in Malaysia

...MALAYSIA: POLICY, REGULATION & INDUSTRY PROGRESS (1996-2000) AND PROSPECTS (2001-2005) Presented by Gazali Abas at ITU-Waseda University Workshop for Regulators and Policy-Makers “New Trends in ICT” 13th-24th November, 2001 Waseda University Tokyo, JAPAN CONTENTS 1. 2. 3. 4. 5. INTRODUCTION PROGRESS (1996-2000) PROSPECTS (2001-2005) ALLOCATION CONCLUSION 14 Nov.2001.Gazali A. 2 1. INTRODUCTION THE BIG PICTURE - Human Capital 23 m - Vision 2020 - Long-term Outline Perspective Plan - Five-year Development Plan - K-Economy - ICT policy, regulation and industry 14 Nov.2001.Gazali A. 3 2. PROGRESS, 1996-2000 1. 2. 3. 4. 5. 6. 7. 8. Utilization of ICT National IT Agenda Development of the Multimedia Super Corridor MSC Flagship Applications Development of Communications Infrastructure Electronic Commerce Human Resource Development for ICT Funding for ICT Industry 14 Nov.2001.Gazali A. 4 2.1.1 - UTILIZATION OF ICT: ICT Expenditure by Sector, 1995-2000 Total expenditure on ICT increased 9.2% p.a. in 1996-2000. Big spenders on ICT: 1995 2000 AAGR Banking & Finance 27% 15% -4% Manufacturing 13% 16% 19% Distributions 8% 10% 16% Government 10% 8% 7% Home 2% 8% 44% 14 Nov.2001.Gazali A. 5 2.1.2 - SELECTED ICT INDICATORS, 1995-2000 Indicator PC (units installed) PC per 1,000 pop. Tel.lines/1,000 pop. Tel.Subscribers Mobile Phones Internet Subscribers 14 Nov.2001.Gazali A. 1995 610,000 29.5 161.7 3,332,447 700,000 13,064 2000 2,200,000 95...

Words: 2334 - Pages: 10

Premium Essay

Market Research

...Preece We certify that this assignment is the result of our own work and does not exceed the word count noted below. Number of words __2554____________ (excluding appendices/bibliographies, tables and diagrams) Executive Summary This research had the intention to find out whether the launch of a new student discount card was feasible or not, and what students’ expectations of this card would be. This was then broken into this three marketing research objectives: 1. To understand students’ needs 2. To examine their attitudes towards and usage of the existing competitor card (the NUS Extra card) 3. To measure potential demand The focus group results pointed out that existing NUS Extra card holders were rather pleased with their card, but that they found the discounts provided by the card rather lacking. Those that did not have an NUS Extra card were unaware of the concept and put more emphasis on supermarkets, bookstores and various online shops. During the questionnaire, we interviewed 100 students. But we could hardly find students having the NUS Extra card already. Hence, only 8 respondents had an NUS Extra card. Of the remaining 92 students, the majority indicated that they had never heard of the concept. Others however indicated that they saw little advantage over the discounts offered by the standard NUS card. Fields of discount that the non-cardholders are interested in are mostly travel and bookstores, with groceries, clothing and food &drink...

Words: 6817 - Pages: 28

Free Essay

The Relationship Between Students’ Study Habits, Happiness and Depression

...The relationship between students’ study habits, happiness and depression Susan Bahrami, PhD,* Saeed Rajaeepour, PhD,** Hasan Ashrafi Rizi, PhD,*** Monereh Zahmatkesh, BA,**** and Zahra Nematolahi, BA**** Author information ► Article notes ► Copyright and License information ► This article has been cited by other articles in PMC. ------------------------------------------------- Abstract BACKGROUND: One of the important requirements for cultural, social and even economic development is having a book-loving nation. In order to achieve this, there is a need for purposeful and continuous programming. The purpose of this research was to determine the relationship between students’ study habits, happiness and depression in Isfahan University of Medical Science. METHODS: This research was a kind of descriptive and correlation survey. Statistical population included all MSc and PhD students in the second semester of the Isfahan University of Medical Science (263 students). In this research, stratified and random sampling was used in which a sample of 100 students was selected. Data collection instruments were Beck Depression Inventory (BDI), Oxford Happiness Inventory and a researcher-made questionnaire to determine the amount of students’ study. Validity of this questionnaires was determined by structure and content related validity and its reliability was calculated by Cronbach's alpha coefficient for the first (r = 0.94), second (r = 0.91) and third (r = 0.85) questionnaire...

Words: 2542 - Pages: 11

Free Essay

420 Syllabus

...applied; this is a level course in operational management. Learn basics issues pertaining to the operations management Learn important areas of operations management such as inventory management, project management, MRP etc Learn basics of decision making tools such as forecasting and linear programming This course is an attempt to blend quantitative reasoning with practical decision-making applications. Prerequisite: It is the student's responsibility to be aware of and meet all prerequisites for LCOB courses. By remaining in the course beyond the regular registration period, the student certifies that he/she has met all prerequisites. Students registered for courses without having met prerequisites will be considered to have committed Academic Dishonesty as defined by the Marshall University Student Handbook. Sanctions may include a grade of "F" in the course for which the student has not met the prerequisite or suspension from the university. The dean's office reserves the right to administratively withdraw...

Words: 1500 - Pages: 6

Free Essay

Business

...Studies Prof. Dr. S. M. Abbas Faculty of Medicine Prof. Khursheed A. Hashmi Faculty of Law Prof. Dr. Darakhshan J. Haleem – Dean Faculty of Science (Caretaker) Faculty of Engineering Prof. Dr. ZafarIqbal – Dean Faculty of Arts (Caretaker)Faculty of Education University of Karachi Page 3 ADMISSION PROSPECTUS STUDENTS’ STUDENTS’ AFFAIRS o look after students affairs, in general, and to supervise their extra-curricular activities in particular, an office of Advisor Students’ Affairs is situated at the first floor of the Administration block. Teachers and the staff are available for the students’ guidance. 2012 M.Phil./Ph.D theses to students of various departments of the University. LEJ Digital Library is also available at the campus that can be used by all the students to access a large number of books or journals on-line. T Transport: Over 24,000 students come to the campus from different parts of the city on daily basis. It is difficult to facilitate every student with the transport facility. However, the University tries its best to provide a limited transport facility to its students. Schedule of point buses that provide pick and drop service to the students, at highly subsidized fare, is announced by the transport office in...

Words: 40778 - Pages: 164

Premium Essay

Student

...Student Handbook 2015/2016 www.praguecollege.cz Table of Contents Introduction Message from the Director Mission, Vision and Values Why study at Prague College Admissions A short guide to Prague College qualifications English for Higher Education Foundation Diploma in Business Foundation Diploma in Computing Foundation Diploma in Art & Design Professional Diplomas in Business Professional Diplomas in Computing Higher National Diploma BA (Hons) International Business Management BA (Hons) International Business Management (Flexible Study Programme) BA (Hons) Business Finance & Accounting BA (Hons) Graphic Design BA (Hons) Fine Art Exp. Media BSc (Hons) Computing BA (Hons) Communications & Media Studies MSc International Management MSc Computing Accreditation & Validation UK/Pearson Credit system Transfer of credits Student support Accommodation Study Advising and Support Financial support Visas for foreign students Scholarships Benefits for students Study abroad Internships Assistance in employment Counselling Centre Student Resources Computer labs Online Learning Centre (Moodle) Prague College email Physical library Digital Library ISIFA Images Textbooks and class materials Graphic Design/Interactive Media/Fine Art materials and costs Personal computers Message boards and digital signs Newsletters Open lectures, seminars and events Student ID cards Centre for Research and Interdisciplinary Studies (CRIS) Prague...

Words: 27092 - Pages: 109

Free Essay

Handbook

...School of Health and Education Secondary PGCE   Programme  Handbook   2015-16 Student Name: Programme Leader: Eddie Ellis PGCE Secondary Programme Handbook 2015-16 Information in alternative formats This handbook can be found online at: https://myunihub.mdx.ac.uk/web/homecommunity/mystudy If you have a disability which makes navigating the website difficult and you would like to receive information in an alternative format, please contact http://unihub.mdx.ac.uk/support/disability/i ndex.aspx Sections from this publication can be supplied as: • a Word document with enlarged type — sent by email or supplied on a CD or memory stick • printed copy with enlarged type • printed copy on non-white paper • as Braille Other formats may be possible. We will do our best to respond promptly. To help us, please be as specific as you can about the information you require and include details of your disability. PGCE Secondary Programme Handbook 2015-16 Purpose and status of your student programme handbook The purpose of this handbook is to provide you with information about your programme of study and to direct you to other general information about studying at Middlesex University, the majority of which is available on UniHub. The material in this handbook is as accurate as possible at the date of production however you will be informed of any major changes in a timely manner. Your comments on any improvements to this handbook are welcome. Please put them in writing...

Words: 35401 - Pages: 142

Free Essay

Personal Responsibility and College Success

...Personal responsibility and college success are both important. In order to make college a successful endeavor, one must take responsibility for completing all that is required to the best of one’s ability. Each college student is responsible for completing their assignments and other requirements in a timely manner. Personal responsibility also means that personal college goals must be set. Once the goals have been determined, the college student can figure out what is necessary to reach those goals. A plan of action and a timeline to reach each goal is also a personal responsibility to make college a success. Although people rarely set aside time, personal responsibility is an integral element for college success. One must set time aside to set goals, and to determine a plan to achieve success form the college experience. Personal responsibility and college success is one main key element when furthering ones education. Personal responsibility is when one sets time aside, makes personal goals and know why one wants to succeed in their college experience. It is important for one to identify the purpose of going to college, so that one can have something to look back on when one feels the urge to give up. College success is essential in obtaining ones degree, completing ones scheduled classes and obtaining a satisfactory grade to one expectations. One must determine why college success is important. Some examples are obtaining a higher salary and a more reliable occupation...

Words: 440 - Pages: 2

Premium Essay

Educational Industry Background in Uk

...Name: Saeed Salam Student ID: 3780064 Hand in date : 13 Jan 2012 Effect of Ecommerce on companies and the Industries they operate in Individual Course Work- 1 Table of Content: Educational Industry Background………………………………………………… 3 Company Background………………………………………………………………5 Context Diagram……………………………………………………………………..7 Discussion of Ecommerce…………………………………………………………..9 Legislation……………………………………………………………………………12 Reference and Evidence…………………………………………………………….15 Educational Industry Background in UK At recent times, the world economics in increasing rapidly which results in more demand for talents. Many countries around the world face extreme issue over education. Governments of different country have discovered that education institute is very important in modern world. The UK government has introduced a system of national education in 1957 to create world class education. Education in UK is divided into three categories, which are; primary education, secondary education and higher education. Primary education is the first stage of education which is usually known as pre-school or nursery. Primary education is the first stage of compulsory studies. One needs to complete primary education in order to get admitted in secondary education. Secondary education is the final stage of compulsory studies. GCSE’s are a set of exam which is conducted end of secondary education. After secondary education comes the higher study which refers to college and universities and...

Words: 3388 - Pages: 14

Premium Essay

Life as a Male Asian Student

...Life as a Male Asian Student Texas State University – San Marcos COMM 1310: Fundamentals of Human Communications Melissa Novak Life as a Male Asian Student My name is Tao Zhèng, and I am a 19-year-old male attending school in America. I lived in Japan until I was 16, and then moved to America to attend an American university and expand my education. I tend to spend the majority of my days either at school or focusing on my studies at home. My parents are very strict and take my schooling very seriously. Typically, It’s my mom who pushes my academic success. Dad always says it would be her fault if I did not succeed so I do everything I can to not let her down. I don’t see my father much, maybe around three hours a day. But it’s okay because I know he’s working to provide our family with the best care and make us proud (Cohen 2011). (Question 1) When I wake up, I start out my morning with looking at my schoolwork and seeing what I need to do for the day and plan accordingly. My parents and family back home in Japan have high expectations for me and I want to do everything I can to impress them. I then attend all of my classes back to back because I’m taking twenty credit hours; my plan is to graduate this December. After I finish my classes, I head up to the library for three back to back Asian centered study groups. My friends and I help each other out a lot; I have found that we compliment each other well because we experience the same stereotypes and can help one...

Words: 1082 - Pages: 5

Premium Essay

Five Rules of Student Engagement for Effective University Marketing

...Five rules of student engagement for effective university marketing Can marketing help in tackling falling university applications? John Newbold offers tips on attracting your target audience Establish a link between interests and careers The end goal of most prospective university students is not attending lectures for a few years; but eventually to embark on a career and, more specifically, a career they are passionate about. Recent social media coverage has emphasised the point that career success and happiness comes from pursuing what interests you, rather than what might seem a good idea from other people's perspective (teachers / parents / politicians). One video currently doing the rounds on Facebook simply asks the question: "What if money was no object?" When marketing to potential students, universities should draw this link between student passions and potential careers. Higher education institution Birmingham Metropolitan College's latest campaign achieves this well, with the strapline "Let what you love become what you do". Similarly, Staffordshire University has this week launched a new graduate campaign spanning TV, cinema, press, radio and digital advertising. The idea is to show students that Staffordshire University is committed to their success beyond graduation. Don't talk down to prospective students Avoid falling into the trap of applying your own experiences of university to today's students, even if your university days were only five or...

Words: 1114 - Pages: 5

Premium Essay

Grades and Money

... Morr/Pg.1 A Response to Steven Vogel “Grades and Money” Many students see grades as the single most important thing in life. But what about that other most important thing in life called money? It is easy to say that grades and money have a relationship between them. As a student myself, I can see the relationship between both of these. In Steven Vogel’s Grades and Money he makes many points that I agree with such as grades should be reports, GPA’s and grades are considered funny money. In Vogel’s essay he stated many great points about the relationship between grades and money. I strongly agree when Vogel states “What grades ought to be is a report, nothing more: how did the students do, how much did he or she learn, how much were his or her skills and critical self-consciousness and knowledge of the world expanded”? (Vogel 390). What Vogel’s trying to say in his text is that instead of giving out an A or a C, Let’s focus our attention on how the student has learned. Let’s see if the student learned anything at all. We have to remind ourselves that most students thrive off of knowing what their final grade will turn out to be. They need to know this to evaluate themselves, so they can be better students. I would agree with Vogel when he says grades should be a report. They should not determine whether we pass or fail a class. It is just a simple way for teachers to be...

Words: 1204 - Pages: 5

Premium Essay

Motivation

...Critical Review of the Article “The changing body of students - A study of the motives, expectations and preparedness of postgraduate marketing students” The fact is that the body of postgraduate marketing students, who decide to study in UK, has become much more different during the last few years. It means that British marketing educators are facing big challenges as well as great opportunities. In order to help the educators keep up with the pace of the change, researches about the postgraduate marketing students have been conducted. According to Liu (2010), the article - “The changing body of students - A study of the motives, expectations and preparedness of postgraduate marketing students” aims at finding out the possible implications for the educators by evaluating the motives, expectations and preparedness of the postgraduate marketing students in UK, and through this, the marketing educators could design their programme better. This paper will try to analyse the article and give a critical review for it. Even facing with the challenges from counterparts such as American universities and Asian domestic universities (Liu, 2010), the trend is that numbers of the postgraduate students in UK including those, who major in marketing, have still increased dramatically. More students choose to take a postgraduate programme in UK, particularly on taught programme (Liu, 2010). Taylor (2002) states that comparing with undergraduates, numbers of postgraduates increase more...

Words: 297 - Pages: 2

Premium Essay

Raising a Successful College Student

...Raising a Successful College Student Carol Woods GEN/200 In order to be a successful college student personal responsibility must be learned at an early age. Children must learn personal responsibility, time management skills, and family values when they are young. If children develop a strong responsibility foundation they will develop into a successful college student. Personal responsibility is something that is taught to you throughout your childhood and developed throughout your adult life. A child is taught family values daily from the time they begin to walk. Parents begin to pass on their own values system and this is what a person’s responsibility foundation is built on. In order for a student to be successful in their college career they must already have been taught personal responsibility throughout their childhood. Children should be given household chores at a very young age, like picking up their toys, making their beds, and even feeding the family pet, at this age they are exposed to the family values at its core. Children begin to realize what responsibility is through these chores. Experts believe that any type of household responsibilities, are important for kids (Dunnewind, 2004). When they develop into adolescence they should be given more responsibility. School work becomes a priority, social groups draw their interest and now they begin to develop their time management skills. Learning how to navigate between class assignments...

Words: 1196 - Pages: 5