VBA Excel Enhanced Lookup user defined function

เสร็จสมบูรณ์ โพสต์แล้ว Nov 9, 2015 ชำระเงินเมื่อจัดส่ง
เสร็จสมบูรณ์ ชำระเงินเมื่อจัดส่ง

ENHANCED LOOKUP EXCEL VBA USER DEFINED FUNCTION

- In a "source" sheet are downloaded financial data for multiple securtities. Example: date, volume, close, high, low

- For each security, the subset of data may be different:

Example:

security 1 has a set of monthly close price only (Column A: Date, Column B: Price)

security 2 has daily prices with high, low, volume, close (Column D: Date, Column E: High, Column F: Low etc.)

- We want to develop a VBA excel user defined function as follows:

Value = DataPoint(Sheetname of Database; Ticker; Field; Date)

- Clean example of the data source and it's format is provided, as well as how we want the function to work in the attached spreadsheet

- We want the code to be visible in the vb editor

- BEWARE:

(i) this is not a plain "indexmatch" type of function as the funtion will need to identify a correct subset of data within a data source sheet first

(ii) however this is a reasonably easy job for the right VBA experienced freelancer

(iii) we are open to have REASONABLE format constraint on the source of data

Excel Microsoft Office Visual Basic

หมายเลขโปรเจค: #8868385

เกี่ยวกับโปรเจกต์

25 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

มอบให้กับ:

jaylancer43

Hello Manal, Its a privilege to get opportunity to work with you again. I have duly understood the concept and the requirements of the advanced search "Function" that you need here. It can be done and considering th เพิ่มเติม

€100 EUR ใน 1 วัน
(603 รีวิว)
8.3

freelancer 25 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ €108

seaanddream

Hi, my name is Sevinc. I read your excel VBA pfunction roject descriptions carefully before bidding. I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel an เพิ่มเติม

€85 EUR ใน 3 วัน
(258 รีวิว)
7.6
bouslimi1979

Dear, I m studying the description you provided here and in the Excel file. I need few minutes to understand the logic and provide a clear answer. Also please feel free to speak French if you like. Can you open a discu เพิ่มเติม

€80 EUR ใน 3 วัน
(230 รีวิว)
7.4
someka

Bir öneri henüz sağlanmadı

€147 EUR ใน 3 วัน
(143 รีวิว)
7.1
TonmoyRoy111

A proposal has not yet been provided

€50 EUR ใน 3 วัน
(256 รีวิว)
6.5
DeepSyaal

Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?

€100 EUR ใน 4 วัน
(193 รีวิว)
6.4
gokulanand

Hello I went through your description provided and it looks like very much doable for me. I can get you this function( datapoint) written using VBA Programming. However, you can use this as a simple formula from เพิ่มเติม

€80 EUR ใน 1 วัน
(98 รีวิว)
6.0
muzammil21

A proposal has not yet been provided

€155 EUR ใน 3 วัน
(23 รีวิว)
5.5
lashabuxo

I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it | I can do it |

€30 EUR ใน 3 วัน
(18 รีวิว)
4.7
VinayOnTask

Hi there, I’d like to be considered for your bid. I am a software developer with a strong background developing excel, access related applications, including excel functions,active x objects, sql server as backend, dat เพิ่มเติม

€100 EUR ใน 2 วัน
(11 รีวิว)
4.2
vishaltile

A proposal has not yet been provided

€111 EUR ใน 2 วัน
(3 รีวิว)
3.8
naseefo

Hi there! I am an expert in MS Excel with programming capabilities for macros with VBA. I am presently available to take your work and can submit within a short time, possibly in few hours. You shall have a well com เพิ่มเติม

€111 EUR ใน 0 วัน
(7 รีวิว)
3.5
rikari000813

Hi, I already have the file ready. I was able to create the formula that you need. Please send a message so that we can discuss and I can send my initial draft to you. Thanks.

€44 EUR ใน 1 วัน
(9 รีวิว)
3.4
vw1702486vw

I have read and fully understood your requirements.. Please open chat to discuss further.. ========================================================================

€115 EUR ใน 4 วัน
(2 รีวิว)
2.4
sheikh780

A proposal has not yet been provided

€155 EUR ใน 3 วัน
(28 รีวิว)
2.1
toanand

Hi , Hope you are doing well! My name is Anand Kr Singh and have more than 10 years of experience in IT industry. I have very good experience for develop GUI tools. Please trust on my work. -- I have alre เพิ่มเติม

€50 EUR ใน 3 วัน
(1 รีวิว)
1.4
TAJAMMALMEHMOOD

A proposal has not yet been provided

€230 EUR ใน 3 วัน
(0 รีวิว)
0.0
gotoole

with over 18 years of experience in Excel and advanced Visual Basic/VBA skills, immediate availability and understanding of need for accuracy and reliability, I feel I am the best candidate for this project

€155 EUR ใน 3 วัน
(0 รีวิว)
0.0
capreze

I'm a professional graphics and web developer, I do websites both front ends and back ends, advertising, books, magazines, posters, computer games, product packaging, exhibitions and displays, corporate communications เพิ่มเติม

€34 EUR ใน 1 วัน
(0 รีวิว)
0.0
alexhulke

Hello, I am an electrical engineer from the United States. I am experienced in building Excel spreadsheets with VBA functionality through my professional experience as an engineer. I have written many VBA programs เพิ่มเติม

€100 EUR ใน 2 วัน
(0 รีวิว)
0.0
vladastankovic

A proposal has not yet been provided

€70 EUR ใน 1 วัน
(0 รีวิว)
0.0