VBA Excel Enhanced Lookup user defined function

Completado Publicado Nov 9, 2015 Pagado a la entrega
Completado Pagado a la entrega

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

Nº del proyecto: #8868385

Sobre el proyecto

25 propuestas Proyecto remoto Activo Nov 10, 2015

Adjudicado a:

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 Más

€100 EUR en 1 día
(603 comentarios)
8.3

25 freelancers están ofertando un promedio de €108 por este trabajo

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 Más

€85 EUR en 3 días
(258 comentarios)
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 Más

€80 EUR en 3 días
(230 comentarios)
7.4
someka

Bir öneri henüz sağlanmadı

€147 EUR en 3 días
(143 comentarios)
7.1
TonmoyRoy111

A proposal has not yet been provided

€50 EUR en 3 días
(256 comentarios)
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 en 4 días
(193 comentarios)
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 Más

€80 EUR en 1 día
(98 comentarios)
6.0
muzammil21

A proposal has not yet been provided

€155 EUR en 3 días
(23 comentarios)
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 en 3 días
(18 comentarios)
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 Más

€100 EUR en 2 días
(11 comentarios)
4.2
vishaltile

A proposal has not yet been provided

€111 EUR en 2 días
(3 comentarios)
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 Más

€111 EUR en 0 días
(7 comentarios)
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 en 1 día
(9 comentarios)
3.4
vw1702486vw

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

€115 EUR en 4 días
(2 comentarios)
2.4
sheikh780

A proposal has not yet been provided

€155 EUR en 3 días
(28 comentarios)
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 Más

€50 EUR en 3 días
(1 comentario)
1.4
TAJAMMALMEHMOOD

A proposal has not yet been provided

€230 EUR en 3 días
(0 comentarios)
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 en 3 días
(0 comentarios)
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 Más

€34 EUR en 1 día
(0 comentarios)
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 Más

€100 EUR en 2 días
(0 comentarios)
0.0
vladastankovic

A proposal has not yet been provided

€70 EUR en 1 día
(0 comentarios)
0.0