Đang Thực Hiện

Excel 2010 macro defining pivot table data source

I'm looking for a Excel wizard to develop a macro that will create a pivot table in excel 2010. Neither excel user is good with pivot tables so we some other approach may be worth discussing.

That said, I will attempt to explain the task below and some of the functional requirements of the excel macro dynamic pivot table.

So here goes:

The data. I have a data source in excel (financial metrics) from bloomberg professional, which are pulled into a specific format, the data period is the column header and the ticker is the row label.

The first major requirement is that a pivot table is created in a format that is "regression-ready" -- that is an X column and a Y column. The objective is to use the pivot table as the source for Excel's data analytic regression function.

The second requirement is that the pivot table's data source is dynamically set according to the number of tickers and number of periods. Example, the number of rows is based on the number of identifiers, i.e. tickers. and the number of columns is defined by the number of periods (i.e. 12 months, 10 years, etc). The pivot table needs to be able to have the data source modified and dynamically update with the new data.

I think I want a macro to launch a window that would allow me to simply highlight the number of time units and then the number of identifiers, then (I guess using a pivot table) a new tab would open where the data would automatically be populated into the regression-ready format. I would then be able to quickly run a regression analysis referencing the pivot table X and Y columns.

I would also want to have the ability to eliminate any row that has a ‘zero’ in the ‘X-plot’ column. I’m picturing in the window an ability to place y/n a check on ‘delete column if 0 in x plot?”

Kỹ năng: .NET, Lập trình C#, Excel, Viết báo cáo, Visual Basic

Xem thêm: macro run pivot table excel 2010, macro pivot source, excel 2010 macro pivot table, open-table, m format in excel, looking for a good excel professional, first source, excel user defined function, excel for data analysis, data analysis with excel, data analysis for excel, defining pivot data source macro, pivot table wizard, financial wizard, time table, table, regression, pivot tables, pivot table excel, open source analysis, metrics, macro, macro excel, macro e, macro + excel

Về Bên Thuê:
( 0 nhận xét ) New york, United States

Mã Dự Án: #1620194

Đã trao cho:

ExcelGurus

Hello, I am an Excel expert and this is something I can definitely do for you. Please see additional information in the private message box. Thanks, David

$280 USD trong 2 ngày
(10 Đánh Giá)
5.0

14 freelancer đang chào giá trung bình $352 cho công việc này

bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$250 USD trong 3 ngày
(64 Đánh Giá)
6.5
saamorim

Hi I've got experience in creating graphs, pivot tab and dealing with complex macros in excel. I do have some doubts in order to create a better quote. So, if you can, please have a look at private messages. T Thêm

$250 USD trong 3 ngày
(18 Đánh Giá)
5.4
vbexcel

Excel / VBA pro - ten years of experience.

$250 USD trong 3 ngày
(27 Đánh Giá)
5.3
expertcoder007

Hello, I am Very much interested. Best Regards, Prema.

$250 USD trong 6 ngày
(9 Đánh Giá)
4.8
coolbuddy19

hi I am confident to handle this keenly interested in this

$250 USD trong 2 ngày
(12 Đánh Giá)
4.5
abhinitd

This task is tailor made for me and i can complete it swiftly.

$450 USD trong 4 ngày
(1 Đánh Giá)
1.9
Ethanmartin1

please check pmb

$400 USD trong 4 ngày
(0 Đánh Giá)
0.0
forldvmtg

PLEASE SEE PMB

$350 USD trong 4 ngày
(0 Đánh Giá)
0.0
rubensilio

Hi, I'm a computer engineer / electronic with extensive experience in the programming world, especially in. NET and databases. I have made many desktop and web applications. I'm an expert in programming with Excel, I c Thêm

$700 USD trong 20 ngày
(0 Đánh Giá)
0.0
ETNASoftware

I have couple of developers who would be perfect fit with extended technological background & experience with financial software development & telecom. Examples of work: [url removed, login to view] My firm, ETNA Softw Thêm

$250 USD trong 1 ngày
(0 Đánh Giá)
0.0
ashishpatel1981

I quote 8 USD per hour for this work. Please give me a chance.

$250 USD trong 20 ngày
(0 Đánh Giá)
0.0
ryanbilly

Hello Sir, Please check PMB for listing and confident to complete the project with quality services.. Best Regards

$600 USD trong 10 ngày
(0 Đánh Giá)
0.0
punshar71

i am excellent with excel pivot table creation and with macros, pls cosnider me for this opportunity.

$250 USD trong 1 ngày
(0 Đánh Giá)
0.0
ceromat

Microsoft Office Excel Expert certification: Certification Verification Website wUAcP-k45r [url removed, login to view] List of Skills: (More than ten years of experience with 99% of these skills) -Mathematics Thêm

$400 USD trong 6 ngày
(0 Đánh Giá)
0.0